Senior Consultant, AI&Data, Insurance, FS

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

Senior Consultant, AI & Data, Financial Services, Insurance London/Edinburgh

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.

Join EY and help to build a better working world.

The EY Financial Services AI & Data team is continuing to grow and develop unique advisory propositions aligned to market needs and demand. We are currently seeking outstanding Data Modelers (Senior Consultants) with strong experience in AI and Data solution design and implementation within the Insurance domain to join our team and contribute to our ongoing growth and success on a global scale. Joining EY’s AI & Data team in this exciting period of growth will offer a huge variety of opportunity to make a tangible impact to our clients businesses and to your career.

The opportunity

The AI & Data practice works collaboratively with our clients to enhance their ability to solve complex business problems by exploiting data and analytics strategies and solutions.

Your key responsibilities

• Work as part of a delivery team on complex Data Transformation programs, primarily focusing on data modelling, with additional roles likely to include business analysis, data strategy, data analysis, solution design, and implementation management.
• Work with stakeholders to define data standards, canonical models, and entity relationships across domains.
• Evaluate and introduce modeling best practices, tools, and automation to increase model reuse, version control, and deployment efficiency.
• Lead the design, development, and optimization of conceptual, logical, and physical data models to support analytics, reporting, machine learning, and transactional use cases.
• Collaborate with data engineering and architecture teams to ensure models are performance-optimized and aligned with storage, compute, and pipeline strategies.
• Manage delivery of Physicalised data models and data products build
• Contribute to client proposals, RFP responses, and thought leadership related to enterprise data modelling and AI/ML readiness.

Skills and attributes for success

We’re looking for people with a passion for the delivery of data technology solutions that deliver positive outcomes for customers, regulators and shareholders. You should advanced problem-solving skills and the ability to communicate complex ideas effectively, both verbally and in writing

To qualify for the role you must have some or all of the following:

• Previous FS experience in the Insurance Sector with a good understanding of business
• Experience in data modeling, data architecture, or cloud data products delivery
• Strong experience with data modeling tools such as Erwin, ER/Studio, SqlDBM or SQL DB-native modelling tools.
• Hands-on experience with cloud data platforms (Azure Synapse, Snowflake, GCP BigQuery) and modern data storage solutions.
• Strong SQL skills and good knowledge of data warehousing, lakehouses, and OLTP/OLAP systems.
• Demonstratable interest and awareness in emerging technologies

What we look for

We are looking for highly motivated individuals who are passionate about Data and Analytics and want to assist clients to become truly data driven organisations. If you think you can meet the challenges of a focused consulting organisation, understand how to grow and lead within a large practice and are eager to work in highly complex sectors, our AI and Data team is looking forward to hearing from you.

What working at EY offers

We offer a competitive remuneration package where you’ll be rewarded for your individual and team performance. Our comprehensive Total Rewards package includes support for flexible working and career development, and with FlexEY you can select benefits that suit your needs, covering holidays, health and well-being, insurance, savings and a wide range of discounts, offers and promotions. Plus, we offer:

• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.