Data Modeller - Insurance Experience Mandatory

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

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

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.