Senior Consultant, Data Modelling B14,Speciality Insurance

EY; London; On-site; GBP 60,000 - 100,000; Full time

Job summary

Join a forward-thinking firm as a Senior Consultant in AI & Data, focusing on financial services. This role offers the chance to work on complex data modeling projects within the Specialty Insurance domain. You will lead the design and optimization of data architectures while collaborating with clients to solve intricate business problems. This innovative team values continuous learning and offers a diverse and inclusive culture, empowering you to make a meaningful impact. If you're passionate about data-driven solutions and eager to grow in a dynamic environment, this opportunity is perfect for you.

Benefits

Flexible working

Career development support

Health and well-being benefits

Insurance options

Savings plans

Discounts and promotions

Qualifications

• Strong experience in data modeling and architecture.
• Deep expertise in relational and dimensional modeling techniques.

Responsibilities

• Lead the design and optimization of data models for analytics and reporting.
• Collaborate with stakeholders to define data standards and relationships.

Skills

Data Modeling

Data Architecture

SQL

Problem-Solving

Cloud Platforms

Data Governance

Analytical Skills

Education

Degree in Data Science or related field

Tools

Erwin

ER/Studio

SQL DB-native modeling tools

Azure Synapse

Snowflake

GCP BigQuery

Job description

Senior Consultant, AI & Data, Financial Services, Data Modelling + Speciality 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 Specialty 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. We provide expertise and delivery in three core areas which all work closely together:

• Data Architecture & Engineering – Focusing on next generation data solution architecture design and implementation
• Data Management & Strategy – Supporting our clients with Data Strategy, Data Governance Data and Analytics Target Operating Model Design and wider Data Office and CDO support functions

Your key responsibilities

• Work as part of a delivery team on complex Financial Services programs, primarily focusing on data modeling, with additional roles likely to include techno-functional analysis, data strategy, data analysis, solution design, and end-to-end implementation management.
• Lead the design, development, and optimization of conceptual, logical, and physical data models to support analytics, reporting, machine learning, and transactional use cases.
• Translate complex business and analytical requirements into scalable data structures across cloud platforms (Azure, AWS, GCP,Snowflake) and modern data architectures (e.g., data Lakehouse, data mesh).
• Work with stakeholders to define data standards, canonical models, and entity relationships across domains.
• Collaborate with data engineering and architecture teams to ensure models are performance-optimized and aligned with storage, compute, and pipeline strategies.
• Provide governance support by defining metadata, lineage, and documentation for critical data assets.
• Evaluate and introduce modeling best practices, tools, and automation to increase model reuse, version control, and deployment efficiency.
• Lead data modeling reviews, ensuring consistency across programs, and contribute to architecture boards or governance forums.
• 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 Insurance Sector with a good understanding of Speciality Insurance especially Llyods of London Market
• Experience in data modeling, data architecture, or enterprise data design
• Deep expertise in relational, dimensional, and canonical data modeling techniques.
• Strong experience with data modeling tools such as Erwin, ER/Studio,SqlDBM or SQL DB-native modeling 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.
• Solid understanding of data governance, data quality, and master data management principles.
• Familiarity with data privacy, compliance, and security standards (e.g., GDPR, PCI-DSS).
• Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical specifications
• Understanding of technology trends and implications on the FS industry, including data platforms, digital drivers, cloud architecture, integration tools & approaches AI methods & techniques and the challenges faced in establishing effective delivery of value across the business
• 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.