Data Engineer: Automate Data Flows & ETL (London, Hybrid)

Oliver James; City Of London; Hybrid; GBP 129,000 - 138,000; Full time

Job summary

Oliver James are seeking an experienced Data Engineer for a London Market Insurance transformation project. You will design and build scalable automated data solutions, owning end-to-end data processes across Consortium and Facility operations.

The role requires strong SQL Server and ETL expertise, plus experience automating manual business processes and collaborating with insurance stakeholders. This is a hybrid London role with a 12-month initial contract and a daily rate of £700-£750.

Qualifications

• Strong hands-on Data Engineering background.
• Excellent SQL / SQL Server / T-SQL skills.
• Previous Lloyd's / London Market insurance experience.
• Proven experience taking manual business/data processes and successfully automating them.
• Strong understanding of data flows and ETL.
• Experience with Consortium, Facility, bordereaux, Delegated Authority or Coverholder data would be highly desirable.
• Experience with Microsoft Fabric, Python and/or PowerShell would be beneficial.

Responsibilities

• Build and automate data processes across Consortium and Facility business.
• Automate bordereaux production, fee calculations and other insurance data processes.
• Work with data held within SQL Server.
• Understand existing business process flows and translate these into scalable technical solutions.
• Build appropriate controls and auditability into automated processes.
• Work closely with insurance and business stakeholders.
• Help create a best-in-class, scalable process as the business continues to grow.

Skills

SQL / SQL Server / T-SQL

Data Engineering

Python

PowerShell

ETL

Tools

Microsoft Fabric

Job description

Oliver James are seeking an experienced Data Engineer for a London Market Insurance transformation project. You will design and build scalable automated data solutions, owning end-to-end data processes across Consortium and Facility operations.

The role requires strong SQL Server and ETL expertise, plus experience automating manual business processes and collaborating with insurance stakeholders. This is a hybrid London role with a 12-month initial contract and a daily rate of £700-£750.