Senior Data Analyst, Strategic Operations and Performance Management

City of New York • New York, NY

1d • 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 DOHMH strategies and organizational alignment, and provides additional divisional capacity as needed. It also develops and stewards data-management tools for external, partner-facing public health programs.

The role will build and maintain provider-data infrastructure and integrations, including a pipeline from the existing provider data warehouse to Salesforce using FHIR standards and a new provider data warehouse based on DOHMH data sources. The analyst will conduct record linking and deduplication, monitor Salesforce data and processes, produce analyses and reports, and support agency-wide 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 policies.

Requirements

• For appointment to Assignment Level II or above, meet one of the stated qualification pathways: a relevant doctorate and one year of responsible full-time supervisory, administrative, or research experience; a relevant master's degree and three years of responsible full-time research experience; or equivalent education and experience. Under the equivalency pathway, candidates must have at least a relevant master's degree and at least two years of the specified experience. Two years as a City Research Scientist Level I may substitute for the experience required in the first two pathways.
• Appointments are subject to a minimum one-year probationary period.

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.
• 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 priorities and approach novel problems creatively.
• Ability to understand institutional and structural racism and bias and their effects on underserved and underrepresented communities, and demonstrated commitment to supporting communities affected by systemic oppression and bias.

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 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 analyses of administrative and program outcomes data as needed.

Benefits

• Premium-free health insurance plan.
• Additional health, fitness, and financial benefits may be available based on the position’s associated union or benefit fund.
• Public-sector defined-benefit pension plan.
• Tax-deferred savings program.
• Worksite Wellness Program.
• Depending on the position, the ability to work from home up to two days per week.

What This Job Offers

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