Data Modeler

JR United Kingdom; Chester; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading company in the insurance sector is seeking an On-site Data Modeler to translate complex reinsurance data into robust models supporting pricing and actuarial systems. This role involves collaboration with cross-functional teams and the implementation of data governance policies to ensure high-quality insights. Candidates should possess strong SQL skills, business analysis experience, and a background in pricing and actuarial data.

Qualifications

• Proven experience in pricing and actuarial data, preferably in reinsurance.
• Solid background in the insurance/reinsurance sector with SQL expertise.
• Exceptional data analysis skills with a focus on quality and governance.

Responsibilities

• Support Data Architect in defining data models aligned with user stories.
• Run workshops to elicit and document detailed data requirements.
• Write and optimise complex SQL queries for ETL processes.

Skills

Business Intelligence Analysis

Data Quality

Data Governance

SQL

Excel

Data Modeling

Problem Solving

Tools

Microsoft SQL Server

VBA

Job description

Social network you want to login/join with:

Start Date: ASAP – 31 December 2025

Role Overview

As an On-site Data Modeler, you will translate complex reinsurance data into robust, scalable models that power our pricing and actuarial systems. You’ll collaborate with actuaries, underwriters and project teams to ensure data quality, governance and business intelligence (BI) insights are delivered to tight deadlines.

Key Responsibilities

• Data Modelling & Schema Design: Support the Data Architect in defining logical and physical models, ensuring alignment with MVP user stories and solution design.
• Requirements Capture: Run workshops with stakeholders to elicit and document detailed data requirements, mapping attributes to our data warehouse and downstream systems.
• BI Analysis: Leverage business intelligence tools to interpret complex data sets, produce dashboards and drive actionable insights.
• SQL Development: Write and optimise complex Microsoft SQL Server queries for data extraction, transformation and loading (ETL).
• Data Governance: Implement master data management and governance policies to maintain data quality, compliance and lineage.
• Stakeholder Management: Communicate effectively with project managers and cross-functional teams, ensuring transparency on deliverables and timelines.

Candidate Profile

• Proven pricing and actuarial data experience, preferably in reinsurance.
• Solid background in the insurance/reinsurance sector and familiarity with reinsurance pricing projects.
• Expert in SQL (Microsoft SQL Server) and strong Excel/VBA capabilities.
• Exceptional data analysis skills, with a keen eye for data quality and governance best practices.
• Demonstrable experience in Business Analysis, Requirements Analysis and Data Modeling.
• Excellent problem-solving mindset and clear, persuasive communication style.

Primary Skill: BI Analysis