Automation Test Lead - Data Migration

We've got an urgent requirement for an experienced Automation Tester (SDET) to join a data platform test team. The work is already in motion and needs additional delivery horsepower quickly and as such this is a great fit for someone who can drop into a fast-moving programme and start adding value straight away.

You'll be testing a modern Azure-based data platform, with a strong focus on ETL pipelines, data migration and warehouse quality. If you enjoy getting deep into data, building smart test automation, and helping teams ship with confidence, you'll feel right at home here.

The Role

This is a hands-on SDET role supporting data platform testing end-to-end. You'll work closely with data engineers, developers, analysts and other testers to build and run automated tests that prove data accuracy, integrity and performance across the platform.

Expect a mix of pipeline testing, migration validation and warehouse assurance, with plenty of scope to shape the approach rather than just follow a script. Key responsibilities include:

• Designing and building automated test frameworks for data pipelines and warehouse layers.
• Validating ETL processes end-to-end (extraction, transformation, loading), including orchestration logic, triggers and failure handling.
• Testing database migrations across heterogeneous systems, ensuring reconciliation, lineage and no data loss.
• Creating robust data validation checks using advanced SQL and Cosmos DB / DocumentDB queries.
• Supporting regression, smoke and sanity automation in CI/CD (Azure DevOps or similar).
• Working with delivery teams to define quality gates, acceptance criteria and test coverage.
• Producing clear test evidence and reporting on risks, defects and progress.
• Helping improve test strategy and ways of working across the platform

You'll be a seasoned Automation Tester / SDET who's comfortable in data-heavy environments and can challenge delivery teams in a constructive, credible way. You don't need to be a data engineer but you do need strong hands-on testing depth around ETL, migration and warehousing. Essential experience:

• Strong understanding of ETL testing and data pipeline validation.
• Proven experience with database migration testing (reconciliation, mapping, transformation rules, and integrity checks).
• Hands-on testing experience with Azure Data Factory (pipelines, triggers, data flows).
• Familiarity with Azure Synapse Analytics and data warehousing testing approaches.
• Advanced SQL skills for validation, optimisation and troubleshooting.
• Experience writing/validating Cosmos DB / DocumentDB queries.
• Confident communicator who can coordinate across teams and manage delivery timelines.
• Evidence of delivering similar case studies/projects using these technologies.

Ideal profile:

• Around 10 years' relevant experience in automation testing / SDET roles, ideally within data platforms.
• Comfortable working autonomously, spotting gaps and improving test approach as you go.