> Markdown version of [/jobs/ext/2305308-data-engineer-london-market](https://www.wearedevelopers.com/jobs/ext/2305308-data-engineer-london-market). 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).

---

# Data Engineer (London Market)

- **Company:** Aviva plc
- **Location:** London, UK
- **Contract:** Temporary contract
- **Skills:** Application Programming Interfaces (APIs), Airflow, Business Analytics Applications, Microsoft Azure, Big Data, Encodings, Continuous Integration, Extract Transform Load (ETL), Data Transformation, Data Warehousing, DevOps, Dimensional Modeling, JSON, Python (Programming Language), Performance Tuning, Power BI, SQL Databases, SQL Server Integration Services, Azure Data Factory, Data Lakes, Pyspark, Kubernetes, Data Lineage, Star Schema, Data Management, Restful APIs, Data Pipelines, Databricks
- **Published:** August 30, 2026
- **Apply:** https://www.collegerecruiter.com/job/2815461708-data-engineer-london-market

## About the Role

* Data warehouse design, dimensional modelling, and star schema expertise.
 * Experience with ETL/ELT tools (SSIS, ADF, Databricks).
 * Knowledge of Azure cloud data stack (SQL Pool, Synapse, Data Lake, ADF).
 * Familiarity with APIs, REST, JSON, and flat-file ingestion.
 * Performance tuning and optimisation for large-scale data warehouses., * Excellent communication with technical and non-technical stakeholders.
 * Strong problem-solving mindset with attention to detail.
 * Experience working in Agile / Scrum environments.
 * Previous experience with London Market insurers, MGAs, Lloyd's syndicates, or brokers.
 * Data warehouse dimensional modelling and ETL/ELT development.
 * Data Quality Assessment and embedding automated checks with lineage and reconciliation.
 * Python or PySpark for data transformation.
 * Exposure to BI Tools (Power BI).
 * Experience with CI/CD, DevOps, and automated data pipelines.
 * Master data management experience and orchestration frameworks (Airflow/ADF).

## Description

* Design, build, and optimise SQL-based data warehouse solutions supporting underwriting, claims, actuarial, exposure management, and regulatory reporting.
 * Develop robust ETL/ELT pipelines using tools such as SSIS, Azure Data Factory (ADF), and Databricks.
 * Implement dimensional modelling (Kimball / star schema) for analytical workloads.
 * Integrate data from internal and external London Market sources including Lloyd's, DXC, TPAs, and brokers.
 * Build automated data quality checks, lineage tracking, and controlled data releases.
 * Collaborate with Product Owners, Underwriters, Actuaries, BI teams, and IT to translate business requirements into technical specifications.
 * Support migration of legacy SQL systems into Azure cloud environments, enabling self-service analytics for Power BI and actuarial platforms.


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform)
- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment)
- [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment)

## 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)
- [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [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)
- [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers)