Senior Data Modeler

Job Summary

We are seeking an experienced Techno-Functional Data Consultant with strong expertise in Insurance Data Management, Data Modelling, Business Analysis, Reporting & Analytics, and Data Migration. The ideal candidate will act as a bridge between business stakeholders and technical teams, translating business requirements into scalable data solutions that support operational, analytical, and reporting needs.

The role requires hands-on experience in Data Vault modelling, dimensional modelling, data analysis, reporting tools, and insurance data domains. Experience working within the UK Insurance Market is highly desirable.

Your Key Responsibilities

Business Analysis & Stakeholder Management

• Collaborate with business users, SMEs, architects, and delivery teams to gather and document functional and data requirements.
• Conduct workshops to understand business processes, reporting needs, and data challenges.
• Translate business requirements into functional specifications, data models, and reporting solutions.
• Perform impact assessments and support change management activities.
• Act as the key liaison between business and technology teams.

Data Analysis & Data Management

• Perform data profiling, gap analysis, and source-to-target data mapping.
• Analyse large and complex datasets to identify data quality issues and transformation requirements.
• Define business rules, validation rules, and reconciliation requirements.
• Support data governance, metadata management, and data lineage initiatives.
• Ensure consistency and integrity of data across operational and analytical platforms.

Data Modelling

• Design and maintain Conceptual Data Models, Logical Data Models and Physical Data Models

• Develop and maintain enterprise data models and data dictionaries.

• Design scalable data structures for operational and analytical solutions.

• Implement best practices in:

• Data Vault 2.0 Modelling (Hubs, Links, Satellites)

• Dimensional Modelling (Star Schema, Snowflake Schema)

• Canonical Data Models

• Enterprise Data Models

• Collaborate with Data Architects and Engineering teams to ensure alignment with enterprise architecture standards.

Reporting & Analytics

• Gather and define reporting and dashboard requirements from business stakeholders.
• Design reporting data models and analytical datasets.
• Support development and optimization of business intelligence solutions.
• Work closely with analytics teams to ensure accurate and meaningful reporting outputs.
• Define KPIs, metrics, and reporting standards.

Data Migration & Integration

• Support large-scale data migration and transformation programmes.
• Develop source-to-target mapping specifications.
• Define migration and reconciliation rules.
• Support SIT, UAT, and production validation activities.
• Work alongside Data Engineering and Integration teams to ensure successful delivery.

Mandatory Skills & Experience

Insurance Domain Expertise

• Strong understanding of insurance business processes and data structures.
• Experience in Policy Administration, Underwriting, Claims, Billing & Finance, Customer Management, Broker Management and Reinsurance

Data & Business Analysis

• Strong business and data analysis skills.
• Experience gathering and documenting business requirements.
• Expertise in data mapping, profiling, and validation.
• Strong understanding of data governance and data quality frameworks.

Data Modelling (Mandatory)

• Minimum 5 years of hands-on data modelling experience.

• Strong expertise in:

• Data Vault 2.0

• Dimensional Modelling

• Relational Data Modelling

• Data Warehousing Concepts

• Experience using modelling tools such as:

• ERwin

• ER/Studio

• SAP PowerDesigner

• Visio

• Lucidchart

Reporting & BI Tools