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

EY; City Of London; On-site; GBP 60,000 - 90,000; Full time

Job summary

A global consulting firm is looking for a Senior Consultant to join their AI & Data team in London. The role involves data modeling and supporting transformations in the Lloyds and London Market Insurance sector. Ideal candidates will have strong problem-solving skills, SQL expertise, and experience with data platforms. A competitive salary and flexible benefits package are offered.

Benefits

Continuous learning

Success defined by you

Transformative leadership

Diverse and inclusive culture

Qualifications

• FS experience in Lloyds & London Insurance Sector.
• Experience in data modeling and architecture.
• Strong SQL skills and knowledge of data warehousing.

Responsibilities

• Work on complex Data Transformation programs.
• Define data standards and canonical models.
• Collaborate with engineering teams for model optimization.

Skills

Data modeling

Problem-solving

Business analysis

Stakeholder engagement

Tools

Erwin

SQL DB-native modeling tools

Azure Synapse

Snowflake

GCP BigQuery

Job description

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.

Senior Consultant, AI & Data, Financial Services, Data Modelling, Lloyds & London Market Insurance – London

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

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.

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.

Tech

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.