Data Modeler

JR United Kingdom; City Of London; On-site; GBP 100,000 - 125,000; Full time

Job summary

A leading company in the insurance sector seeks an experienced Data Modeller to join their team. The role involves designing and validating data models that support enterprise data initiatives. The successful candidate will collaborate closely with data engineers and business stakeholders to create scalable and business-aligned data structures. Expertise in the London Market and familiarity with data governance is essential for this position, which offers a contract until December 2025 and a competitive daily rate.

Qualifications

• Proven expertise in data modeling for the insurance sector.
• Familiarity with regulatory data requirements such as Solvency II.
• Strong understanding of data architecture, including data lakes.

Responsibilities

• Design and maintain data models supporting analytics and operational systems.
• Collaborate with data engineers to ensure accurate implementation.
• Document data relationships using industry-standard tools.

Skills

Data modeling

SQL

Data governance

Communication

Education

Experience in London Market insurance

Tools

Erwin

dbt

ER/Studio

Azure

AWS

GCP

JIRA

Confluence

Azure DevOps

Job description

Social network you want to login/join with:

Duration: contract to run until 31/12/2025

Rate: up to £644 p/d Umbrellainside IR35

We are seeking an experienced Data Modeller with proven expertise in the London Market insurance sector. The successful candidate will play a key role in designing and validating data models that support enterprise data initiatives. This includes working closely with data engineers, architects, and business stakeholders to ensure data structures are scalable, accurate, and aligned with business needs.

Key Skills/ requirements

• Design and maintain conceptual, logical, and physical data models to support reporting, analytics, and operational systems.
• Collaborate with data engineers and analysts to ensure models are implemented correctly and efficiently.
• Translate complex business requirements into scalable and maintainable data structures.
• Ensure data models comply with data governance, compliance, and London Market regulatory standards.
• Document data definitions, relationships, and lineage using industry-standard modeling tools.
• Support data quality initiatives by identifying gaps and inconsistencies in source systems and downstream usage.

Qualifications:

• London Market insurance experience is essential, including familiarity with market data structures and regulatory reporting.
• Strong experience in data modeling (conceptual, logical, physical) using tools such as Erwin, ER/Studio, or dbt.
• Solid understanding of data warehousing, data lakes, and enterprise data architecture.
• Proficiency in SQL and experience working with cloud data platforms (e.g., Azure, AWS, GCP).
• Familiarity with data governance frameworks, metadata management, and data cataloging tools.
• Excellent communication and documentation skills, with the ability to explain complex data concepts to non-technical stakeholders.

Preferred Skills:

• Experience with insurance platforms such as Guidewire, Duck Creek, or legacy PAS systems.
• Knowledge of Delta Lake, Apache Spark, and data pipeline orchestration tools.
• Exposure to Agile delivery methodologies and tools like JIRA, Confluence, or Azure DevOps.
• Understanding of regulatory data requirements such as Solvency II, Core Data Record (CDR), or Blueprint Two.

All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!