QA Engineer 2 - DPP

Numerator; Indiana; On-site; USD 70,000 - 110,000; Full time

Job summary

Numerator is seeking a QA Engineer to ensure quality, reliability, and integrity of the DPP deliverables across data ingestion, transformation, APIs, and downstream reporting. You will review requirements, design test scenarios, and execute manual and automated tests to validate end-to-end data flows and business rules.

In collaboration with Product, Engineering, and Data teams, you will manage defects, support release readiness, and drive continuous improvements in QA tooling and processes to

Qualifications

• Experience in QA for data-driven platforms with ETL, APIs, and reporting.
• Strong SQL for data validation and root-cause analysis.
• Excellent communication and collaboration across Product, Engineering, and Data teams.

Responsibilities

• Review requirements and acceptance criteria to design test scenarios and test cases.
• Execute manual and automated tests across the DPP platform.
• Record defects with reproduction steps and impact for triage and resolution.
• Validate end-to-end data flows and business rules.
• Maintain regression test coverage and support release readiness.
• Support root-cause analysis and fix validation with Engineering and Data teams.
• Contribute to knowledge sharing and QA process improvements.

Skills

QA & Testing

Data Validation

API Testing

Analytical Thinking

Tools

Azure DevOps

SQL

Postman

Swagger/OpenAPI

Databricks

Azure Data Factory

Python

Java

Job description

QA Engineer – DPP

We are looking for a QA Engineer to support the quality, reliability, and integrity of DPP deliverables across data ingestion, transformation, APIs, and downstream reporting. The successful candidate will review requirements and acceptance criteria, design and execute manual and automated tests, validate end-to-end data flows and business rules, and work closely with Product, Engineering, and Data teams to identify defects early, reduce delivery risk, and support high-quality releases.

Key Responsibilities

Test Planning & Design

Review requirements, acceptance criteria, and supporting documentation to create clear, traceable test scenarios and test cases for each User Story.

Review test coverage with relevant stakeholders and maintain the regression suite to ensure ongoing support for business-critical DPP functionality.

Test Execution & Defect Management

Execute manual and automated tests to validate new features, regression scenarios, and data transformations across the DPP platform.

Record defects and data issues with clear reproduction steps, supporting evidence, and impact assessment to enable efficient triage and resolution.

Work closely with Engineering and Data teams to support root-cause analysis, validate fixes, and confirm production readiness.

Validation & Closure

Retest resolved defects and confirm that acceptance criteria, business rules, and quality expectations have been met before closure.

Maintain accurate defect reporting, status tracking, and quality documentation to support transparent delivery decisions.

Data Integrity & ETL Validation

Validate the accuracy, completeness, and consistency of extracted, transformed, and loaded data across the DPP platform.

Confirm that processed data aligns with business rules, acceptance criteria, and reporting expectations.

Continuous Improvement

Identify opportunities to improve QA processes, tooling, and automation to increase efficiency and test effectiveness.

Contribute to knowledge sharing and continuous learning within the wider QA and delivery teams.

Technical Skills & Tools

Mandatory Tools

Azure DevOps (Test Management & Release Support): Plan and execute DPP test cycles, manage test evidence and defects, support release readiness, and contribute to quality sign-off across delivery pipelines.

Azure DevOps (Defect Tracking & Traceability): Log, triage, and track defects and data issues, maintain traceability to User Stories, data changes, and releases, and work with Engineering and Data teams on root-cause analysis and fix validation.

SQL (Data Validation): Write and execute queries to validate data transformations, reconciliations, referential integrity, and data quality rules across staging and curated layers.

Postman & Swagger (API Testing): Validate API contracts, schemas, authentication and authorization, error handling, and payload accuracy using Swagger/OpenAPI specifications; create and maintain collections for smoke and regression testing.

Databricks & Azure Data Factory: Support validation of transformation logic, pipeline outcomes, and orchestration processes. Databricks is the primary platform used in DPP, while Azure Data Factory knowledge remains valuable as an additional skill aligned to broader ETL requirements.

Programming & Frameworks

Python or Java: Experience using one or both languages for test automation, API checks, and data validation scripting.

PyTest / Robot Framework / Contract Testing / Automated Data Checks: Familiarity with test frameworks and data-quality tooling to support DPP regression coverage and ongoing monitoring.

KPIs & Success Metrics

• Test Execution Delivery: Complete planned DPP test execution within agreed sprint timelines, with clear evidence and status visibility.
• Defect Detection Rate: Identify and log at least 90% of critical defects (data quality issues, pipeline failures, and API contract breaks) before release.
• Defect Turnaround Time: All defects are triaged, prioritized, and assigned within 24 hours of discovery.
• Coverage & Traceability: Maintain end-to-end coverage of User Stories, acceptance criteria, core business rules, and key data scenarios, with clear traceability across testing and release activity.
• Data Quality & Integrity: Ensure validated datasets meet transformation rules, reconciliation checks, and agreed quality tolerances for the DPP platform.
• Status Reporting: Provide weekly QA status updates covering test progress, defect trends, data quality outcomes, pipeline/API risks, and release readiness.
• Continuous Improvement: Propose at least one process or tooling improvement per quarter (e.g., automation, data-quality checks, or pipeline monitoring) to strengthen DPP quality.

Candidate Profile

• Proven experience in QA or software testing within data-driven platforms, ideally involving ETL processes, APIs, and reporting or analytics solutions.
• Strong analytical thinking and problem-solving skills, with the ability to investigate issues across data, APIs, and application behavior.
• Strong SQL knowledge is essential, including the ability to write and execute queries for data validation, reconciliation, and root-cause analysis.
• Excellent communication and collaboration skills, with the confidence to work effectively across Product, Engineering, and Data teams.
• High attention to detail and a strong commitment to delivering reliable, high-quality outcomes.

Nice-to-have Skills

• Experience testing modern data platforms, data pipelines, or cloud-based analytics solutions.
• Exposure to automation frameworks, CI/CD pipelines, or quality gates within engineering workflows.
• Understanding of API standards, data contracts, and integration testing practices.
• Experience working in Agile delivery environments with cross-functional product and engineering teams.