Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a small team to maintain and optimise data models for our Enterprise Data Platform.
- Company: Royal London is the UK's largest mutual life, pensions, and investment company.
- Benefits: Enjoy 28 days annual leave, up to 14% pension matching, and private medical insurance.
- Why this job: Be part of a collaborative culture that values diversity and empowers employees.
- Qualifications: Expertise in data modelling, cloud services, and strong communication skills required.
- Other info: Hybrid working model with opportunities for professional growth and development.
The predicted salary is between 43200 - 72000 £ per year.
Press Tab to Move to Skip to Content Link
Select how often (in days) to receive an alert:
Date: 6 Aug 2025
Company: Royal London Group
Contract Type: Permanent
Location: Edinburgh or Glasgow or Alderley Edge
Working style: Hybrid 50% home/office based
Royal London is seeking a Senior Data Modeller to join the Core Data Engineering function. This role is key to the development of the Royal London Enterprise Data Platform (EDP), a data Lakehouse built using tools such as Azure Databricks, MS Fabric and Snowflake.
The platform supports digital use cases, effective decision-making through feature-engineered data products, self-service analytics and downstream data feeds.
This role will be part of a small team responsible for the ongoing maintenance, optimization and extension of the data models which will drive the EDP design and development.
About the Role
- Maintaining data models at conceptual, logical and physical level.
- Understanding and clarifying business requirements and working with Business Analysts and Data Engineers to design and implement changes to data structures.
- Working as part of the Data Modelling team to help establish and improve our modelling processes and standards to be adopted at an enterprise level.
- Data Mapping: Documenting the mapping and transformation logic to get source system data into our conformed layer and from there into denormalised structures in the curated layer as required
- Strategic Alignment: Ensures data modelling aligns with the Enterprise Data strategy, Business strategy, and Technology strategy.
- Coherence and Flexibility: Maintains a coherent data model that aligns with the operating model, change budgets, and Total Cost of Ownership (TCO), while being extensible and flexible for future opportunities.
- Collaboration: Works closely with the Principal Data Engineer and Data Architects to ensure alignment with the end-to-end data domain architecture, integrating with existing architecture design authorities and boards.
- Advocacy: Collaborates with Product Owners to promote the EDP as a tool to democratise data and enhance return on insight within Royal London.
About You
- Data Modelling Expertise: Possesses excellent skills in data modelling and enterprise-wide data architecture, with strong knowledge of all levels of data modelling and complex source-to-target mappings for various interfaces (batch, near real-time, streaming/event-based).
- Proven Experience: Demonstrates a proven track record in data modelling for complex projects, with strong experience in data warehousing concepts (Kimball, Inmon, star schemas, OLAP, Data Vault, data lakes/lakehouses/warehouses).
- Technical Proficiency: Skilled in using data modelling tools (preferably Idera ER/Studio Data Architect) and knowledgeable about cloud data and analytics services (e.g., Azure Data Factory, Databricks, Snowflake). Proficient in ETL concepts, including data cleansing, change data capture (CDC), integration, mapping, extraction, transformation, and loading.
- Communication and Collaboration: Excellent at communicating and documenting technical information, with extensive experience in agile practices and implementation. Works closely with third-party authorities and suppliers/partners and has a good understanding of regulations and legislation within the financial services market.
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.
OurPeople 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 anInclusive 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.
#J-18808-Ljbffr
Senior Data Modeller employer: Royal London
Contact Detail:
Royal London Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Modeller
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Azure Databricks and Snowflake. Having hands-on experience or relevant projects to discuss can really set you apart during interviews.
✨Tip Number 2
Understand the principles of data modelling and be prepared to discuss your experience with different methodologies like Kimball and Inmon. Being able to articulate how you've applied these concepts in past projects will demonstrate your expertise.
✨Tip Number 3
Network with current employees or professionals in similar roles within the financial services sector. This can provide insights into the company culture and expectations, which can be invaluable during your interview.
✨Tip Number 4
Prepare to showcase your collaboration skills, especially in agile environments. Think of examples where you've worked closely with cross-functional teams, as this aligns with the role's emphasis on teamwork and communication.
We think you need these skills to ace Senior Data Modeller
Some tips for your application 🫡
Understand the Role: Before applying, make sure to thoroughly read the job description for the Senior Data Modeller position. Understand the key responsibilities and required skills, such as data modelling expertise and technical proficiency in tools like Azure Databricks and Snowflake.
Tailor Your CV: Customise your CV to highlight relevant experience in data modelling and enterprise architecture. Emphasise your proven track record in complex projects and your familiarity with data warehousing concepts. Use specific examples that align with the requirements outlined by Royal London.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data modelling and your understanding of the role's impact on the Enterprise Data Platform. Mention how your skills can contribute to the strategic alignment and coherence of data models at Royal London.
Highlight Collaboration Skills: Since the role involves working closely with various teams, emphasise your communication and collaboration skills in both your CV and cover letter. Provide examples of how you've successfully worked with cross-functional teams in previous roles.
How to prepare for a job interview at Royal London
✨Showcase Your Data Modelling Expertise
Be prepared to discuss your experience with data modelling in detail. Highlight specific projects where you've successfully implemented complex data models and how they contributed to the overall success of the project.
✨Understand the Tools and Technologies
Familiarise yourself with the tools mentioned in the job description, such as Azure Databricks, MS Fabric, and Snowflake. Be ready to explain how you've used these tools in past roles and how they can be applied to the role at Royal London.
✨Demonstrate Collaboration Skills
Since the role involves working closely with various teams, prepare examples that showcase your ability to collaborate effectively. Discuss how you’ve worked with Business Analysts, Data Engineers, and Product Owners to achieve common goals.
✨Align with Company Values
Research Royal London's values and culture. During the interview, express how your personal values align with theirs, particularly around inclusivity, collaboration, and achieving results. This will show that you're not just a technical fit but also a cultural one.
