At a Glance
- Tasks: Design and build automated data processes for a leading syndicate in the Lloyd’s market.
- Company: Join G MASS, a specialist in data engineering with a focus on innovation.
- Benefits: 12-month contract with competitive pay and opportunities for professional growth.
- Other info: Collaborate with diverse teams and gain valuable insights into the Lloyd’s insurance market.
- Why this job: Make a real impact by enhancing data processes in a fast-growing environment.
- Qualifications: Strong T-SQL skills and experience with Azure cloud solutions required.
The predicted salary is between 72000 - 88000 £ per year.
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 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
Data Engineering Consultant - Consortium & Facility employer: G MASS
G MASS Consulting is an exceptional employer that fosters a dynamic and inclusive work culture in the heart of London. With a strong emphasis on employee growth, we offer comprehensive training and development opportunities, empowering our team to excel in their roles while contributing to impactful compliance solutions for our clients. Join us to be part of a forward-thinking organisation that values innovation and collaboration, making a meaningful difference in the financial sector.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineering Consultant - Consortium & Facility
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like G MASS before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like G MASS.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like G MASS.
We think you need these skills to ace Data Engineering Consultant - Consortium & Facility
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at G MASS, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to G MASS, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab G MASS’s attention and show the tangible impact of your work.
How to prepare for a job interview at G MASS
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at G MASS.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at G MASS.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at G MASS.