Data Validation Engineer

"Description: QA/Data Validation Engineer

Owns testing and validation for a multi-stage data-processing pipeline, ensuring transformed and consolidated outputs are accurate, complete, and production-ready.

What you'll do:

Write and execute unit tests for individual data-transformation and consolidation components

Perform reconciliation testing validating processed/aggregated outputs against source-system totals using row counts, checksums, business-rule assertions, and etc.

Build and maintain automated test suites integrated into the CI/CD pipeline

Design test cases covering edge conditions: nulls, duplicate keys, malformed records, and schema drift

Support production hardening by triaging defects, isolating root cause, and verifying fixes

Maintain test documentation and traceability from requirements to test coverage

Mandatory Skills: Strong SQL — complex joins, aggregations, and set comparisons for data-validation and reconciliation logic

Experience testing ETL/ELT pipelines and cloud data warehouses (e.g., Snowflake)

Test automation experience — building repeatable, CI-integrated test suites (e.g., pytest, dbt tests)

Experience with defect-tracking and test-management tools (e.g., Jira, TestRail)

Solid understanding of data-quality dimensions: completeness, accuracy, consistency, timeliness