Data QA Engineer: End-to-End Data Quality & Validation

Sagacity; England; On-site; GBP 42,000 - 62,000; Full time

Job summary

Sagacity is seeking a data QA specialist who sits between data analysis and quality assurance to test pipelines, data warehouses and lakehouse platforms that drive marketing, billing, credit and debt outcomes for clients across financial services, retail, energy, telecoms and non-profit sectors.

You will work with Data Engineers, UAT teams and client stakeholders to turn data mappings into test cases, reconcile data from source to target, investigate anomalies and clearly explain findings to

Qualifications

• Strong SQL skills including joins, CTEs, aggregations and windows for data profiling and reconciliation.
• Experience testing ETL/ELT processes and data warehouse or lakehouse environments.
• Solid grasp of testing data quality: completeness, accuracy, duplicates, schema and transformation logic.
• Experience with source-to-target reconciliation and writing test cases from mappings or specs.
• Analytical mindset with ability to identify when data doesn’t look right and reason about why.
• Basics of Git and version control for collaboration.

Responsibilities

• Write and run SQL to check, profile and reconcile data across source systems, staging, warehouse and lakehouse layers.
• Test ETL/ELT pipelines end to end, validating transformation logic and data flow across bronze-silver-gold layers.
• Carry out data quality checks covering completeness, accuracy, duplicates, schema and volumes.
• Perform source-to-target reconciliation and migration parity checks, proving counts and key-level data match specifications.
• Write, run and maintain test plans and test cases from mappings, specs and acceptance criteria.

Skills

Strong SQL

Data pipeline testing

Data quality

Reconciliation and test design

Analytical eye

Engineering basics

Tools

Databricks

dbt tests

Great Expectations

Soda

Job description

Sagacity is seeking a data QA specialist who sits between data analysis and quality assurance to test pipelines, data warehouses and lakehouse platforms that drive marketing, billing, credit and debt outcomes for clients across financial services, retail, energy, telecoms and non-profit sectors.

You will work with Data Engineers, UAT teams and client stakeholders to turn data mappings into test cases, reconcile data from source to target, investigate anomalies and clearly explain findings to