Data Engineer

Oliver James Group; Greater London; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

Oliver James Group is recruiting a Data Engineer for a London-based hybrid role on a 12-month contract. You will own the design and build of scalable automated data solutions across Consortium and Facility operations, automat­ing bordereaux production and data processes, with data hosted in SQL Server.

The ideal candidate has strong data engineering experience, hands-on ETL skills, and familiarity with Lloyd's/London Market insurance.

Qualifications

• Strong hands-on data engineering background.
• Experience in Lloyd's / London Market insurance.
• Proven track record automating manual data processes.
• Solid understanding of data flows and ETL.
• Exposure to Consortium/Facility/bordereaux/Delegated Authority data is a plus.
• Experience with Python and/or PowerShell is beneficial.

Responsibilities

• Build and automate data processes across Consortium and Facility operations.
• Automate bordereaux production, fee calculations, and other insurance data workstreams.
• Work with data stored in SQL Server and ensure data quality.
• Translate existing business processes into scalable technical solutions.
• Implement controls and auditability in automated workflows.
• Collaborate with insurance and business stakeholders to scale processes as the business grows.

Skills

Data engineering

Lloyd's insurance experience

ETL

Data workflows

Python

PowerShell

Tools

Microsoft Fabric

SQL Server

Job description

Data Engineer | London Market Insurance | Outside IR35

Contract: 12 months initially

Location: London - hybrid, approximately 3 days per week onsite

Oliver James is working with a leading London Market insurer looking for an experienced Data Engineer to join a high-profile transformation project.

The business is experiencing significant growth across its Consortium and Facility operations and is looking to automate a number of currently manual data and back-office processes. The successful contractor will have significant ownership over designing and building scalable automated solutions.

The role will involve:

• Building and automating data processes across Consortium and Facility business
• Automating bordereaux production, fee calculations and other insurance data processes
• Working with data held within SQL Server
• Understanding existing business process flows and translating these into scalable technical solutions
• Building appropriate controls and auditability into automated processes
• Working closely with insurance and business stakeholders
• Helping create a best-in-class, scalable process as the business continues to grow

Key experience:

• Strong hands-on Data Engineering background
• 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

This isn't a role where the technical solution has already been completely prescribed. The successful Data Engineer will have considerable flexibility around how the solution is built, so it's particularly suited to someone who enjoys taking ownership of a problem and delivering the right technical solution.