Senior Data Modeller

Royal London; City of Edinburgh, Glasgow, Macclesfield, Wilmslow; Hybrid; GBP 40,000 - 80,000; Full time

Job summary

An established industry player is on the lookout for skilled data modellers to join their Core Engineering team. This pivotal role involves hands-on data modelling and structure design for a cutting-edge Enterprise Data Platform built on Azure Databricks. Candidates will leverage their extensive data modelling expertise to enhance data governance and management practices. The company values inclusivity and offers a rewarding workplace, complete with generous benefits including 28 days of annual leave and a robust pension scheme. If you're passionate about data and eager to make a significant impact, this opportunity is perfect for you.

Benefits

28 days annual leave

14% employer matching pension scheme

private medical insurance

Qualifications

• Expertise in data modelling at conceptual, logical, and physical levels.
• Experience in data structure design in Agile environments.

Responsibilities

• Design and deliver data modelling engagements across the EDP.
• Define data mapping and transformations from source to target entities.

Skills

Data Modelling

Data Structure Design

Agile Development

Interpersonal Skills

Data Engineering

Python

Tools

Azure Databricks

Azure Data Factory

Idera ER/Studio

PySpark

Job description

Date: 21 Mar 2025

Location: Edinburgh, GB Macclesfield, GB Glasgow, GB

Company: Royal London Group

Contract Type: Permanent

Location: Wilmslow or Edinburgh or Glasgow

Working style: Hybrid 50% home/office based

The Group Data Office (GDO) is responsible for enhancing the effectiveness of how data is used across Royal London (RL). The function provides Data Governance, Data Management, Data Strategy, Analytics/AI and Insight capabilities. It sets and oversees data related policies and standards, so data is collected, processed, and exploited in accordance with the Group’s risk appetite.

Role Overview

Royal London is seeking experienced data modellers with extensive data warehouse design skills to join a newly formed Core Engineering team who play a pivotal part in the data engineering, modelling and data structure design across Royal London’s Enterprise Data Platform (EDP) which is being built on Azure Databricks.

The EDP is a Data Lakehouse built using the Databricks Medalion architecture and consists of a relational core ‘silver’ layer with a variety of dimensional, de-normalised and relational structured data products being exposed for consumption through the ‘Gold’ layer.

This opportunity gives the right candidates a superb opportunity to be involved in the design of a strategic data platform leveraging all the hard-earned data modelling and design skills acquired on other platforms but brought right up to date with the latest cloud based data technologies.

About the Role

• Hands on data modelling and data structure design role with the EDP Core Engineering team. A key member of the team providing design and delivery on a number of data modelling/design engagement across the EDP.
• Applies expert data modelling knowledge at all levels (conceptual, logical and physical), plus physical warehouse/data lakehouse data structure design experience within an Agile development environment.
• Working potentially over multiple projects at any one time, so ability to multi-task and balance competing priorities important.
• Defines the data mapping and transforms from source to target entities in the data model, working closely with data engineers, source system SMEs and technical BAs.

About You

• Data Modelling/Design Expertise: Demonstrable experience and expertise of all levels of data modelling – conceptual, logical and physical and the various data design techniques used in modern data platforms including relational, dimensional, data-vault and de-normalised big table and the correct application of each approach. Must have the skill level required to support agile development teams building out data products using any of these techniques.
• Proven Experience: Demonstrates a proven track record in data modelling for complex, multi-vendor programmes and matrix-led engagements.
• Pragmatic approach: always focused on delivering business value and balancing the trade-offs between design purity and value delivery.
• Excellent interpersonal skills: ability to clearly explain complex data modelling and data design concepts to others in the technical team and those in senior less technical roles.
• Ability to work closely with third-party authorities and MSA suppliers/partners and has a good understanding of regulations and legislation within the financial services market.
• Technical Proficiency: Skilled in building and maintaining data models using data modelling tools (Idera ER/Studio or similar).
• Data engineering/data pipeline experience, with hands on experience on integration tools such as Azure Databricks Notebooks, Azure Data Factory or PySpark. Python extremely beneficial.

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.

We've always been proud to reward employees by offering great workplace benefits such as 28 days annual leave in addition to bank holidays, an up to 14% employer matching pension scheme and private medical insurance. You can see all our benefits here - Our Benefits

Inclusion, diversity and belonging.

We’re an Inclusive employer. We celebrate and value different backgrounds and cultures across Royal London. Our diverse people and perspectives give us a range of skills which are recognised and respected – whatever their background.