Data Engineering Consultant – Consortium, Facility

G MASS Consulting

. Design and deliver an automated, scalable process for producing bordereaux and data feeds to follow markets, with controls built in from the outset .

Posted 11/11/2026contractLondon • United KingdomMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing automated processes for data management and reporting, with a strong focus on Transact SQL, Power BI, and cloud data platforms. Capable of collaborating with cross-functional teams to resolve data issues and enhance operational efficiency in the Lloyd’s insurance market.

Highest-signal resume keywords

Transact SQLMicrosoft SQL ServerETL ToolsPower BI ReportingAzure

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Database DesignAutomated Data PipelinesPowerShell ScriptingFee CalculationProfit Commission Calculation

Soft Skills

Analytical AbilityAttention to DetailStructured Problem SolvingStakeholder Engagement

Tools & Technologies

Power BIAzureMicrosoft Fabric

Industry Keywords

Lloyd’s Insurance MarketDelegated AuthorityBordereauxFee ProcessesCommission Processes

Tech Stack

Tools & technologies

AzureCloudETLMS SQL ServerSQL

About the role

Key responsibilities & impact

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

What you’ll need

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

Comp & perks

Initial 12 month contract