Data QA Engineer

Location:

UKRole Type:
Permanent - Full Time

Job Location:

Hybrid Working - minimum of 2 days a week in our London office

Sagacity are the data intelligencepeople. Our proposition isbusinesses increase customer engagement and make moreinto the data businesses already have, and combine it with our data,insight, and action. Think of us asdata co-pilots for sales, marketing,ops, billing, credit and debt - clientstypically see 5x returns within thefirst few months.

Founded in 2005, we are acustomer-centric business witha World Class +95 Net Promoter Score. We believe data should beat the heart of every company and while we are sector agnostic,primarily our clients are in thetelecoms & media, water, andnot for profit sectors.

We are a purpose led company and we believe that purposecomes before profit. We workas one team both with clients and internally, and are trusted todeliver quality in our standard sand in achieving successful client outcomes. We are open, honestand communicate in a jargonfree, collaborative way, with all ourteams being agile and curious, and continuously learning to achieve our purpose. We believe that ifwe achieve our purpose theneverything else will follow.

Clever with data... combining data,insight, and action to drive value

• Write and run SQL to check, profile and reconcile data across source systems, staging, data warehouse and lakehouse layers
• Test ETL/ELT pipelines end to end, validating transformation logic, business rules and how data flows through each layer (bronze → silver → gold)
• Carry out data quality checks covering completeness, accuracy,duplicates, schema, referential integrity and row volumes
• Perform source-to-target reconciliation and migration parity checks, proving counts, totals and key-level data match the specification
• Write, run and maintain test plans and test cases from data mappings, specifcations and acceptance criteria using Sagacity SPHERE’s YAMLdriven test framework, keeping coverage current as new data sources are onboarded
• Investigate failures and anomalies, distinguish pipeline bugs from source data issues, and log clear, evidenced defects developers can act
• Work directly with clients and UAT teams: explain our testing approach and results, manage expectations on scope, risk and timelines, andbuild trusted relationships
• Collaborate with Data Engineers to agree expected behaviour, review data contracts, and validate fixes before they reach UAT or production
• Manage QA work items in Click Up, and raise well-specifiedimprovements to SPHERE and our wider QA tooling
• Use AI-assisted tools to speed up test authoring, investigation and documentation, always checking the output against the data

• Client data is reconciled and validated end to end before delivery, with no material data quality issues reaching UAT or production
• Numbers that don’t look right are spotted early, investigated thoroughly and explained clearly
• Developers can reproduce and fix defects from your evidence without back-and-forth
• Clients trust our QA and feel well-informed about what has been tested and why, without needing to ask twice
• Test coverage grows with each delivery increment rather than lagging behind
• Our QA tooling and processes improve because gaps are named and fixed, not just worked around

You will ensure the data we deliver to our clients is right. Sitting between data analysis and quality assurance, you will test the pipelines, data warehouses and lakehouse platforms that drive marketing, billing, credit and debt outcomes for clients across financial services, retail, energy, telecoms & media, water, and the not-for-profit sector.

Working closely with our Data Engineers, Platform Engineer, UAT teams and…