Quality Assurance Engineer

The Fund for Public Health in New York City (FPHNYC) is a 501(c)3 non-profit organization that is dedicated to the advancement of the health and well-being of all New Yorkers. To this end, in partnership with the New York City Department of Health and Mental Hygiene (DOHMH), FPHNYC incubates innovative public health initiatives implemented by DOHMH to advance community health throughout the city. It facilitates partnerships, often new and unconventional, between government and the private sector to develop, test, and launch new initiatives. These collaborations speed the execution of demonstration projects, effect expansion of successful pilot programs, and support rapid implementation to meet the public health needs of individuals, families, and communities across New York City.

Program Overview

Established in 1805, the New York City Department of Health and Mental Hygiene (the NYC Health Department) is the oldest and largest health department in the country. Our mission is to protect and improve the health of all New Yorkers, in service of a vision of a city in which all New Yorkers can realize their full health potential, regardless of who they are, how old they are, where they are from, or where they live. As a world-renowned public health agency with a history of building transformative public health programming and infrastructure, innovating in science and scholarship to advance public health knowledge, and responding to urgent public health crises — from New York City’s yellow fever outbreak in 1822, to the COVID-19 pandemic — we are a hub for public health innovation, expertise, and programs, and services. We serve as the population health strategist, and policy, and planning authority for the City of New York, while also having a vast impact on national and international public policy, including 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 racial and social justice work, among others.

Position Overview

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.

As a Quality Assurance 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 wo

Responsibilities

• 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.
  
  

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent experience).
• At least 3 years of experience that is highly relevant to responsibilities above.
• 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.
  
  

The ideal candidate for this position must be a proactive and self-motivated individual who is comfortable with multitasking. They can work in teams and in a highly dynamic environment with multiple stakeholders and timelines. This individual may need to work non-business hours in the event of a health emergency.

Salary And Benefits

• The salary range for this position is $105,000-$115,000
• Professional Development: Opportunity to gain experience in non-profit financial operations, compliance, and contract management
• Generous Paid Time Off (PTO) policy
• Medical, dental, and life insurance with low or no employee contribution
• A retirement savings plan with generous employer contribution
• Flexible spending medical and commuter benefits plan
• Meaningful work at an organization striving to advance health equity and social justice
  
  

WORK SCHEDULE

9:00 am – 5:00 pm

Monday to Friday

Hybrid

LOCATION

42-09 28th St, Queens, NY 11101

RESIDENCY REQUIREMENT

You must live in New York City Tri-state area (NY, NJ, CT) in order to be considered for a position at FPHNYC.

TO APPLY

To apply, upload Resume, including how your experience relates to this position. Applicants who best match the position needs will be contacted.

The Fund for Public Health in New York City is an Equal Opportunity Employer and encourages a diverse pool of candidates to apply.

Apply Now