Data Modeller – Insurance Experience Mandatory

Square One Resources

Job Title: Data Modeller – Insurance Experience Mandatory
Location: London/hybrid
Salary/Rate: Up to £550 per day inside IR35
Start Date: 16/03/2026
Job Type: Contract until the end of the year

Company Introduction

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 optimizing 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

• 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 data dictionaries, metadata, and governance frameworks.
• Collaborate with business analysts, actuaries, and IT teams to integrate data from multiple sources (policy, claims, bordereaux, exposure).
• Optimize data flows for reporting, analytics, and regulatory compliance.
• Work closely with underwriters, brokers, and market participants to understand data requirements.
• Provide subject matter expertise on Lloyd’s data standards and market processes.
• Implement data quality checks and validation rules.
• Ensure compliance with Lloyd’s market regulations, GDPR, and Solvency II requirements.

Required Skills/Experience
The ideal candidate will have the following:

• Expertise in data modelling within the Lloyd’s of London or London Market insurance sector.
• Proficiency in ER modelling, relational and dimensional modelling, and data warehousing.
• Strong SQL skills and experience with tools such as ERwin, PowerDesigner, or similar.
• Deep understanding of Lloyd’s market processes, including placement, claims, and regulatory reporting.
• Familiarity with ACORD standards and Lloyd’s Blueprint Two data initiatives.
• Ability to translate complex business requirements into robust data models.
• Excellent stakeholder management and communication skills.

Desirable Skills/Experience
Although not essential, the following skills are desired by the client:

• Experience with cloud-based data platforms (Azure,).
• Knowledge of data governance frameworks and MDM (Master Data Management).
• Exposure to advanced analytics and BI tools (Power BI, Tableau).

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.