Manager, Data Modelling, AI&Data, Speciality Insurance, FS

Ernst & Young; Camden Town; On-site; GBP 80,000 - 100,000; Full time

Job summary

A leading consulting firm in the UK is seeking a Data Architect/Modeler to join their AI & Data team. The role involves leading data transformation programs and collaborating with business units to improve data architecture. Ideal candidates will have extensive experience in data modelling, especially within the London Market Commercial and Specialty Insurance sectors. Join us to make a tangible impact on client businesses and enhance your career.

Benefits

Flexible working

Career development support

Comprehensive Total Rewards package

Qualifications

• Proven experience in data modelling within London Market Commercial and Specialty Insurance.
• Understanding of different Data Modelling approaches.
• Excellent stakeholder engagement and facilitation skills.

Responsibilities

• Lead data architecture and data modelling for complex Data Transformation programs.
• Collaborate with business SMEs to capture requirements and validate models.
• Establish data modelling standards and principles.

Skills

Data modelling

Stakeholder engagement

Problem-solving

Tools

ERwin

PowerDesigner

SQL Data Modeler

Job description

About the Role

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 Architects and Modelers (Managers) with strong experience in AI and Data solution design and implementation within the London Market Commercial & 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.

Your key responsibilities

• Work as part of a delivery team on complex Data Transformation programs, primarily leading on data architecture and data modelling, with additional roles likely to include leading on business analysis, data strategy and solution design
• Lead Data Modelling Activities: Develop conceptual, logical, and physical data models for core insurance domains (e.g., Policy, Premiums, Claims, Risk, Bordereaux) aligned to Lloyd's CDR and Accord data standards.
• Blueprint Two Alignment: Interpret Lloyd's CDR specifications to design data structures that support consistent capture, storage, and exchange of data across the insurance value chain.
• Foundation for Transformation: Establish data modelling standards and principles, naming conventions, and metadata standards, design patterns as the basis for the upcoming data transformation programme.
• Business Engagement: Collaborate with business SMEs from underwriting, claims teams, operations, and finance to capture requirements, resolve data definitions, and validate models.
• Data Quality & Governance: Define master data and reference data structures to ensure completeness, accuracy, and regulatory compliance.
• Tooling & Standards: Leverage data modelling tools (e.g., ERwin, PowerDesigner, SQL Data Modeler, etc.) and maintain modelling repositories.
• Collaborate with enterprise architects, solution designers, and data platform teams to embed data models into the technology landscape.
• Contribute to client proposals, RFP responses, and thought leadership related to data strategy, data architecture and data transformation initiatives.

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.

Qualifications

• Proven experience in data modelling within London Market Commercial and Specialty Insurance markets. Strong understanding of Lloyd's market operations, London Market processes, Core Data Record specifications.
• Expertise in building conceptual, logical, and physical data models for core insurance entities and processes.
• Understanding of different Data Modelling approaches – i.e. relational data model, 3rd normal form, Dimensional data model, Star /Snowflake Schema, Data Vault etc.
• Good understanding of Data Warehousing design concepts (e.g., Inmon & Kimbal style of data architectures).
• Experience translating regulatory and market standards into practical, implementable data structures.
• Knowledge of insurance reference data (e.g., class of business codes, market participant codes, currency codes).
• Familiarity with relational database design and dimensional modelling principles for reporting/analytics.
• Proficiency with one or more data modelling tools (e.g., ERwin, PowerDesigner, SQL Developer Data Modeler).
• Excellent stakeholder engagement and facilitation skills.

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.

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. Manager, AI & Data, Financial Services, Data Architecture + Data Modelling + London Market Commercial & Specialty Insurance, 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.

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.