EY - GDS Consulting - AI And DATA - Data Modeller - Data Vault - Senior
EY
A complete application in a minute
Tailored resume and cover letter, ready to send.
Job summary
EY GDS – Data and Analytics is seeking a Senior Techno-Functional Data Modeller and Analyst for Insurance. The role bridges business and technical teams, delivering data models, analytics, and migration strategies across Insurance domains and reporting platforms.
The candidate will contribute to Data Vault 2.0 modelling, dimensional modelling, and enterprise data models while collaborating with Data Architects and Engineering teams to align with EY standards and the UK market experience.
Qualifications
- Minimum 5 years of hands-on data modelling experience.
- Strong expertise in Data Vault 2.0, dimensional modelling and data warehousing concepts.
- Experience with insurance data domains and reporting/analytics tools.
- UK Insurance market experience is highly desirable.
Responsibilities
- Collaborate with business users, SMEs, architects, and delivery teams to gather functional and data requirements.
- Conduct workshops to understand processes, reporting needs, and data challenges.
- Translate business requirements into data models, specifications and reporting solutions.
- Support data governance and data quality initiatives.
- Act as liaison between business and technology teams.
Skills
Tools
Job description
Job Description:
At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.
EY GDS – Data and Analytics (D&A) – Techno-Functional Data Modeller and Analyst – Insurance (Senior Con.)
As part of our EY-GDS D&A team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance
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
Hands‑on experience with one or more reporting and analytics platforms like Power BI, MicroStrategy (MSTR), Tableau, Qlik Sense/QlikView, SSRS
- 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)
- Experience within the UK Insurance market, including General Insurance, London Market Insurance, Syndicate and MGA environments London Market Insurance
- 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.
- Strong project management skills
- Client management skills
- Solutioning skills
- People with technical experience and enthusiasm to learn new things in this fast-moving environment
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.
Requirements:
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
