Senior Data Modeler

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.

• 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.

• 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.

• 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.

• 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.

• 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.

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

• 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.

• 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