Senior Data Analyst, Strategic Operations and Performance Management

City of New York • New York, NY

2d • Hybrid

About The Position

The Senior Data Analyst will work in the New York City Department of Health and Mental Hygiene’s Office of Strategic Operations and Performance Management (SOPM), which leads agency-wide policy implementation, supports DOHMH strategies and organizational alignment, and develops data-management tools for external, partner-facing public health programs. The role focuses on provider data integration, warehouse development, Salesforce data management, analysis, and support for agency data-sharing initiatives.

The position is hybrid and requires working from the Long Island City, New York office at least three days per week. Remote schedules require supervisor approval and are subject to agency policy.

Requirements

• For Assignment Level II and above, a doctorate in an appropriate physical, biological, environmental, or social science field plus one year of responsible supervisory, administrative, or research experience; or a master's degree in an appropriate field plus three years of responsible full-time research experience in the field; or equivalent education and experience. Candidates qualifying through the equivalency provision must have at least a master's degree and at least two years of the specified experience.
• For Assignment Level I in physical, biological, or environmental sciences or public health, a master's degree from an accredited college or university with a specialization in an appropriate field.
• Ability to understand institutional and structural racism and bias and their effects on underserved and underrepresented communities, with commitment to supporting communities affected by systemic oppression and bias.
• Excellent written and oral communication skills.
• Ability to collaborate in a cross-disciplinary team environment.
• Strong organizational skills and attention to detail.
• Willingness to adapt to changing work priorities and creatively address novel problems.

Nice To Haves

• Demonstrable data analytics skills and familiarity with data management, database design, and statistical analysis.
• Familiarity with SQL, R, or Python; willingness to learn new technologies and a strong analytical framework are emphasized over prior scripting-language implementation experience.
• Familiarity with data visualization design principles and experience with visualization software.
• Experience analyzing administrative and transactional metadata.
• Background in program analysis or monitoring and evaluation.

Responsibilities

• Develop a data pipeline from the existing provider data warehouse to Salesforce using existing technologies and FHIR standards.
• Develop a provider data warehouse from existing DOHMH data sources.
• Develop and share best practices for integrating provider data.
• Identify public provider data sources that could enhance 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.
• Communicate complex technical data to technical and non-technical stakeholders.
• Link external contact data to existing Salesforce data and conduct quality assurance checks on potential matches.
• Perform deterministic and probabilistic record linking to deduplicate Salesforce data objects.
• Analyze data pipelines and business processes to identify trends and anomalies in Salesforce usage.
• Use Salesforce Reports and Dashboards to summarize information.
• Support cross-divisional data-sharing initiatives as assigned by agency leadership.
• Conduct ad hoc analyses of administrative and program outcomes data.

Benefits

• Potential eligibility for federal or state student loan forgiveness and repayment assistance programs.
• Premium-free health insurance plan.
• Additional health, fitness, and financial benefits may be available depending on the position’s associated union or benefit fund.
• Public-sector defined-benefit pension plan.
• Tax-deferred savings program.
• Worksite Wellness Program.
• Potential to work from home up to two days per week, depending on the position.
• Job security compared with private-sector employment.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior