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

EY; City Of London; On-site; GBP 75,000 - 95,000; Full time

Job summary

A global professional services firm in London is seeking a Manager for their AI & Data team, focusing on data architecture within the Commercial and Specialty Insurance sectors. The role requires proven data modelling experience, strong analytical skills, and the ability to engage with various stakeholders. This position offers competitive remuneration, flexible working, and opportunities for continuous learning and career development.

Benefits

Competitive remuneration package

Support for flexible working

Career development opportunities

Inclusive and diverse culture

Qualifications

• Proven experience in data modelling within the London Market Commercial and Specialty Insurance.
• Understanding of Lloyd's market operations and Core Data Record specifications.
• Excellent communication skills, both verbal and in writing.

Responsibilities

• Lead on data architecture and data modelling in complex Data Transformation programs.
• Interpret Lloyd's CDR specifications to design supportive data structures.
• Collaborate with business SMEs to capture requirements and validate models.

Skills

Data modelling

Problem-solving

Stakeholder engagement

Tools

ERwin

PowerDesigner

SQL Developer Data Modeler

Job description

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

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

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.