Senior Consultant, AI & Data, Speciality Insurance, Lloyds London Market, FS

Ernst & Young Advisory Services Sdn Bhd; City Of London; On-site; GBP 60,000 - 90,000; Full time

Job summary

A global consulting firm is seeking a Senior Consultant specialized in AI & Data within the Lloyds London Market. This role involves data modeling, business analysis, and collaborative problem-solving strategies to improve client solutions. Candidates with experience in data architecture and cloud platforms are preferred. The firm offers opportunities for continuous learning and success defined by individual impact.

Benefits

Continuous learning opportunities

Flexible tools to make a meaningful impact

Transformative leadership coaching

Diverse and inclusive culture

Qualifications

• Previous FS experience in Lloyds & London Insurance Sector.
• Experience in data modeling and data architecture.
• Strong experience with cloud data platforms.

Responsibilities

• Work on complex Data Transformation programs focusing on data modeling.
• Define data standards and entity relationships.
• Lead design, development, and optimization of data models.

Skills

Data modeling

Problem-solving

SQL skills

Understanding of business in Lloyds & London Insurance Sector

Communication skills

Awareness of emerging technologies

Tools

Erwin

ER/Studio

SQL DB-native modelling tools

Azure Synapse

Snowflake

GCP BigQuery

Job description

Overview

Senior Consultant, AI & Data, Speciality Insurance, Lloyds London Market, FS

Location: London

Date: 23 Oct 2025

Requisition ID: 1615446

The opportunity

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 Lloyds & London Market 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 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 Lloyds & London 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

• 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.

If you can demonstrate that you meet the criteria above, please contact us as soon as possible. The exceptional EY experience. It’s yours to build.

Apply now.

EY | Building a better working world

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.

Provider

Description

Enabled

SAP as service provider

• "route" is used for session stickiness
• "careerSiteCompanyId" is used to send the request to the correct data centre
• "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor