Data Analyst, Bureau Of Strategic Operations & Performance Management

Data Analyst, Bureau of Strategic Operations & Performance Management

Agency: DEPT OF HEALTH/MENTAL HYGIENE

Job Category: Public Safety, Inspections, & Enforcement

Compensation: USD 87,743 - USD 95,000

Job Description

The New York City Department of Health and Mental Hygiene (DOHMH) is a world-renowned agency with a long tradition of protecting and promoting health in the nation's most culturally and linguistically diverse city. Our 7,000-plus team members bring an extraordinary array of languages, cultures, and experiences to bear on the work of public health. Our diversity fuels creativity because all perspectives are heard and valued. DOHMH aims to improve the health outcomes of all New Yorkers by centering persistent racial inequities and promotion of social justice at the core of its work. The Office of Strategic Operations and Performance Management (SOPM) in the Office of the Chief Operating Officer for DOHMH is responsible for leading the implementation of policy efforts across the agency. This office supports the overarching strategies of DOHMH, fosters organizational alignment with those strategies, and supplements divisional capacity as needed. SOPM supports the agency's external, partner-facing public health programming through rapid development, deployment, and stewardship of data management tools.

Job Summary: Under the direction of the Data Engineering Specialist, the Data Analyst will support the agency's partner management system Partners Connect a Salesforce application which stores the agency's community outreach and engagement data as well as select program administration and measurement data. The analyst's focus will be on provider data management. They will build a map of existing provider data sources and develop an integration between existing provider data warehouses and Partners Connect. The Data Analyst will be a primary driver of a data management strategy that promotes data cleanliness and accuracy. They will also analyze and visualize programmatic data and transactional metadata to help the agency better understand its public health initiatives and improve efficiency and functionality. Finally, the Data Analyst will serve as a technical support liaison to health program staff as they integrate their data and business processes into Partners Connect. This role is responsible for gathering requirements, building workflows, training users, and reporting results. The analyst will need to be flexible with respect to the tools and methods utilized. This position will be based at the Health Department's office in Long Island City, NY.

Job Duties:

• Use existing technologies (R/Python/Pentaho/SQL) to develop a data pipeline from the current provider data warehouse to Salesforce using the FHIR API
• Develop a new provider data warehouse from existing DOHMH data sources
• Identify other public provider data to enhance the provider data warehouse
• Design, build, test, and maintain routine ETL (Extract, Transform, Load) jobs using Python and Pentaho
• Manage software feature upgrades using project management best practices
• Communicate complex technical data to both technical and non-technical stakeholders
• Perform record linking of external contact data to existing Salesforce data and perform QA checks on potential matches
• Perform deterministic and probabilistic record linking to deduplicate Salesforce data objects
• Develop and share best practices around data integration with provider data
• Produce analyses on data pipelines and business processes to identify trends and anomalies in the usage of Salesforce
• Use Salesforce Reports and Dashboards to summarize information from both within and outside of Salesforce
• Support cross-divisional data-sharing initiatives as assigned by agency leadership
• Conduct ad-hoc analysis of administrative and program outcomes data as needed

Qualifications

1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health. To be appointed to Assignment Level II and above, candidates must have:

• 1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or
• 2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or
• 3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.

NOTE: Probationary Period Appointments to this position are subject to a minimum probationary period of one year.

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.