About the Position
This is a data focused quality engineering role rather than an application testing role. You will build automated validation for data pipelines and data products, own reconciliation testing between legacy and target systems, and put quality gates into the delivery pipeline so that a failure blocks a release rather than producing a report that nobody reads.
About the Project
The project migrates data and reporting from a legacy estate onto a modern platform built on Databricks and Microsoft Fabric. Quality engineering is central to the project. The business needs confidence that migrated data reconciles with the source, that pipelines behave as specified, and that reports produce consistent results.
Responsibilities
- Design and implement data testing and quality assurance frameworks.
- Build automated validation for data pipelines and data products.
- Own source to target reconciliation between legacy systems and the new platform.
- Build repeatable regression packs that run unattended.
- Write unit tests that execute automatically within CI/CD, with quality gates that can block a release.
- Detect and handle schema drift and unexpected structural changes.
- Validate reports, dashboards, and semantic models, including measure definitions, filter behaviour, and totals.
- Apply AI assisted techniques to test generation and coverage analysis, with human review.
Requirements
- 5+ years of experience in quality engineering, with meaningful recent experience testing data or ETL processes rather than applications.
- Strong Python and SQL skills, used for building test automation rather than only running it.
- Experience with pipeline validation, including row counts, control totals, referential integrity, and business rule assertions.
- Experience with source to target reconciliation using defined tolerances.
- Experience with test automation within CI/CD, including gates that block a release.
- Experience with Azure DevOps.
- Experience with SQL Server.
- English proficiency at a level suitable for direct client conversations.
Nice to Have
- Experience with Azure Databricks or Microsoft Fabric.
- Experience with data quality frameworks, including Great Expectations, dbt tests, Databricks Expectations, DLT quality rules, Soda, or Deequ.
- Experience designing a test framework from scratch rather than extending an existing one.
- Experience testing semantic models and BI layers.
- Experience working in a regulated financial services environment.
- Experience with application test automation alongside data testing, including Selenium, C#, SpecFlow, or Playwright.
Technologies
Python, SQL Server, Azure Databricks, Microsoft Fabric, Azure DevOps, dbt tests, Power BI