Data Engineering Consultant - Consortium & Facility

ace are working with a well established Lloyd’s market insurer to appoint a Data Engineering Consultant to join their Data Management function, reporting into the Head of Data Management.

This role will lead the move from manual to automated processing across the firm’s Consortium and Facility business. The successful candidate will design and build a scalable data capability that delivers bordereaux and supporting data feeds to follow markets, while automating the calculation of fees and profit commissions, including Consortia fees and Coverholder commissions. It is a hands on technical position with real ownership, suited to someone who combines strong SQL and automation skills with an understanding of how delegated business works in the London Market.

Responsibilities

• Design and deliver an automated, scalable process for producing bordereaux and data feeds to follow markets, with controls built in from the outset
• Redevelop the current fee calculation process so additional follow markets can be onboarded efficiently
• Automate the collection and processing of Consortia fees and Coverholder commissions
• Calculate fees and profit commissions accurately across Consortium and Facility arrangements
• Produce clear documentation and auditable controls covering all automated processes
• Maintain and develop Power BI reporting for internal stakeholders
• Work closely with underwriting, finance and operations colleagues to understand requirements and resolve data issues

Requirements

• Excellent Transact SQL, with strong experience across Microsoft SQL Server and database design
• Hands on experience with ETL tools and building automated data pipelines
• Exposure to cloud data platforms, ideally Azure and Microsoft Fabric
• Experience maintaining and developing Power BI reports
• PowerShell scripting for task automation
• Working knowledge of the Lloyd’s insurance market, ideally including delegated authority, bordereaux or fee and commission processes
• Strong analytical ability, attention to detail and a structured approach to planning and problem solving
• Confident engaging with stakeholders across technical and business teams

Benefits

Initial 12 month contract