Senior Data Analyst, Strategic Operations and Performance Management

City of New York • Long Island City, NY

2d • 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’s Office of the Chief Operating Officer. SOPM leads implementation of policy efforts across the agency, supports agency-wide strategies and organizational alignment, supplements divisional capacity, and develops and stewards data management tools for external, partner-facing public health programs.

The role will build and maintain data pipelines and provider data resources, integrate provider data using FHIR standards, and support Salesforce data management and analysis. It will also contribute to cross-divisional data-sharing initiatives and conduct ad hoc analysis of administrative and program outcomes data. This is a hybrid position requiring work at the Long Island City, NY office at least three days per week; remote schedules are subject to supervisor approval and agency policies.

Requirements

• Meet the applicable City Research Scientist qualification for the appointment level: Assignment Level I requires a master's degree from an accredited college or university, specializing in an appropriate field of physical, biological, or environmental science or public health. Assignment Level II and above requires the specified doctorate and experience, master's degree and experience, or equivalent education and experience; all candidates must have at least a master's degree in an appropriate field and at least two years of the specified research experience. Two years as a City Research Scientist Level I may substitute for the experience specified in the qualifications.
• Demonstrate a commitment to supporting communities that have experienced systemic oppression and bias, and an ability to understand institutional and structural racism, bias, and their impacts on underserved and underrepresented communities.
• Attend the Long Island City, NY office at least three days per week.

Nice To Haves

• Demonstrable data analytics skills and familiarity with data management, database design, and statistical analysis concepts.
• 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.
• Excellent written and oral communication skills.
• Ability to work collaboratively in a cross-disciplinary team environment.
• Strong organizational skills and attention to detail.
• Willingness to adapt to changing work priorities and tackle novel problems creatively.

Responsibilities

• Use existing technologies, including R, Python, Pentaho, and SQL, to develop a data pipeline from the current provider data warehouse to Salesforce using FHIR standards.
• Develop a new provider data warehouse from existing DOHMH data sources.
• Develop and share best practices for integrating provider data.
• Identify other public provider data that could enhance the provider data warehouse.
• Design, build, test, and maintain routine ETL (Extract, Transform, Load) 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 perform 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 analysis of administrative and program outcomes data as needed.

Benefits

• Potential eligibility for federal and state loan forgiveness and repayment assistance programs.
• Premium-free health insurance; the posting says this saves employees over $10,000 annually based on a 2024 assessment.
• 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 with steady monthly payments in retirement.
• Tax-deferred savings program.
• Worksite Wellness Program.
• Depending on the position, the possibility of working from home up to two days during the week.
• Job security compared with private-sector employment.

What This Job Offers

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