Senior Data Analyst: Strategic Ops & Performance

DEPT OF HEALTH/MENTAL HYGIENE; New York (NY); Hybrid; USD 79,000 - 97,000; Full time

Benefits offered by this job

Loan Forgiveness, including federal

Premium-free health insurance plan

Public sector defined benefit pension

Tax-deferred savings program

Robust Worksite Wellness Program

Job summary

The NYC Department of Health and Mental Hygiene’s Office of Strategic Operations and Performance Management seeks a Senior Data Analyst to support policy implementation by building, deploying, and stewarding data management tools. The role emphasizes data pipelines, provider data warehousing, Salesforce record linking, and analytics through reports and dashboards.

You will develop ETL processes, construct a new provider data warehouse, and translate complex findings for both technical and

Qualifications

• Demonstrable skills in data analytics, with familiarity in data management, database design, and statistical analysis.
• Familiarity with SQL, R, or Python is a plus; strong analytical foundations and interest in learning new technologies are prioritized over scripting experience.
• Familiarity with data visualization design principles and experience with data visualization software.
• Experience analyzing administrative and transactional metadata.
• Background in program analysis or monitoring and evaluation.
• Excellent written and oral communication skills.
• Ability to work collaboratively in a cross-disciplinary team environment.
• Strong organizational skills and attention to detail.
• Ability to understand concepts of institutional and structural racism and bias, and demonstrated commitment to supporting communities impacted by systemic oppression and bias.

Responsibilities

• Develop a data pipeline using R, Python, Pentaho, and SQL that moves data from the current provider data warehouse to Salesforce in alignment with FHIR standards.
• Build a new provider data warehouse using existing DOHMH data sources.
• Develop and share best practices for data integration with provider data.
• Identify additional public provider data sources to strengthen the provider data warehouse.
• Design, build, test, and maintain routine ETL jobs using Python and Pentaho.
• Manage software feature upgrades using project management best practices.
• Translate complex technical findings into clear communication for both technical and non-technical stakeholders.
• Perform record linking between external contact data and existing Salesforce records, including QA checks on potential matches.
• Conduct deterministic and probabilistic record linking to deduplicate Salesforce data objects.
• Produce analyses of data pipeline and business process performance to detect trends and anomalies in Salesforce usage.
• Summarize information using Salesforce Reports and Dashboards.
• Support cross-divisional data-sharing initiatives assigned by agency leadership.
• Complete ad-hoc analyses of administrative and program outcomes data as needed.

Skills

Data analytics

SQL

R

Python

Data visualization

Administrative data analysis

Education

Master's degree

Tools

Pentaho

Salesforce

Salesforce Reports and Dashboards

Job description

The NYC Department of Health and Mental Hygiene’s Office of Strategic Operations and Performance Management seeks a Senior Data Analyst to support policy implementation by building, deploying, and stewarding data management tools. The role emphasizes data pipelines, provider data warehousing, Salesforce record linking, and analytics through reports and dashboards.

You will develop ETL processes, construct a new provider data warehouse, and translate complex findings for both technical and