Enterprise Data Modeller

Intact Insurance (previously RSA); United Kingdom; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading commercial insurance provider is seeking an Enterprise Data Modeller to join their Chief Information Office team in the UK. The role involves designing and maintaining the Enterprise Data Model, managing data governance, and collaborating across teams. Ideal candidates have experience in data modelling and strong communication skills. This position offers a hybrid working model and various employee benefits.

Benefits

Annual discretionary bonus

Up to 11% pension contributions

25 days annual leave + bank holidays

Health & wellbeing + virtual GP

Career development and mentoring

Inclusive culture + employee networks

Share investment options

Qualifications

• Proven hands-on experience in designing and integrating conceptual, logical, and physical data models.
• Strong communication and collaboration skills.
• Experience with enterprise application integration methods.

Responsibilities

• Design and maintain the Enterprise Data Model as a strategic asset.
• Manage EDM/CDM versioning, governance and change control processes.
• Facilitate structured workshops to understand enterprise data needs.

Skills

Enterprise Data Modelling Expertise

Stakeholder Engagement

Technical Proficiency

Tools

Erwin

Microsoft Purview

Job description

APPLY NOW!

Intact Insurance is the new name for RSA in the UK, Ireland, and across Europe. It’s a new name and a new way to do business. Backed by global expertise and a commitment to service that feels different, we’re focused on making insurance simpler, faster, and more responsive.

Shape the future

We’re leading a transformation in insurance helping people, businesses and society prosper in good times and be resilient in bad times. When you join us, you’re not just taking a job, you’re stepping into a career where you can make a real difference.

Grow with us

We’re customer‑driven, community‑focused, and committed to helping our people grow. Whether you’re early in your journey or bringing years of experience, we’ll support you with the tools, flexibility, and opportunities to thrive.

Win as a Team

We are currently recruiting for an Enterprise Data Modeller to join our established and experienced Chief Information Office team here at Intact, in one of our UK locations.

You’ll make an impact by

Intact is undergoing a bold transformation to become the UK’s leading commercial lines insurer, and data is at the heart of this ambition. As part of the enterprise data strategy, we are building a connected, managed data architecture that enables smarter decision‑making, operational efficiency and business value.

This role focuses on the Enterprise Data Model and Canonical Data Model as key enablers in our strategic data architecture. These artefacts ensure that our important data is consistently defined, well‑connected and aligned across the value chain, enabling interoperability between systems and maximizing business value.

As Enterprise Data Modeller, you will lead the documentation of enterprise data needs across multiple projects and engage with a wide range of business, data and technology stakeholders. You will also define canonical data formats for seamless data exchange across strategic platforms, ensuring consistency and scalability across the enterprise.

Your Skills And Experience

The responsibilities of the Enterprise Data Modeller include:

Enterprise Data Model (EDM) Development

• Design and maintain the RSA EDM as a strategic asset, including subject areas, glossary and best practices.
• Support enterprise data architects with technical tasks such as reverse engineering and productivity automation as well as with data modelling methodologies (relational, dimensional) and effort management.

Model Change Management Governance & Communication

• Manage EDM/CDM versioning, governance and change control processes to maintain integrity and traceability. Maintain change log on all updates and ensure change approvals are in place.
• Help communicate updates to EDM/CDM structure and guidelines to the solution data teams.

Business And Technical Requirements Analysis

• Facilitate structured workshops with business and IT SMEs to understand and validate enterprise data needs.
• Ensure the EDM and CDM accurately reflect real‑world business processes and data structures.

Data Governance & Compliance

• Maintain metadata, reference data and lineage within the deliverables.
• Integrate with the enterprise data governance platform / data catalogue (Microsoft Purview).

Collaboration across Architecture and Data roles

• Partner with solution data architects and other roles to reflect solution needs in EDM and CDM.
• Support Data Architecture initiatives, e.g. contribute to solution data architecture reviews to ensure alignment, and ensure that the mapping to EDM / CDM has been performed correctly.

We are also looking for the following technical skills:

Stakeholder Engagement

Strong communication and collaboration skills, with the ability to work effectively across functions and seniority levels.

Enterprise Data Modelling Expertise

• Proven hands‑on experience in designing and integrating conceptual, logical, and physical data models, using both relational and dimensional modelling techniques
• Proven experience working on Enterprise Data Models and Canonical Data Models.

Technical Proficiency

• Extensive hands‑on experience with data modelling tools such as Erwin (required)
• Experience with enterprise application integration methods and tooling (required)
• Exposure to data quality and data management tools (beneficial).

Why You’ll Love It Here

Being part of our team means you’ll have the support and freedom to bring your best self to work each day. As a permanent member, here’s what you can look forward to:

• Annual discretionary bonus
• Up to 11% pension contributions
• Hybrid working
• 25 days annual leave + bank holidays + buy/sell options
• Health & wellbeing + virtual GP
• Career development and mentoring
• Inclusive culture + employee networks
• Share investment options

Our DEI Commitment

We celebrate individuality and believe our differences make us stronger. We’re proud to foster a culture where everyone feels respected, valued, and empowered to thrive.

As an Equal Opportunity and Disability Confident Employer, we ensure fair consideration for all applicants and offer interviews to all disabled candidates who meet the essential criteria.

We understand that everyone’s circumstances are different and are happy to explore flexible working options such as reduced hours or job shares to support work–life balance.

If you meet the core criteria but not every requirement, we’d still love to hear from you. Let’s explore how this role could support your next career step. If you need adjustments during the recruitment process, just let us know we’re here to support you.