Data Modeller CGEMJP00299276

Experis - ManpowerGroup; London; Hybrid; GBP 100,000 - 125,000; Full time

Job summary

A leading company in the insurance sector is seeking a Data Modeler to design and validate data models that support enterprise data initiatives. This hybrid role requires expertise in the London Market insurance sector and proficiency in data modeling tools. The successful candidate will work closely with data engineers and business stakeholders to ensure data structures meet regulatory standards and business needs.

Qualifications

• Experience in the London Market insurance sector is essential.
• Strong experience in conceptual, logical, and physical data modeling.
• Proficiency in SQL and cloud data platforms.

Responsibilities

• Design and maintain data models for reporting and analytics.
• Collaborate with data engineers to ensure correct implementation.
• Document data definitions and relationships.

Skills

Data modeling

SQL

Data governance

Communication

Tools

Erwin

ER/Studio

dbt

Azure

AWS

GCP

Job description

Role Title: Data Modeler
Duration: contract to run until 31/12/2025
Location: London, Hybrid 2-3 days per week onsite
Rate: up to £644 p/d Umbrella inside IR35

Role purpose / summary

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!