Data Modeler

Job Title: Data Modeler
Location: London (3/4 x per week on site)
Salary/Rate: Up to £537 per day
Start Date: Feb / Mar 2026
Job Type: 12 month contract (IR35 contract)

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 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).

• Optimize 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.

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.