EY - GDS Consulting - AI And DATA - Data Consultant - Senior

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 Consultant – Insurance (Senior Con.)

As part of our EY-GDS D&A (Data and Analytics) 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

The opportunity

We are seeking a highly motivated Techno-Functional Data Consultant to bridge the gap between business stakeholders and technical teams within our insurance data transformation and migration initiatives. The ideal candidate will possess strong data analysis and data modelling capabilities, coupled with a solid understanding of insurance business processes and data structures.

This role will be responsible for translating business requirements into data solutions, supporting data migration and integration activities, defining data models, and ensuring data quality across strategic insurance platforms.

Your Key Responsibilities

Business & Functional Analysis

• Collaborate with business stakeholders, SMEs, and product owners to understand business processes, data requirements, and reporting needs.
• Elicit, document, and validate functional and data requirements.
• Conduct impact assessments for business and regulatory changes affecting data assets.
• Facilitate workshops and act as a liaison between business and technical teams.

Data Analysis & Data Management

• Perform detailed source-to-target data analysis and mapping.
• Analyse complex datasets to identify data quality issues, gaps, inconsistencies, and transformation requirements.
• Support data governance initiatives, including data lineage, data definitions, and business rules documentation.
• Define and validate data migration and reconciliation rules.

Data Modelling

• Design and maintain conceptual, logical, and physical data models.
• Develop entity relationship diagrams (ERDs) and data dictionaries.
• Define data structures, relationships, and business rules to support operational and analytical requirements.
• Ensure alignment between business processes and target data architecture.
• Collaborate with solution architects and development teams to implement data models.
• Work closely with ETL, Data Engineering, and Development teams to ensure requirements are accurately implemented.

Required Skills & Experience

Data Modelling Skills

• Demonstrable experience in conceptual, logical, and physical data modelling.
• Proficiency with data modelling tools such as ERwin, ER/Studio, SAP PowerDesigner, Lucidchart, Visio, or similar.
• Strong understanding of relational databases and data architecture principles.
• Experience creating and maintaining enterprise data models and data dictionaries.

Functional Skills

• Strong understanding of insurance business processes and data.
• Experience working on policy, customer, claims, underwriting, or broker data domains.
• Proven experience in requirements gathering, business analysis, and stakeholder management.
• Ability to translate business requirements into technical and data specifications.

Data Skills

• Strong data analysis skills using SQL(mandatory) and related data tools.
• Hands-on experience in data profiling, data quality assessment, and data mapping.
• Experience in data migration and system transformation projects.
• Understanding of data governance and master data management principles.
• Hands-on experience with one or more reporting and analytics platforms like Power BI, MicroStrategy (MSTR), Tableau, Qlik Sense/QlikView
• Experience in Dashboard design and development, KPI definition and reporting frameworks, Semantic data models, Self-service reporting solutions, Executive and operational reporting

Technical Skills

• Experience working with relational databases such as SQL Server, Oracle, PostgreSQL, or similar.
• Understanding of data warehousing and ETL concepts.
• Familiarity with APIs, integrations, and cloud-based data platforms

Good to Have

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

Experience

• 5+ years of experience in Business Analysis, Data Analysis, Data Consulting, or Data Migration roles.
• Minimum 5+ years of hands-on data modelling experience.
• Insurance domain experience preferred.
• UK Insurance market experience 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.