ETL Tester Lead

Stott and May; London; Hybrid; GBP 100,000 - 125,000; Full time

Job summary

A data testing consultancy in London is seeking an experienced ETL Tester Lead to oversee testing activities in data, ETL, and visualization projects. The candidate will ensure high-quality delivery through test design and execution. Key qualifications include expertise in ETL testing, strong SQL skills, and experience with Azure services. This role involves collaborating with cross-functional teams in a fast-paced environment.

Qualifications

• Proven expertise in ETL and data warehouse testing.
• Strong proficiency in SQL scripting.
• Hands-on experience with structured and unstructured data testing.
• Good understanding of Azure data services.
• Knowledge of data testing concepts and best practices.
• Hands-on experience with Python/PySpark scripting.
• Exposure to data testing automation is advantageous.
• Experience in the insurance domain is preferred.

Responsibilities

• Develop and execute test plans and test cases for ETL projects.
• Publish test results, track defects, and ensure timely resolution.
• Liaise with Test Leads, Analysts, Designers, and Developers.
• Deliver testing artefacts in line with QA processes.
• Drive end-to-end execution of testing activities.
• Contribute to quality assurance processes.

Skills

ETL and data warehouse testing

SQL scripting

Structured and unstructured data testing

Azure data services

Python/PySpark scripting

Communication skills

Agile development

Job description

Job Title: ETL Tester Lead
Location: London (on-site/hybrid)
Contract Duration: Until 31st December 2025
Day Rate: £579.70 (Inside IR35)
Start Date: ASAP

Role Overview

We are seeking an experienced ETL Tester Lead to take ownership of testing activities across data, ETL, and visualisation projects within a fast-paced environment. The successful candidate will play a key role in ensuring high-quality delivery through the design, execution, and automation of robust testing processes.

Key Responsibilities

• Develop and execute comprehensive test plans and test cases for Manual, ETL, and visualisation projects.

• Publish test results, track defects, and ensure timely resolution.

• Liaise effectively with Test Leads, Business Analysts, Designers, and Developers to identify issues and mitigate risks.

• Deliver testing artefacts in line with established QA processes.

• Drive end-to-end execution of testing activities, including test automation.

• Contribute to quality assurance processes across planning, execution, defect reporting, and problem resolution.

Skills & Experience Required

• Proven expertise in ETL and data warehouse testing, including ETL/ELT processes.

• Strong proficiency in SQL scripting, including writing and executing complex queries.

• Hands-on experience with structured and unstructured data testing.

• Good understanding of Azure data services, including Data Factory, Databricks, Synapse (Azure SQL DW), Cosmos DB, and Azure Data Lake.

• Knowledge of data testing concepts and best practices within data warehouse environments.

• Hands-on experience with Python/PySpark scripting for test development.

• Exposure to data testing automation is highly advantageous.

• Experience in the insurance domain is preferred.

• Excellent communication skills, both written and verbal.

• Previous experience in an Agile development environment.