Senior AI & Data Consultant - Insurance & Financial Services

EY; Greater London; On-site; GBP 70,000 - 110,000; Full time

Benefits offered by this job

Flexible working

Total Rewards package

Career development

Diversity & inclusion

Job summary

EY is seeking a Senior Consultant in AI & Data for Financial Services, Insurance, based in London/Edinburgh. You will join a growing AI & Data team delivering data modelling, analytics, and AI-enabled solutions for clients in the Insurance sector.

You will lead data modelling workstreams, collaborate with data engineering and architecture teams, and contribute to proposals and thought leadership while leveraging cloud data platforms and modern data storage solutions.

Qualifications

• FS experience in the Insurance sector with a good understanding of business.
• Experience in data modeling, data architecture, or cloud data products delivery.
• Hands-on experience with cloud data platforms (Azure Synapse, Snowflake, GCP BigQuery).
• Strong SQL skills and knowledge of data warehousing, lakehouses, OLTP/OLAP systems.
• Awareness of emerging technologies and data engineering practices.

Responsibilities

• Work as part of a delivery team on complex data transformation programs focusing on data modelling.
• Define data standards, canonical models, and entity relationships across domains.
• Evaluate modeling best practices, tools, and automation to increase reuse and deployment efficiency.
• Lead design, development, and optimization of conceptual, logical, and physical data models.
• Collaborate with data engineering and architecture teams to align with storage and compute strategies.
• Manage delivery of physicalised data models and data products.
• Contribute to client proposals and thought leadership on enterprise data modelling and AI/ML readiness.

Skills

Data modeling

Data architecture

Cloud data platforms

SQL skills

Data modeling tools

Tools

Erwin

ER/Studio

SqlDBM

SQL DB-native modelling tools

Azure Synapse

Snowflake

GCP BigQuery

Job description

EY is seeking a Senior Consultant in AI & Data for Financial Services, Insurance, based in London/Edinburgh. You will join a growing AI & Data team delivering data modelling, analytics, and AI-enabled solutions for clients in the Insurance sector.

You will lead data modelling workstreams, collaborate with data engineering and architecture teams, and contribute to proposals and thought leadership while leveraging cloud data platforms and modern data storage solutions.