EY - GDS Consulting - AI And DATA - Data Modeller - Data Vault - Senior

The opportunity

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

Hands-on experience with one or more reporting and analytics platforms like Power BI, MicroStrategy (MSTR), Tableau, Qlik Sense/QlikView, SSRS

Technical Skills

• Advanced SQL (mandatory)
• Strong understanding of Data Warehousing, ETL/ELT Processes, Data Integration, APIs and Data Interfaces
• Experience with databases like SQL Server, Oracle, PostgreSQL, Snowflake, Azure SQL
• Exposure to at least one cloud platforms: Azure, AWS, Google Cloud Platform (GCP)

Good to Have

• Experience within the UK Insurance market, including General Insurance, London Market Insurance, Syndicate and MGA environments London Market Insurance

Experience

• 7+ years of experience in Data Analysis, Business Analysis, Data Consulting, and Data Management.
• 5+ years of Data Modelling experience, including Data Vault modelling.
• Experience delivering data migration, reporting, or digital transformation programmes.
• Insurance industry experience is mandatory.
• UK Insurance market experience is highly desirable.

Ideally, you’ll also have

• Strong project management skills
• Client management skills
• Solutioning skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.  

Apply now » Apply now

• Start applying with LinkedIn