Senior Data Analyst, Strategic Operations and Performance Management

City of New York • New York, NY

10d • $87,743 - $95,000 • Hybrid

About The Position

The Senior Data Analyst will work in the Office of Strategic Operations and Performance Management (SOPM) within the New York City Department of Health and Mental Hygiene. SOPM supports agency-wide policy implementation and strategic alignment, supplements divisional capacity, and develops and stewards data management tools for public-health programming. The role focuses on provider data, data integration, Salesforce, and analysis of agency administrative and program data. This is a hybrid position requiring work at the Long Island City, New York office at least three days per week; remote schedules are subject to supervisor approval and agency policies.

Requirements

• Meet the stated City Research Scientist qualification requirements: for Assignment Level I, a relevant master's degree in physical, biological, or environmental science or public health; for Assignment Level II and above, a relevant doctorate with one year of responsible supervisory, administrative, or research experience, or a relevant master's degree with three years of responsible full-time research experience, or equivalent education and experience. Under the equivalency provision, candidates must have at least a relevant master's degree and at least two years of the specified experience.
• Commitment to understanding institutional and structural racism and bias and their impacts on underserved and underrepresented communities, and to supporting communities affected by systemic oppression and bias.
• Ability to work collaboratively in a cross-disciplinary team environment.
• Excellent written and oral communication skills.
• Organizational skills and strong 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 data-visualization software.
• Experience analyzing administrative and transactional metadata.
• Background in program analysis or monitoring and evaluation.

Responsibilities

• Develop a data pipeline from the current provider data warehouse to Salesforce using existing technologies and FHIR standards.
• Develop a new provider data warehouse using existing DOHMH data sources.
• Develop and share best practices for integrating provider data.
• Identify additional public provider data to 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 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 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 and applicable approval and policies.
• Job security compared with private-sector employment.

What This Job Offers

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