G MASS

Data Engineering Consultant - Consortium & Facility

Data EngineeringPosted on Nov 10

Full-timeLondon, UKNo salary listedHybrid

About the Job

Requirements

Excellent Transact-SQL (T-SQL) skills.
Strong knowledge of Microsoft SQL Server database systems and extract, transform, and load (ETL) tooling, including SQL Server Integration Services (SSIS).
Hands-on experience with Azure cloud data solutions, ideally Microsoft Fabric and OneLake.
Python experience for data engineering, including data flows and notebooks within Fabric.
Power BI experience, including building and maintaining semantic models and online reports.
PowerShell experience for task automation and scheduling.
A track record of designing and building end-to-end data solutions, from architecture through delivery.
Experience embedding auditable controls and reconciliations into automated processes.

Responsibilities

Architect and build the end-to-end solution, taking ownership from design through delivery as a hands-on engineer.
Extract data from on-premises SQL Server databases and data warehouses and land it in Microsoft Fabric (Azure, OneLake).
Develop data pipelines and transformation logic using T-SQL and Python within Fabric.
Design and maintain the mapping tables and reference data required for calculations.
Enhance and automate the existing fee calculation process so additional follow markets can be added efficiently.
Enhance and automate the collection and processing of consortia fees and coverholder commissions.
Build accurate, repeatable profit commission calculations.
Build an efficient and scalable capability to provide data and bordereaux to follow markets, with controls embedded throughout.
Develop a semantic layer over the data to support Power BI reporting and data exports.
Create dashboards and outputs that feed Finance and Operations.
Design and implement auditable controls around all automated processes, providing clear visibility of what each process is doing.
Produce clear technical and process documentation to support audit, ongoing support, and handover.
Use PowerShell to manage and automate scheduled tasks.
Work closely with Operations, Underwriting, and Finance to ensure each group receives the data and outputs it needs.
Collaborate with the business analyst and project manager, translating the agreed process map into a working solution.
Communicate progress, design decisions, and risks clearly to the Head of Data Management and wider stakeholders.

Desired Qualifications

Working knowledge of the Lloyd’s insurance market.
Exposure to consortium, facility, binder, or delegated authority business.
Understanding of bordereaux production, coverholder commissions, and profit commission calculations.
Experience migrating on-premises SQL Server and SSIS workloads to Microsoft Fabric.
Experience delivering data to follow markets or other external counterparties.
Experience working alongside business analysts and project managers on a defined project.

Data Engineering Consultant - Consortium & Facility

G MASS · London, United Kingdom (Hybrid) · Contract · Posted 2026-11-10

Workplace: hybrid

Description

G MASS is deploying a Data Engineering Consultant to one of the leading syndicates in the Lloyd’s market. The client is experiencing strong business growth and has engaged G MASS to provide specialist data engineering capability to support it.

The consultant will deliver a dedicated, high-priority project: designing and building an automated, scalable and well-controlled data process that underpins key financial calculations and market reporting. The work has been ring-fenced so that it receives full focus alongside the client’s business-as-usual activity.

The groundwork is in place, with business analysis already completed and project management support available, allowing the consultant to concentrate on architecting and building the solution. Throughout the engagement, the consultant is backed by G MASS’s own data and technology leadership.

Purpose of the role

To build an automated, well-controlled and scalable process for the syndicate’s Consortium & Facility business, covering:

Production of bordereaux and additional data feeds for follow markets
Calculation of fees and profit commissions (PCs), including consortia fees and coverholder commissions
Reporting, dashboards and auditable controls across the end-to-end process

Scalability is the overriding design priority: the solution must be able to absorb a growing number of arrangements and increasing data volumes without a proportional increase in manual effort.

Responsibilities

Solution design and data engineering

Architect and build the end-to-end solution, taking ownership from design through to delivery as a hands-on engineer
Extract data from on-premise SQL Server databases and data warehouses and land it in Microsoft Fabric (Azure, OneLake)
Develop data pipelines and transformation logic using T-SQL and Python within Fabric
Design and maintain the mapping tables and reference data required for calculations

Fee and commission calculation

Enhance and automate the existing fee calculation process so that additional follow markets can be added efficiently
Enhance and automate the collection and processing of consortia fees and coverholder commissions
Build accurate, repeatable profit commission calculations

Data distribution and reporting

Build an efficient and scalable capability to provide data and bordereaux to follow markets, with controls embedded throughout
Develop a semantic layer over the data to support Power BI reporting and data exports
Create dashboards and outputs that feed Finance and Operations

Controls, governance and documentation

Design and implement auditable controls around all automated processes, giving clear visibility of what each process is doing
Produce clear technical and process documentation to support audit, ongoing support and handover
Use PowerShell to manage and automate scheduled tasks

Stakeholder Engagement

Work closely with Operations, Underwriting and Finance to ensure each group receives exactly the data and outputs it needs
Collaborate with the business analyst and project manager, translating the agreed process map into a working solution
Communicate progress, design decisions and risks clearly to the Head of Data Management and wider stakeholders

Requirements

Excellent Transact-SQL (T-SQL)
Strong knowledge of Microsoft SQL Server database systems and ETL tooling, including SSIS
Hands-on experience with Azure cloud data solutions, ideally Microsoft Fabric and OneLake
Python for data engineering, including data flows and notebooks within Fabric
Power BI, including building and maintaining semantic models and online reports
PowerShell for task automation and scheduling
A track record of designing and building end-to-end data solutions, from architecture through to delivery
Experience embedding auditable controls and reconciliations into automated processes

Desirable

Working knowledge of the Lloyd’s insurance market (strongly preferred)
Exposure to consortium, facility, binder or delegated authority business
Understanding of bordereaux production, Coverholder commissions and profit commission calculations
Experience migrating on-premise SQL Server and SSIS workloads to Microsoft Fabric
Experience delivering data to follow markets or other external counterparties
Experience working alongside business analysts and project managers on a defined project

Benefits

Initial 12 month contract

Apply

Apply at G MASS

About the Company

G MASS

Company size: Not listed
Company stage: Not listed
Total funding: Not listed
Headquarters: Not listed
Founded: Not listed

Recently Posted Jobs

Explore more opportunities at G MASS

See more jobs