Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our Core Engineering team to design and deliver 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 strategic data platform using cutting-edge cloud technologies in an inclusive environment.
- Qualifications: Expertise in data modelling, SQL, and experience with Azure Databricks or similar tools required.
- Other info: Hybrid working model with a focus on collaboration and innovation.
The predicted salary is between 43200 - 72000 £ per year.
This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.
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.
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 engagements 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.
- 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.
- 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.
- Technical Proficiency: Skilled in building and maintaining data models using data modelling tools (Idera ER/Studio or similar). Expert level SQL skills required. 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.
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.
Senior Data Modeller employer: Royal London Mutual Insurance Society
Contact Detail:
Royal London Mutual Insurance Society Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Modeller
✨Tip Number 1
Familiarise yourself with the latest cloud-based data technologies, especially Azure Databricks. Understanding how the Databricks Medalion architecture works will give you a significant edge in discussions during interviews.
✨Tip Number 2
Brush up on your SQL skills and ensure you're comfortable with data modelling tools like Idera ER/Studio. Being able to demonstrate your technical proficiency in these areas can set you apart from other candidates.
✨Tip Number 3
Prepare to discuss your experience with complex, multi-vendor programmes. Be ready to share specific examples of how you've balanced design purity with business value in previous roles.
✨Tip Number 4
Highlight your interpersonal skills by preparing to explain complex data concepts in simple terms. This will show your ability to communicate effectively with both technical and non-technical team members.
We think you need these skills to ace Senior Data Modeller
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and requirements of the Senior Data Modeller position. Familiarise yourself with data modelling techniques and the technologies mentioned in the job description, such as Azure Databricks and SQL.
Tailor Your CV: Customise your CV to highlight relevant experience in data modelling and design. Emphasise your expertise in conceptual, logical, and physical data modelling, as well as any experience with Agile development environments and data engineering tools.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for data modelling and your understanding of Royal London's mission. Mention specific projects or experiences that demonstrate your ability to deliver business value through effective data design.
Highlight Interpersonal Skills: In your application, emphasise your excellent interpersonal skills. Provide examples of how you've effectively communicated complex data concepts to both technical and non-technical stakeholders, as this is crucial for the role.
How to prepare for a job interview at Royal London Mutual Insurance Society
✨Showcase Your Data Modelling Expertise
Be prepared to discuss your experience with various data modelling techniques, such as conceptual, logical, and physical models. Highlight specific projects where you've successfully applied these skills, especially in complex environments.
✨Demonstrate Technical Proficiency
Familiarise yourself with the tools mentioned in the job description, like Idera ER/Studio, Azure Databricks, and SQL. Be ready to answer technical questions or even solve problems on the spot to showcase your hands-on experience.
✨Communicate Clearly
Practice explaining complex data concepts in simple terms. This role requires excellent interpersonal skills, so be prepared to demonstrate how you can communicate effectively with both technical and non-technical stakeholders.
✨Emphasise Your Agile Experience
Since the role involves working in an Agile environment, share examples of how you've successfully contributed to Agile teams. Discuss your ability to multi-task and manage competing priorities while delivering business value.
