> Markdown version of [/jobs/ext/80855-senior-data-tester](https://www.wearedevelopers.com/jobs/ext/80855-senior-data-tester). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Data Tester

- **Company:** Dhetech Ltd
- **Location:** London, UK
- **Experience:** Expert
- **Salary:** £110,500.0 - £123,500.0
- **Contract:** Permanent contract
- **Skills:** Automation of Tests, Microsoft Azure, Code Coverage, Extract Transform Load (ETL), Data Warehousing, Apache Hive, JSON, Python (Programming Language), Operational Data Store, Windows PowerShell, Cloud Services, SQL Databases, Data Streaming, Transact-SQL, Parquet, Data Processing, Scripting, Azure Data Factory, Data Lakes, Pyspark, Databricks
- **Published:** May 15, 2026
- **Apply:** https://uk.indeed.com/viewjob?jk=24b7004fee852cce

## About the Role

Do you have experience in SQL?, We are seeking a Senior, experienced Data Tester with 10+ years of experience, to lead and execute data quality and reconciliation testing across Lloyd's of London insurance data flows. The role combines strong manual testing and analytical investigation with semi-automated validation using Azure, Databricks, PySpark, Spark SQL, and scripting. You will validate financial and operational data across ingestion, transformation, and reporting layers, ensuring accuracy of premium, claims, settlements, bordereaux, ledgers, and reconciliation outputs.

## Description

My client is an International Insurer who require an Insurance specific Data Tester, with Strong LLoyd's of London experience OR Strong Insurance Background; Strong Data reconciliation, data warehousing Testing background and Azure Data Bricks, Spark SQL. pySpark., * Own end-to-end data testing for financial reconciliation pipelines across Lloyd's insurance datasets (premium/claims/ledger movements).

 * Perform manual and exploratory data testing: deep dive investigations, anomaly detection, root cause analysis and triage.
 * Design and execute reconciliation test strategies (control totals, balancing checks, completeness, accuracy, timeliness, and lineage).
 * Validate ETL/ELT transformations in Databricks using PySpark + Spark SQL; verify joins, aggregations, currency conversions, and business rules.
 * Build and maintain semi-automated test assets: reusable SQL/PySpark validation scripts, data comparison utilities, parameterized checks, and regression packs.
 * Ensure test coverage for edge cases: late arriving data, duplicates, reversals, adjustments, cancellations, and back-dated movements.
 * Hands-on Databricks and Azure ecosystem experience; proficiency in PySpark and Spark SQL for validation.
 * Experience with Azure data services and cloud data platforms (eg, ADLS, Azure Data Factory, Synapse/Databricks patterns).

Lloyd's Insurance Domain Knowledge Mandatory

 * Familiarity with Lloyd's market constructs and insurance data concepts such as syndicates, brokers, coverholders, bordereaux, and premium/claims lifecycle.
 * Exposure to currency handling, multi-ledger scenarios, settlement cycles, and financial movement types (paid, outstanding, incurred, reserves).
 * Understanding of policy/claim identifiers, endorsements, adjustments, and how they affect reconciliation.

Tools & Technologies

 * Azure (ADLS, ADF, Azure DevOps desirable), Databricks, PySpark, Spark SQL, Python, SQL (T-SQL/ANSI), Scripting (Shell/PowerShell desirable)
 * Data formats: Parquet/Delta, CSV, JSON; exposure to Delta Lake concepts beneficial

Pay: £425.00-£475.00 per day


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers)
- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [SMART Test Automation - the experience of legacy transformation](https://www.wearedevelopers.com/videos/100215-smart-test-automation-the-experience-of-legacy-transformation)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)
- [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023)
- [Fullstack Developer Salary UK](https://www.wearedevelopers.com/magazine/251-fullstack-developer-salary-uk)