QA Data Test Engineer
Manchester (Hybrid – Travel as required)
6 Month Initial Contract
£350 per day (Outside IR35)
The Opportunity
We're supporting a major data modernisation programme for a well-known international retail organisation that is transforming its global data platform.
As part of a large-scale migration from legacy SQL Server data warehouses to a modern Snowflake and dbt ecosystem, we're looking for an experienced QA Data Test Engineer to take ownership of data quality, reconciliation and automated testing across the platform.
This is a hands-on role for someone who understands that testing data platforms goes far beyond traditional application testing. You'll be responsible for ensuring the accuracy, integrity and reliability of critical business data used across Finance, Operations, HR and Commercial functions.
Key Responsibilities
- Design and execute the test strategy for a modern cloud-based data platform.
- Build and maintain automated data quality, regression and reconciliation test suites.
- Validate data migrations from legacy SQL Server environments into Snowflake.
- Develop row-level, column-level and aggregate-level reconciliation checks.
- Create and maintain dbt tests across staging, transformation and reporting layers.
- Integrate testing into CI/CD pipelines to ensure quality gates are enforced.
- Investigate data quality issues and support root cause analysis.
- Work closely with Data Engineers, Business Analysts and Product Owners to define acceptance criteria and test coverage.
- Support UAT activities and production releases.
- Champion best practice around automated testing and data quality.
Required Experience
- Proven experience as a QA Engineer, Test Engineer or Data Quality Engineer within modern data environments.
- Strong SQL skills with the ability to write complex validation and reconciliation queries.
- Experience testing data warehouses, ETL/ELT pipelines and analytical platforms.
- Hands-on experience with Snowflake, Azure, Databricks or similar cloud data platforms.
- Experience with dbt testing frameworks.
- Knowledge of automated testing approaches including Great Expectations, Soda, dbt tests or custom frameworks.
- Experience integrating testing into Azure DevOps, GitHub Actions or similar CI/CD pipelines.
- Strong understanding of data lineage, data quality and data governance principles.
- Experience working within Agile delivery environments.
Desirable Experience
- Data migration or platform modernisation programmes.
- Legacy SQL Server to Snowflake migrations.
- Python for test automation.
- Power BI testing and semantic model validation.
- Experience within Retail, Hospitality or Consumer-facing organisations.
Technology Environment
- Snowflake
- dbt
- Fivetran
- SQL Server
- Azure
- Azure DevOps / GitHub Actions
- Power BI
- Python
What's in it for You?
- High-profile enterprise data transformation programme.
- Modern cloud data stack.
- Opportunity to influence testing strategy and quality standards.
- Long-term contract opportunity with strong extension potential.
- Collaborative and highly skilled data engineering environment.