Entdecken Sie Ihre Traumkarriere
Für Arbeitgeber

Data Engineering Consultant - Consortium & Facility

G MASS Consulting London, Vereinigtes Königreich
Gepostet vor 8 Tagen Befristet Competitive

Data Engineering Consultant - Consortium & Facility

G MASS Consulting London, Vereinigtes Königreich

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

Job ID  7939A06D2C
Mehr Jobs von G MASS Consulting
G MASS Consulting
Regulatory Reporting Assurance Consultant
G MASS Consulting
London, United Kingdom
vor 6 Tagen Vollzeit Competitive
G MASS Consulting
Trade Surveillance Specialist
G MASS Consulting
London, United Kingdom
vor 6 Tagen Vollzeit Competitive
G MASS Consulting
Risk Analytics Analyst / Senior Analyst
G MASS Consulting
London, United Kingdom
vor 1 Tag Vollzeit Competitive
G MASS Consulting
Scrum Master (IT Operations) - London Market Insurer
G MASS Consulting
London, United Kingdom
vor 1 Tag Vollzeit Competitive
G MASS Consulting
Project Analyst, AI Transformation
G MASS Consulting
London, United Kingdom
vor 1 Tag Vollzeit Competitive
G MASS Consulting
AI Transformation Lead
G MASS Consulting
London, United Kingdom
vor 1 Tag Vollzeit Competitive
G MASS Consulting
IT Service Desk & Service Delivery Manager
G MASS Consulting
London, United Kingdom
vor 2 Tagen Vollzeit Competitive
G MASS Consulting
Interim IT Director, London Market Insurance
G MASS Consulting
London, United Kingdom
vor 2 Tagen Vollzeit Competitive
G MASS Consulting
Service Desk Analyst
G MASS Consulting
London, United Kingdom
vor 2 Tagen Vollzeit Competitive
G MASS Consulting
Calypso Equity Swaps Functional SME
G MASS Consulting
London, United Kingdom
vor 2 Tagen Vollzeit Competitive

Treiben Sie Ihre Karriere voran

Finden Sie Tausende von Stellenangeboten, indem Sie sich noch heute bei eFinancialCareers anmelden.
Empfohlene Jobs
Data Analyst
Datasource
London, United Kingdom
Mayford James
Data Analytics Specialist
Mayford James
London, United Kingdom
Morgan McKinley
Data Engineer
Morgan McKinley
London, United Kingdom
Data Platform Data Engineer - AVP
Sumitomo Mitsui Financial Group, Inc.
London, United Kingdom