Salary: £80,000 - 90,000 per year Requirements: 10 years of experience in data modelling within the Lloyds 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 Lloyds market processes, including placement, claims, and regulatory reporting. Familiarity with ACORD standards and Lloyds Blueprint Two data initiatives. Ability to translate complex business requirements into robust data models. Excellent stakeholder management and communication skills. Experience with cloud-based data platforms (Azure) preferred. Knowledge of data governance frameworks and MDM (Master Data Management) preferred. Exposure to advanced analytics and BI tools (Power BI, Tableau) preferred. Responsibilities: Design and maintain conceptual, logical, and physical data models for insurance systems. Ensure alignment with Lloyds 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 Lloyds data standards and market processes. Implement data quality checks and validation rules. Ensure compliance with Lloyds market regulations, GDPR, and Solvency II requirements. Technologies: Azure Cloud Support Power BI SQL Tableau More: We are seeking a highly experienced Data Modeller with deep expertise in the Lloyds of London insurance market. The successful candidate will design, implement, and optimize complex data models that support underwriting, claims, pricing, and regulatory reporting processes. We offer a competitive salary ranging from £80k to £90k, along with a 15% cash flex, bonuses, and benefits. This position is hybrid, based in London. last updated 10 week of 2026