Senior Consultant, Data Modelling B14,Speciality Insurance

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.