About the Role
The EY Financial Services AI & Data team is seeking outstanding Data Modelers (Senior Consultants) with strong experience in AI and Data solution design and implementation within the Insurance domain. This role offers a variety of opportunities to make a tangible impact on client businesses and your career within a growing global practice.
Responsibilities
- Work as part of a delivery team on complex Data Transformation programs, focusing on data modelling, business analysis, data strategy, data analysis, solution design, and implementation management.
- Define data standards, canonical models, and entity relationships across domains with stakeholders.
- 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 for 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.
Requirements
- Previous FS experience in the 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.
- Demonstrable interest and awareness in emerging technologies.
Skills
- Advanced problem-solving skills
- Ability to communicate complex ideas effectively, both verbally and in writing
- Data modeling
- Data architecture
- Cloud data products delivery
- Erwin
- ER/Studio
- SqlDBM
- SQL DB-native modelling tools
- Azure Synapse
- Snowflake
- GCP BigQuery
- SQL
- Data warehousing
- Lakehouses
- OLTP/OLAP systems
Location
- London
- Edinburgh
Work Type
- Full-time
Experience Level
- Senior Consultant
Benefits
- Competitive remuneration package
- Support for flexible working
- Career development support
- FlexEY benefits package
- Holidays
- Health and well-being support
- Insurance
- Savings
- Wide range of discounts, offers and promotions
- Continuous learning opportunities
- Tools and flexibility for meaningful impact
- Coaching and confidence building for leadership
- Diverse and inclusive culture
About the Company
- 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.
