Hybrid Senior Data Analyst - Public Health Analytics

City of New York; New York (NY); Hybrid; USD 100,000 - 140,000; Full time

Job summary

The New York City Department of Health and Mental Hygiene (NYC Health Department) is seeking a data engineer to design and maintain data pipelines and a provider data warehouse. The role focuses on ETL with Python and Pentaho, and integrating data with Salesforce using FHIR standards.

You will analyze data, perform record linking, and communicate insights to stakeholders while supporting cross-divisional data-sharing initiatives. This is a hybrid role based in Long Island City, NY.

Qualifications

• Master's degree in physical, biological, environmental science or public health.
• Doctorate or Master’s plus 3+ years of full-time research experience or equivalent.
• Two years as City Research Scientist Level I can be substituted for the experience required.

Responsibilities

• Develop data pipelines from provider data warehouse to Salesforce using FHIR standards.
• Develop a provider data warehouse from existing DOHMH data sources.
• Design, build, test, and maintain ETL jobs using Python and Pentaho.
• Perform record linking and QA checks on Salesforce data.
• Produce analyses on data pipelines and Salesforce usage.
• Communicate complex data to technical and non-technical stakeholders.
• Support cross-divisional data-sharing initiatives.

Skills

Data analytics

SQL

Python

R

Data visualization

Communication

Collaboration

Attention to detail

Diversity and bias understanding

Education

Master's degree in public health or related field

Doctorate degree in relevant field

Tools

Python

Pentaho

Salesforce

ETL

SQL

Job description

The New York City Department of Health and Mental Hygiene (NYC Health Department) is seeking a data engineer to design and maintain data pipelines and a provider data warehouse. The role focuses on ETL with Python and Pentaho, and integrating data with Salesforce using FHIR standards.

You will analyze data, perform record linking, and communicate insights to stakeholders while supporting cross-divisional data-sharing initiatives. This is a hybrid role based in Long Island City, NY.