Senior Data Modeller

Royal London; Alderley Edge; Hybrid; GBP 70,000 - 95,000; Full time

Benefits offered by this job

28 days annual leave

Pension scheme (up to 14% matched)

Private medical insurance

Hybrid working (50% from home / 50% in

Job summary

Royal London is seeking a Senior Data Modeller to join the Core Engineering Team within the Group Data & AI Office. You will analyse data, map it to the EDM, and help maintain clear modelling standards for data products powering analytics, reporting and AI across the business.

The role requires strong data modelling expertise, cloud data services on Microsoft Azure, and experience with data warehousing concepts. The role offers hybrid working with 50% from home and 50% in the office.

Qualifications

• Strong data modelling, mapping and modelling skills for enterprise data platforms.
• Experience delivering data analysis and modelling for complex programmes.
• Knowledge of Kimball/Inmon, star schemas, OLAP and data lakes.
• Comfortable working with third parties and governance forums.
• Understanding of data integration and ETL concepts.

Responsibilities

• Analyse data and integrate with existing data models and data products.
• Maintain clear modelling standards and naming conventions.
• Support metadata management and source-to-target documentation.
• Support EDM maintenance and expansion for analytics and AI use cases.

Skills

Data modelling

Source-to-target mappings

Enterprise data architecture

Batch and streaming data

Dimensional modelling

Tooling: ER/Studio

Tooling: Erwin

Tooling: Sparx EA

Cloud data services (Azure)

Data warehousing concepts

Agile delivery

Stakeholder communication

Tools

ER/Studio

Erwin

Sparx EA

Azure Data Factory

Databricks

Job description

Location: Alderley Park or Glasgow

Working Style: Hybrid - 50% from home / 50% office based

We have an exciting opportunity for a Senior Data Modeller to join our Core Engineering Team within Royal London’s Group Data & AI Office. You’ll help us turn complex data into trusted, well-governed data products that power analytics, reporting and AI across the business.

Job Title: Senior Data Modeller

Contract Type: Permanent

In this role you’ll analyse and understand data, integrate it with existing data models and data products, and help maintain clear modelling and naming standards. You’ll also support metadata management and create source-to-target mapping documentation using industry-standard tools. The Royal London Enterprise Data Model (EDM) is a valuable data asset hosted on our cloud‑based Enterprise Data Platform, forming the core data in our Databricks Lakehouse medallion architecture. You’ll support the integration of new data and the ongoing maintenance, optimisation and expansion of the EDM and associated data products. The outcome is to build a critical mass of high-value, consumable customer, product and proposition data assets designed to scale for analytics, BI, reporting, data science and AI use cases.

What you will bring to the role:

• Strong data analysis, mapping and modelling skills, with an understanding of enterprise data architecture.
• Specialist knowledge of domain-based data modelling and complex source‑to‑target mappings (batch, near real‑time and streaming/event‑based).
• Experience delivering technical data analysis and modelling for complex programmes, including multi‑vendor and matrix‑led environments.
• Good knowledge of data integration, engineering and warehousing concepts (e.g., Kimball/Inmon, star schemas, fact/dimension modelling, OLAP, data lakes, ERDs and detailed design specifications).
• Experience using data modelling tools such as ER/Studio, Erwin or Sparx EA.
• Knowledge of cloud data & analytics services on Microsoft Azure (e.g., Azure Data Factory).
• Understanding of ETL concepts including data cleansing, change data capture (CDC), integration, mapping, extraction, transformation and loading.
• Comfortable partnering with third parties and suppliers, building positive working relationships.
• Clear communication of technical information to both technical and non‑technical stakeholders.
• Experience working in agile delivery and/or data design environments.
• An understanding of relevant financial services regulation/legislation.
• Ability to balance strategic thinking with attention to technical detail.
• Ability to develop materials and present to senior stakeholders and governance forums.
• Influencing and stakeholder management skills across business and technical teams.
• Leadership skills, professionalism, and an inclusive, collaborative approach.
• Strong organisation skills and the ability to stay calm in pressured or uncertain situations.
• Ability to listen, communicate, constructively challenge and collaborate with peers and senior leaders.

About Royal London

We’re the UK’s largest mutual life, pensions and investment company, offering protection, long‑term savings and asset management products and services.

Our People Promise to our colleagues is that we will all work somewhere inclusive, responsible, enjoyable and fulfilling. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve.

Benefits at Royal London:

• 28 days annual leave (plus bank holidays)
• Up to 14% employer matching pension scheme
• Private medical insurance
• Hybrid working (50% from home / 50% office based)
• See the full list here: Our Benefits

Inclusion, diversity and belonging: We’re an inclusive employer, and we welcome applications from everyone. We celebrate and value different backgrounds, experiences and cultures - they help us build better products and make better decisions.