At a Glance
- Tasks: Lead the automation of data processes and design scalable data capabilities.
- Company: Join a well-established Lloyd’s market insurer with a strong reputation.
- Benefits: Initial 12-month contract with opportunities for growth and development.
- Other info: Collaborate with diverse teams and enhance your technical expertise.
- Why this job: Make a real impact by transforming data management in a dynamic environment.
- Qualifications: Strong SQL skills, experience with ETL tools, and knowledge of the Lloyd’s insurance market.
The predicted salary is between 63000 - 77000 £ per year.
ace are working with a well established Lloyd’s market insurer to appoint a Data Engineering Consultant to join their Data Management function, reporting into the Head of Data Management. This role will lead the move from manual to automated processing across the firm’s Consortium and Facility business. The successful candidate will design and build a scalable data capability that delivers bordereaux and supporting data feeds to follow markets, while automating the calculation of fees and profit commissions, including Consortia fees and Coverholder commissions. It is a hands on technical position with real ownership, suited to someone who combines strong SQL and automation skills with an understanding of how delegated business works in the London Market.
Responsibilities
- Design and deliver an automated, scalable process for producing bordereaux and data feeds to follow markets, with controls built in from the outset.
- Redevelop the current fee calculation process so additional follow markets can be onboarded efficiently.
- Automate the collection and processing of Consortia fees and Coverholder commissions.
- Calculate fees and profit commissions accurately across Consortium and Facility arrangements.
- Produce clear documentation and auditable controls covering all automated processes.
- Maintain and develop Power BI reporting for internal stakeholders.
- Work closely with underwriting, finance and operations colleagues to understand requirements and resolve data issues.
Requirements
- Excellent Transact SQL, with strong experience across Microsoft SQL Server and database design.
- Hands on experience with ETL tools and building automated data pipelines.
- Exposure to cloud data platforms, ideally Azure and Microsoft Fabric.
- Experience maintaining and developing Power BI reports.
- PowerShell scripting for task automation.
- Working knowledge of the Lloyd’s insurance market, ideally including delegated authority, bordereaux or fee and commission processes.
- Strong analytical ability, attention to detail and a structured approach to planning and problem solving.
- Confident engaging with stakeholders across technical and business teams.
Benefits
Initial 12 month contract.
Data Engineering Consultant - Consortium & Facility - G MASS Consulting employer: G MASS Consulting
G MASS Consulting is an exceptional employer, offering a dynamic work culture that fosters innovation and independence, particularly in the regulated insurance sector. Employees benefit from hands-on experience with cutting-edge technologies like SharePoint and Power Platform, alongside opportunities for professional growth and contract extensions. Located in a vibrant area, the company prioritises employee well-being and collaboration, making it an ideal place for those seeking meaningful and rewarding employment.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineering Consultant - Consortium & Facility - G MASS Consulting
✨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 Consulting 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 Consulting.
✨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 Consulting.
We think you need these skills to ace Data Engineering Consultant - Consortium & Facility - G MASS Consulting
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at G MASS Consulting, 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 Consulting, 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 Consulting’s attention and show the tangible impact of your work.
How to prepare for a job interview at G MASS Consulting
✨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 Consulting.
✨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 Consulting.
✨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 Consulting.
