Data Engineering Consultant - Consortium & Facility
Consultant to design and build an automated, scalable data process for a Lloyd’s syndicate’s Consortium & Facility business.
- London, England, United Kingdom
- Contract
- Posted Nov 10, 2026
INDUSTRYSoftware & InternetData & Analytics
Responsibilities
- Solution design and data engineering
- Architect and build the end-to-end solution
- 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 existing fee calculation process
- Build accurate, repeatable profit commission calculations
- Build an efficient and scalable capability to provide data and bordereaux to follow markets
- 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
- Produce clear technical and process documentation
- Use PowerShell to manage and automate scheduled tasks
- Work closely with Operations, Underwriting and Finance
- Collaborate with the business analyst and project manager
- Communicate progress, design decisions and risks to the Head of Data Management and wider stakeholders
Requirements
- Experience in a Lloyd’s insurance market
Nice to have: Lloyd’s insurance market knowledge, Experience with consortium, facility, binder or delegated authority business, Understanding of bordereaux production, Coverholder commissions, Profit commission calculations, Migrating on-premise SQL Server and SSIS workloads to Microsoft Fabric, Delivering data to follow markets or other external counterparties, Working alongside business analysts and project managers on a defined project
Skills
T-SQLSQL ServerSSISAzureMicrosoft FabricOneLakePythonPower BIPowerShellT-SQLSSISAzureMicrosoft FabricOneLakePythonPower BIPowerShell
Full description
G MASSCompany details are for members
Sign up for a free job alert to see G MASS's profile, website and LinkedIn, and the same for every employer on Referso Jobs.