Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and optimise data models for the Lloyd's of London insurance market.
- Company: Join a leading firm in the insurance sector with a focus on innovation.
- Benefits: Competitive daily rate, flexible working, and opportunities for professional growth.
- Why this job: Make an impact in the insurance industry while working with cutting-edge data technologies.
- Qualifications: Experience in data modelling and strong SQL skills required.
- Other info: Collaborative environment with a commitment to diversity and inclusion.
The predicted salary is between 40000 - 60000 £ per year.
We are seeking a highly experienced Data Modeller with deep expertise in the Lloyd's of London insurance market. The ideal candidate will be responsible for designing, implementing, and optimising complex data models that support underwriting, claims, pricing, and regulatory reporting processes. This role requires a strong understanding of insurance data structures, market-specific standards, and advanced data architecture principles.
Job Responsibilities/Objectives:
- Data Modelling & Architecture: Design and maintain conceptual, logical, and physical data models for insurance systems. Ensure alignment with Lloyd's market standards, including Core Data Record (CDR) and Blueprint Two initiatives. Develop and maintain data dictionaries, metadata, and data governance frameworks.
- Data Integration & Transformation: Collaborate with business analysts, actuaries, and IT teams to integrate data from multiple sources (policy, claims, bordereaux, exposure). Optimise data flows to support reporting, analytics, and regulatory compliance.
- Stakeholder Engagement: Work closely with underwriters, brokers, and market participants to gather and clarify data requirements. Provide subject matter expertise on Lloyd's data standards and market processes.
- Quality & Compliance: Implement data quality controls, validation rules, and monitoring processes. Ensure compliance with Lloyd's market regulations, GDPR, and Solvency II requirements.
Required Skills & Experience:
- Technical Expertise: Proven expertise in data modelling within the Lloyd's of London or London Market insurance sector. Strong proficiency in ER modelling, relational and dimensional modelling, and data warehousing concepts. Advanced SQL skills, with experience using tools such as ERwin, PowerDesigner, or equivalent data modelling platforms.
- Domain Knowledge: In-depth understanding of Lloyd's market processes, including placement, claims, and regulatory reporting. Familiarity with ACORD standards and Lloyd's Blueprint Two data initiatives.
- Analytical & Communication Skills: Ability to translate complex business requirements into robust, scalable data models. Excellent stakeholder management and communication skills, with the ability to engage both technical and non-technical audiences.
Preferred Qualifications:
- Experience with cloud-based data platforms (e.g., Azure).
- Knowledge of data governance frameworks and Master Data Management (MDM).
- Exposure to advanced analytics and BI tools such as Power BI and Tableau.
If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.
Data Modeler employer: Square One Resources
Contact Detail:
Square One Resources Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Modeler
✨Tip Number 1
Network like a pro! Reach out to folks in the Lloyd's of London insurance market on LinkedIn. Join relevant groups and engage in discussions to get your name out there and show off your expertise.
✨Tip Number 2
Prepare for interviews by brushing up on your data modelling skills. Be ready to discuss specific projects you've worked on, especially those involving ER modelling and compliance with Lloyd's standards. We want you to shine!
✨Tip Number 3
Don’t just apply anywhere; focus on companies that align with your experience in the insurance sector. Use our website to find roles that match your skills and interests, making it easier for us to help you land that dream job.
✨Tip Number 4
Follow up after interviews! A quick thank-you email can go a long way. It shows your enthusiasm for the role and keeps you fresh in their minds. Plus, it’s a great chance to reiterate why you’re the perfect fit!
We think you need these skills to ace Data Modeler
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Modeler role. Highlight your experience in the Lloyd's of London insurance market and any relevant data modelling projects you've worked on. We want to see how your skills align with what we're looking for!
Showcase Your Skills: Don’t just list your skills; demonstrate them! Use specific examples of how you've used ER modelling, SQL, or data governance frameworks in your previous roles. This helps us understand your expertise better.
Engage with the Job Description: Read the job description carefully and make sure your application reflects the key responsibilities and required skills. We love it when candidates show they’ve done their homework and understand what we need.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Square One Resources
✨Know Your Data Inside Out
Make sure you have a solid grasp of data modelling concepts, especially in the context of the Lloyd's of London insurance market. Brush up on your knowledge of Core Data Record (CDR) and Blueprint Two initiatives, as these will likely come up during the interview.
✨Showcase Your Technical Skills
Be prepared to discuss your experience with ER modelling, SQL, and any data modelling tools like ERwin or PowerDesigner. Bring examples of past projects where you've successfully designed and implemented data models, and be ready to explain your thought process.
✨Engage with Stakeholders
Demonstrate your ability to communicate effectively with both technical and non-technical audiences. Prepare to share how you've previously gathered data requirements from underwriters or brokers, and how you ensured alignment with market standards.
✨Highlight Compliance Knowledge
Familiarise yourself with GDPR and Solvency II requirements, as well as any relevant data governance frameworks. Be ready to discuss how you've implemented data quality controls and validation rules in your previous roles.
