Senior Data Analyst, Strategic Operations and Performance Management

City of New York; New York (NY); Hybrid; USD 100,000 - 140,000; Full time

Job summary

The New York City Department of Health and Mental Hygiene (NYC Health Department) is seeking a data engineer to design and maintain data pipelines and a provider data warehouse. The role focuses on ETL with Python and Pentaho, and integrating data with Salesforce using FHIR standards.

You will analyze data, perform record linking, and communicate insights to stakeholders while supporting cross-divisional data-sharing initiatives. This is a hybrid role based in Long Island City, NY.

Qualifications

• Master's degree in physical, biological, environmental science or public health.
• Doctorate or Master’s plus 3+ years of full-time research experience or equivalent.
• Two years as City Research Scientist Level I can be substituted for the experience required.

Responsibilities

• Develop data pipelines from provider data warehouse to Salesforce using FHIR standards.
• Develop a provider data warehouse from existing DOHMH data sources.
• Design, build, test, and maintain ETL jobs using Python and Pentaho.
• Perform record linking and QA checks on Salesforce data.
• Produce analyses on data pipelines and Salesforce usage.
• Communicate complex data to technical and non-technical stakeholders.
• Support cross-divisional data-sharing initiatives.

Skills

Data analytics

SQL

Python

R

Data visualization

Communication

Collaboration

Attention to detail

Diversity and bias understanding

Education

Master's degree in public health or related field

Doctorate degree in relevant field

Tools

Python

Pentaho

Salesforce

ETL

SQL

Job description

The New York City Department of Health and Mental Hygiene (DOHMH) is a world-renowned agency with a long tradition of protecting and promoting health in the nation’s most culturally and linguistically diverse city. Our 7,000-plus team members bring an extraordinary array of languages, cultures, and experiences to bear on the work of public health. Our diversity fuels creativity because all perspectives are heard and valued. DOHMH aims to improve the health outcomes of all New Yorkers by centering persistent racial inequities and promotion of social justice at the core of its work. The Office of Strategic Operations and Performance Management (SOPM) in the Office of the Chief Operating Officer for DOHMH is responsible for leading the implementation of policy efforts across the agency. This office supports the overarching strategies of DOHMH, fosters organizational alignment with those strategies, and supplements divisional capacity as needed. SOPM supports the agency’s external, partner-facing public health programming through rapid development, deployment, and stewardship of data management tools.

Duties will include but not be limited to:

• Use existing technologies (R/Python/Pentaho/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 around data integration with provider data
• Identify other public provider data to 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 both technical and non-technical stakeholders
• Perform record linking of external contact data to existing Salesforce data and perform QA checks on potential matches
• Perform deterministic and probabilistic record linking to deduplicate Salesforce data objects
• Produce analyses on data pipelines and business processes to identify trends and anomalies in the usage of Salesforce
• 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

Preferred Skills:

• Demonstrable skills in data analytics; familiarity with concepts on data management, database design, and statistical analysis
• Familiarity with SQL, R, or Python is a plus, but the desire to learn new technologies and possessing a strong analytical framework is more important than experience with implementing scripting languages
• Familiarity with principles of data visualization design and experience with data visualization software
• Experience with 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
• Demonstrated organizational skills and high degree of attention to detail
• Willingness to adapt to new work priorities and tackle novel problems creatively
• Ability to understand the concepts of institutional and structural racism and bias and their impact on underserved and underrepresented communities, along with a demonstrated commitment to supporting communities who have experienced systemic oppression and bias (e.g. people of color, LGBTQ+ people, immigrants, etc.)

Additional Information:

• This is a hybrid position where the individual will be required to come into the Long Island City, NY office at least 3 days a week.
• Please note that remote work schedules are subject to approval by the supervisor and are conditional on agency policies

Why you should work for us:

• Loan Forgiveness: As a prospective employee of the City of New York, you may be eligible for federal/state loan forgiveness and repayment assistance programs that lessen your payments or even fully forgive your full balance. For more information, please visit the U.S. Department of Education’s website (https://studentaid.gov/pslf/)
• Benefits: City employees are entitled to unmatched benefits such as:
  • a premium-free health insurance plan that saves employees over $10K annually, per a 2024 assessment.
  • additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund.
  • a public sector defined benefit pension plan with steady monthly payments in retirement.
  • a tax-deferred savings program and
  • a robust Worksite Wellness Program that offers resources and opportunities to keep you healthy while serving New Yorkers.
• Work From Home Policy: Depending on your position, you may be able to work up to two days during the week from home.
• Job Security - you could enjoy more job security compared to private sector employment and be able to contribute to making NYC a healthy place to live and work.

Established in 1805, the New York City Department of Health and Mental Hygiene (NYC Health Department) is the oldest and largest health department in the U.S., dedicated to protecting and improving the health of NYC. Our mission is to safeguard the health of every resident and cultivate a city where everyone, regardless of age, background, or location, can achieve their optimal health. We provide a wide array of programs and services focused on food and nutrition, anti-tobacco support, chronic disease prevention, HIV/AIDS treatment, family and child health, environmental health, mental health, and social justice initiatives. As the primary population health strategist and policy authority for NYC, with a rich history of public health initiatives and scientific advancements, from addressing the 1822 yellow fever outbreak to the COVID-19 pandemic, we serve as a global leader in public health innovation and expertise.

Come join us and help to continue our efforts in making a difference in the lives of all New Yorkers!

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Minimum Qualifications

1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a 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:
1. A doctorate degree from an accredited college or university 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 in the appropriate field of specialization; or
2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or
3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.
NOTE:
Probationary Period
Appointments to this position are subject to a minimum probationary period of one year.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.