Senior Consultant, Data Modelling B14,Speciality Insurance

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

Job summary

An established industry player in financial services is seeking a Senior Consultant specializing in Data Modeling. This role offers the opportunity to work collaboratively with clients, leveraging data and analytics to solve complex business challenges. You will be instrumental in designing and implementing innovative data solutions within the Specialty Insurance domain. Join a dynamic team that values continuous learning and personal growth, while making a tangible impact on client success. If you are passionate about data technology and eager to drive meaningful change, this position is perfect for you.

Benefits

Flexible Working

Career Development Support

Health and Well-being Benefits

Discounts and Promotions

Continuous Learning Opportunities

Diverse and Inclusive Culture

Qualifications

• Experience in data modeling within the Financial Services sector.
• Strong understanding of data governance and quality principles.

Responsibilities

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

Skills

Data Modeling

AI Solutions

Problem-Solving

SQL

Data Governance

Analytical Skills

Education

Bachelor's Degree in Computer Science

Master's Degree in Data Science

Tools

Erwin

SQL DBM

Azure Synapse

Snowflake

GCP BigQuery

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Select how often (in days) to receive an alert:

Senior Consultant, Data Modelling B14,Speciality Insurance

Location: London

Other locations: Primary Location Only

Date: 2 May 2025

Requisition ID: 1598558

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

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.

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