Job Description
We are seeking a Data Quality Analyst to join our Insurance business unit in London. In this role, you will be responsible for ensuring the accuracy, consistency, and reliability of data across our platforms. You will design and execute test plans for ETL processes, validate data transformations using SQL, and perform reconciliation across source systems, data warehouses, and data lakes. Working closely with data engineering and BI teams, you will play a key role in identifying issues, improving data pipelines, and driving high-quality data delivery.
This is an excellent opportunity for a detail-oriented professional with strong SQL and ETL testing experience to contribute to client’s mission of leveraging data and AI to transform businesses. The role offers exposure to modern data platforms, QA frameworks, and cloud technologies, alongside the opportunity to develop your skills in a global, collaborative, and innovative environment.
As part of your duties, you will be responsible for :
- Understand business requirements and data flows to create comprehensive test plans and test cases for ETL jobs.
- Perform data validation and reconciliation between source systems, staging, and target data stores (DWH, data lakes, etc.).
- Develop and execute automated and manual tests to ensure data accuracy and quality.
- Work with SQL queries to validate data transformations and detect anomalies.
- Identify, document, and track defects and inconsistencies in data processing.
- Collaborate with data engineering and BI teams to improve ETL processes and data pipelines.
- Maintain QA documentation and contribute to continuous process improvements.
Requirements
Qualifications and experience we consider to be essential for the role :
Strong SQL skills – ability to write complex queries for data validation and transformation testing.Hands-on experience in ETL testing – validating data pipelines, transformations, and data loads.Knowledge of data warehousing concepts – dimensions, facts, slowly changing dimensions (SCD), etc.Experience in test case design, execution, and defect tracking.Experience with QA tools like JIRA, TestRail, or equivalent.Ability to work independently and collaboratively in an Agile / Scrum environment.Skills and Personal attributes we would like to have :
Experience with ETL tools like Informatica, Talend, DataStage, or AWS / GCP native ETL services (e.g., Dataflow, Glue).Knowledge of automation frameworks using Python / Selenium / pytest or similar tools for data testing.Familiarity with cloud data platforms – Snowflake, BigQuery, Redshift, etc.Basic understanding of CI / CD pipelines and QA integration.Exposure to data quality tools such as Great Expectations, Deequ, or DQ frameworks.Understanding of reporting / BI tools such as Power BI, Tableau, or LookerBachelor’s or Master’s degree in Computer Science, Information Technology, or related field.