Senior Data Modeller

JobsCloseBy Editorial Insights

Royal London seeks a Senior Data Modeller to join the Data & AI Office in a hybrid role in Edinburgh, Glasgow or Alderley Park. You will maintain and extend the EDM on a Databricks Lakehouse, delivering scalable, governed data assets for use cases. Includes deep data architecture, domain modelling, and complex source-to-target mappings for batch, real time and streaming, with Kimball, Inmon, Data Vault and lakehouse approaches. Proficiency with ER/Studio, Erwin or Sparx EA, Azure Data Factory, CDC and ETL is important. Bring clear communication and agile delivery in multi-vendor programmes, plus knowledge of financial services regulations. If you don’t meet every requirement, apply and tailor your CV to highlight cloud and EDM impact.

Job Title: Senior Data Modeller

Contract Type: Permanent

Location: Edinburgh or Glasgow or Alderley Park

Working Style: Hybrid 50% home/office based

Closing Date: 6th February 2026

We have a fantastic opportunity for a Senior Data Modeller to join our Group Data & AI Office (GDAO) Team at Royal London. The role leverages the capabilities of the GDAO to enable the business to deliver its data driven outcomes, through the design, analysis and delivery of high quality, well governed enterprise data assets (on Cloud), that drives digital use cases, effective decision making through feature engineered data products, and self-service analytics.

The Royal London Enterprise Data Model (EDM) is a valuable digital asset that exists as a conceptual, logical and physical canonical model on the cloud hosted Enterprise Data Platform. Forming the core data in our Databricks hosted Lakehouse medallion architecture. This role will support the ongoing maintenance, optimisation, expansion (vertical & horizontal) and execution of the roadmap for the EDM, including all sub-domains. The ultimate outcome is to build a critical mass of highly valuable and consumable customer, product and proposition data assets in the model. This role would require a specialism in Data modelling methodologies and/or data Lakehouse design approaches, to ensure we produce scalable modelled data for our analytical stakeholders and digital use cases.

About you:

• Excellent data modelling and enterprise-wide data architecture understanding and skills
• Strong and demonstrable specialist knowledge of domain based data modelling with complex source to target mappings to support batch, near real-time and streaming/event based architectures.
• Proven track record of working on Data Modelling engagements for complex, multi-vendor programmes and matrix led engagements.
• Strong experience of Data Warehousing concepts, such as; Kimball, Inmon, data vault, star schemas, fact/dimensions, OLAP, lakehouse architecture, detailed design specifications, entity-relationship diagrams.
• Data Modelling tools (ER/Studio, Erwin, Sparx EA)
• Knowledge of Cloud Data & Analytics services on Microsoft Azure, such as Azure Data Factory (ADF).
• ETL concepts: data cleansing, change data capture (CDC), integration, mapping, extraction, transformation and loading.
• Experience of close working with third party authorities and MSA suppliers & partners
• Excellent and proven communication of technical information
• Full and extensive experience of agile practice an implementation both in delivery and data design arenas
• Good understanding of regulations/legislation within the financial services market

If you think you would be a great fit for our team at Royal London but don’t meet all the requirements of the role, please get in touch as your application will still be considered.

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.