Senior Data Modeller
Role details
Job location
Tech stack
Job description
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:
style="margin-bottom:0.0cm;margin-top:0.0px"- -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.
Requirements
style="margin-bottom:0.0cm;margin-top:0.0px"- -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
Benefits & conditions
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.
