Back to jobs

Data Engineering Consultant - Consortium & Facility

London, England, United Kingdom

Actively hiring, first seen by us 8 hours ago
Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Contract — employment source
Employment type in the employer’s posting: Contract
From the employer’s posting

What you’ll work on

Full posting
  • Develop data pipelines and transformation logic using T-SQL and Python within Fabric

  • Build accurate, repeatable profit commission calculations

  • Build an efficient and scalable capability to provide data and bordereaux to follow markets, with controls embedded throughout

From the employer’s posting
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
Enhance and automate the collection and processing of consortia fees and coverholder commissions Build accurate, repeatable profit commission calculations Data distribution and reporting
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

What you’ll bring

All qualifications

Core experience

  • Strong knowledge of Microsoft SQL Server database systems and ETL tooling, including SSIS
  • Experience embedding auditable controls and reconciliations into automated processes
  • Understanding of bordereaux production, Coverholder commissions and profit commission calculations
  • Hands-on experience with Azure cloud data solutions, ideally Microsoft Fabric and OneLake
  • Experience migrating on-premise SQL Server and SSIS workloads to Microsoft Fabric
  • Python for data engineering, including data flows and notebooks within Fabric
Qualification wording
Strong knowledge of Microsoft SQL Server database systems and ETL tooling, including SSIS
Experience embedding auditable controls and reconciliations into automated processes
Understanding of bordereaux production, Coverholder commissions and profit commission calculations
Hands-on experience with Azure cloud data solutions, ideally Microsoft Fabric and OneLake
Experience migrating on-premise SQL Server and SSIS workloads to Microsoft Fabric
Python for data engineering, including data flows and notebooks within Fabric
Apply at G Mass

Posting record

Report an error

Actively hiringFirst seen by us today, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 2026today
Recorded sightings
2
Last seen by us
Nov 19, 2026
Employer says posted
Nov 10, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 0

Early. Similar jobs usually come down between day 6 and day 56.

From 14,030 similar postings that came down. Coming down is not always a hire.

G Mass is hiring

11 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • T-SQL
  • Azure
  • Power BI
  • SQL Server
  • SSIS
Where the posting names them
- 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
- 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
- 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
Requirements - Excellent Transact-SQL (T-SQL) - Strong knowledge of Microsoft SQL Server database systems and ETL tooling, including SSIS
- 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
- 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
- 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
- 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
- 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

Your next step

Complete your application on apply.workable.com. The employer’s form will show what is required.

Applying through Workable

  • No account needed. You can import your resume to fill in the form, or skip that and fill it in yourself.

Already applied? Track this application

Job description

View original posting ↗

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

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 14% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 860, the most 1,353, and the latest week had 1,020.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

London, England, United Kingdom

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.