Senior Data Analyst, Strategic Operations and Performance Management

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.

Key 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.

Required 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 adapt to new priorities and address novel problems with creativity.
• Ability to understand concepts of institutional and structural racism and bias, and demonstrated commitment to supporting communities impacted by systemic oppression and bias (including people of color, LGBTQ+ people, and immigrants).

Technologies

• R
• Python
• Pentaho
• SQL
• FHIR
• Salesforce
• Salesforce Reports and Dashboards

Benefits

• Loan Forgiveness, including federal/state loan forgiveness and repayment assistance programs to lessen payments or fully forgive eligible balances.
• Premium-free health insurance plan.
• Additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund.
• Public sector defined benefit pension plan with steady monthly payments in retirement.
• Tax-deferred savings program.
• Robust Worksite Wellness Program.

Work Location and Schedule

• Hybrid role based in Queens, NY.
• In-office requirement: come to the Long Island City, NY office at least 3 days per week.
• Remote work may be available up to two days per week, depending on position and subject to supervisor approval and agency policies.

Compensation and Education

Salary: USD 87,743 per year.

Education: master’s degree.

Minimum Qualifications and Appointment Notes

• For Assignment Level I (only physical, biological and environmental sciences and public health): master’s degree from an accredited college or university with 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 a doctorate degree 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; or a master’s degree with specialization in an appropriate field (details continue in the posting).
• Appointments are subject to a minimum probationary period of one year.

Public Service Loan Forgiveness (PSLF)

As a prospective employee of the City of New York, eligibility for federal loan forgiveness programs and state repayment assistance programs may apply. For details, visit: https://studentaid.gov/pslf/.

Residency Requirement

• New York City residency is generally required within 90 days of appointment.
• Certain City employees who have worked for the City for 2 continuous years may be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County.
• Residency applicability should be discussed with the agency representative at the time of interview.