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

Ernst & Young Advisory Services Sdn Bhd; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A global consulting firm in London is seeking a Manager for AI & Data in the Financial Services sector. This role involves leading data architecture and modelling for Commercial and Specialty Insurance, collaborating with clients to enhance data-driven solutions. Ideal candidates should have experience in the London Market and proficiency in data modelling tools. The position offers competitive remuneration and opportunities for career development.

Benefits

Competitive remuneration package

Flexible working options

Career development support

Diverse and inclusive culture

Qualifications

• Proven experience in data modelling within London Market Commercial and Specialty Insurance markets.
• Expertise in building conceptual, logical, and physical data models for core insurance entities.
• Good understanding of Data Warehousing design concepts.

Responsibilities

• Lead Data Modelling Activities and develop data models for insurance domains.
• Collaborate with business SMEs to capture requirements and validate models.
• Define master data structures to ensure accuracy and compliance.

Skills

Data Modelling

AI solution design

Stakeholder engagement

Problem-solving

Data Transformation

Tools

ERwin

PowerDesigner

SQL Data Modeler

Job description

Location: London

Other locations: Primary Location Only

Requisition ID: 1655309

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

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.

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.

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

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

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

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.

Tech

EY | Building a better working world