Senior Data Modeller

Job Title: Senior Data Modeller

Contract Type: Permanent

Location: Alderley or Edinburgh or Glasgow

Working style: Hybrid 50% home/office based

Closing date: 21st November 2024

The Group Data Office (GDO) at Royal London enhances data use across the organization, covering Data Governance, Management, Strategy, Analytics/AI, and Insight. We set and oversee data policies and standards to align with the Group’s risk appetite.

Royal London seeks an experienced Data Modeller to join our team, focusing on data structure design for our Azure Databricks Data Lakehouse. You’ll work on the Enterprise Data Platform (EDP) using the Databricks Medallion architecture, contributing to the ‘silver’ and ‘gold’ layers. This role offers a unique opportunity to apply your data modelling skills in a cutting-edge, cloud-based environment.

About the Role

• Senior role in the Data Modelling team, mentoring less experienced members, and overseeing multiple data modelling/design engagements across the EDP.
• Applies extensive data modelling knowledge (conceptual, logical, and physical) and physical warehouse data structure design within an Agile environment.
• Capable of working on multiple projects simultaneously, balancing competing priorities effectively.
• Chairs data model design review sessions, maintains data modelling standards, and ensures compliance.
• Defines data mapping and transformations, collaborates with data engineers, SMEs, and technical BAs, and presents to the Data Design Authority on data modelling/design topics.

About You

• Extensive experience in all levels of data modelling (conceptual, logical, and physical) and various modern data design approaches (relational, dimensional, data-vault, de-normalised big table).
• Skilled in using data modelling tools (Idera ER/Studio, Erwin or similar), expert level SQL skills, ETL\Data pipeline exposure (Azure Data Factory or Qlik).
• Strong track record in data modelling for complex, multi-vendor programs and matrix-led engagements.
• Focused on delivering business value, balancing design purity with practical value delivery.
• Excellent ability to explain complex data modelling and design concepts to both technical teams and senior non-technical stakeholders.

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.