Company Overview

With an annual budget of $2.3 billion and more than 7,000 employees throughout the five boroughs, the New York City Department of Health and Mental Hygiene (NYC DOHMH) is one of the largest public health agencies in the world, serving 8 million New Yorkers from diverse ethnic and cultural backgrounds. We're tackling a broad range of public health issues with innovative policies and programs and getting exceptional results, but our work is never finished. The breadth of our innovative programs provides the widest range of choices for every member of our team.

With grant funds from the Centers for Disease Control and Prevention (CDC), DOHMH is undertaking a new initiative that will meet critical infrastructure needs and make possible strategic investments that will have lasting effects on public health. Investments and improvements through this initiative will help modernize DOHMH’s foundational capabilities and data infrastructure, enabling it to partner in complex health and health care environments and, in turn, support better public health outcomes, including COVID-19. This initiative supports larger efforts to rebalance investments in public health and more equitably serve communities and populations.

The selected candidate will be an employee of Public Health Solutions, a nonprofit organization which is the fiscal and administrative manager of the grant but will work be supervised by DOHMH. This is a grant-funded position ending in November 2027. This position will be based at the Health Department’s office in Long Island City, NY, with the possibility of hybrid work.

Program Description

This position will be within the Health Department’s innovative Center for Population Health Data Science (CPHDS). CPHDS is working to strengthen citywide population health surveillance by better linking public health, healthcare, and social service data to fully characterize and improve the health of New Yorkers. Our vision is for these data to be accessible, timely, equitable, meaningfully usable, and protected – and being actively to protect and promote health and wellbeing of New Yorkers.

Job Description

As a QA Engineer, you will be responsible for testing and validating our data pipelines to ensure high-quality data is processed and delivered. You will work closely with Data Engineers, Data Analysts, and other stakeholders to verify the integrity, performance, and functionality of data processing systems from ingestion to transformation and storage.

This position will be based at the Health Department’s office in Long Island City, NY, with the possibility of hybrid work.

Duties

• Test Data Pipelines: Develop and execute comprehensive test plans to ensure the reliability and accuracy of data pipelines, including data extraction, transformation, and loading (ETL) processes.
• Test Services: Develop and execute comprehensive test plans to ensure the reliability and accuracy of services and service-oriented workflows.
• Automation Testing: Create and maintain automated tests for data pipelines and integrate them into CI/CD workflows to ensure data quality and pipeline stability.
• Data Validation: Validate the integrity, consistency, and accuracy of data processed through various pipelines by comparing raw data to processed data.
• Performance Testing: Monitor and test pipeline performance, identifying bottlenecks or inefficiencies and working with engineers to resolve them.
• Debug and Troubleshoot: Investigate and troubleshoot issues within data pipelines, working with cross-functional teams to resolve discrepancies or failures in the data flow.
• Test Documentation: Document test results, maintain test scripts, and provide detailed reports on issues found during testing.
• Collaboration: Work closely with Data Engineers to design and improve testing strategies, ensuring all data quality issues are addressed proactively.
• Continuous Improvement: Actively contribute to refining testing processes, methodologies, and automation practices to enhance the quality of the data pipelines.
• Regression Testing: Perform regression testing of data pipelines after code changes or new feature deployments to ensure the system remains stable.
  
  

Benefits

• Hybrid Work Schedule.
• Generous Paid Time Off and Holidays.
• An attractive and comprehensive benefits package including Medical, Dental and Vision.
• Flexible Spending Accounts and Commuter Benefits.
• Company Paid Life Insurance and Disability Coverage.
• 403 (b) + employer matching and discretionary company contributions.
• College Savings Plan.
• Ongoing training and continuous opportunities for professional growth and development.
  
  

Additional Desired Qualities

• Proven experience as a QA Engineer, Data Engineer, or related role focused on data pipeline testing.
• Solid understanding of data pipeline architecture, ETL processes, and data integration.
• Proficiency in testing frameworks and tools for data pipelines (e.g., Apache Airflow, dbt, Pytest).
• storage and processing systems (e.g., SQL, Hadoop, Spark, Snowflake).
• Experience with version control systems such as Git.
• Familiarity with CI/CD practices and tools (e.g., Jenkins, GitLab).
• Understanding of data warehousing concepts and cloud platforms (e.g., AWS, Azure, GCP).
• Excellent attention to detail and strong problem-solving skills.
• Strong communication skills with the ability to work in a collaborative team environment.
  
  

Additional Information

• This is a temporary grant-funded position ending in November 2027.
• This individual must reside in the tri-state area (NY, NJ, CT) by their confirmed start date.
• Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties.
• This individual will be expected to work non-business hours during emergencies.
  
  

At PHS, we place immense value on diversity within our teams, understanding that varied backgrounds and experiences significantly enhance our community and propel us toward our goals. If you find you don’t have experience in all the areas listed above, we still encourage you to apply and share your background and experiences in your application. We are eager to discover how your unique perspective can bring positive transformations to our team and help advance our mission of creating healthier, more equitable communities.

We look forward to learning more about you!

PHS is proud to be an equal opportunity employer and encourages applications from women, people of color, persons with disabilities, LGBTQIA+ individuals, and veterans.

Monday-Friday

35 Hours per week