Job Description
Job Title: Senior Data Modeller (Data Analytics & Core Engineering)
Contract Type: Permanent
Location: Alderley Park or Glasgow
Working Style: Hybrid - 50% from home / 50% office based
We have an exciting opportunity for a Senior Data Modeller to join our Core Engineering Team within Royal London’s Group Data & AI Office. You’ll help us turn complex data into trusted, well-governed data products that power analytics, reporting and AI across the business.
In this role you’ll analyse and understand data, integrate it with existing data models and data products, and help maintain clear modelling and naming standards. You’ll also support metadata management and create source-to-target mapping documentation using industry-standard tools.
The Royal London Enterprise Data Model (EDM) is a valuable data asset hosted on our cloud-based Enterprise Data Platform, forming the core data in our Databricks Lakehouse medallion architecture. You’ll support the integration of new data and the ongoing maintenance, optimisation and expansion of the EDM and associated data products. The outcome is to build a critical mass of high-value, consumable customer, product and proposition data assets designed to scale for analytics, BI, reporting, data science and AI use cases.
We welcome applicants from all backgrounds and career paths. If you’re excited by the role and can bring many of the skills listed, we’d encourage you to apply - we value potential, learning mindset and transferable experience as well as direct experience.
What you will bring to the role:
- Strong data analysis, mapping and modelling skills, with an understanding of enterprise data architecture.
- Specialist knowledge of domain-based data modelling and complex source-to-target mappings (batch, near real-time and streaming/event-based).
- Experience delivering technical data analysis and modelling for complex programmes, including multi-vendor and matrix-led environments.
- Good knowledge of data integration, engineering and warehousing concepts (e.g., Kimball/Inmon, star schemas, fact/dimension modelling, OLAP, data lakes, ERDs and detailed design specifications).
- Experience using data modelling tools such as ER/Studio, Erwin or Sparx EA.
- Knowledge of cloud data & analytics services on Microsoft Azure (e.g., Azure Data Factory).
- Understanding of ETL concepts including data cleansing, change data capture (CDC), integration, mapping, extraction, transformation and loading.
- Comfortable partnering with third parties and suppliers, building positive working relationships.
- Clear communication of technical information to both technical and non-technical stakeholders.
- Experience working in agile delivery and/or data design environments.
- An understanding of relevant financial services regulation/legislation.
- Ability to balance strategic thinking with attention to technical detail.
- Ability to develop materials and present to senior stakeholders and governance forums.
- Influencing and stakeholder management skills across business and technical teams.
- Leadership skills, professionalism, and an inclusive, collaborative approach.
- Strong organisation skills and the ability to stay calm in pressured or uncertain situations.
- Ability to listen, communicate, constructively challenge and collaborate with peers and senior leaders.
If you feel you’d be a great fit for Royal London but don’t meet every requirement, we’d still love to hear from you. Research shows some candidates are less likely to apply unless they meet 100% of the criteria - if you meet most requirements and are keen to learn, please apply.
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.
Benefits at Royal London: We offer a benefits package designed to support your wellbeing, financial future and life outside work, including:
- 28 days annual leave (plus bank holidays)
- Up to 14% employer matching pension scheme
- Private medical insurance
- Hybrid working (50% from home / 50% office based)
- See the full list here: Our Benefits
Inclusion, diversity and belonging: We’re an inclusive employer, and we welcome applications from everyone. We celebrate and value different backgrounds, experiences and cultures - they help us build better products and make better decisions.
We’re the UK’s largest mutual life, pensions and investment company, offering protection, long-term savings and asset management products and services.
Royal London is a purpose-driven mutual. Our Purpose, ‘Protecting today, investing in tomorrow. Together we are mutually responsible’, defines the impact we want to have. It shapes what we do on behalf of our members and customers, financial advisers, our colleagues and the communities in which we operate. Our People Promise is our collective commitment that our workplace will be inclusive, responsible, enjoyable and fulfilling where all colleagues can thrive and experience a sense of belonging. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve.
Our inclusive values and people promise are core to who we are and how we work. It’s good for our people, and good for our customers too, because with an inclusive workplace and a diverse workforce we will reflect our members, customers and communities to deliver the best outcomes.
We celebrate and value different backgrounds and cultures across our organisation. Our diverse people and perspectives give us a range of skills which are recognised and respected– whatever their background.
Workplace Initiatives
Program for parents returning to work after Parental Leave? |
No |
Leadership development programmes? |
Yes |
Mentoring programmes? |
Yes |
Coaching programmes? |
Yes |
Employee-led diversity networks? |
Yes |
Internal women’s networking groups? |
Yes |
Open to discussing flexible work arrangements at interview stage? |
Yes |
No. of weeks paid maternity leave at full salary: |
26 weeks (followed by 13 weeks half pay) |
Minimum weeks tenure required to be eligible for paid maternity leave: |
Open to all regardless of length of service |
No. of weeks paid paternity leave at full salary: |
4 weeks |
Minimum tenure required to be eligible for paid paternity leave: |
Open to all regardless of length of service |
Gender pay gap reporting information 2022: |
|
Mean pay gap: |
35.3% |
Median pay gap: |
33.9% |
Mean bonus gap: |
70.4% |
Median bonus gap: |
48.5% |
Signatory of the UK Women in Finance Charter? |
Yes |
Targets to raise the number of women in leadership? |
Yes |
Targets to raise the number of BAME individuals in leadership? |
No |
Listed in the Bloomberg Diversity & Inclusion Index? |
No |
Graduate Programmes
We have a number of graduate programmes designed to deliver technical experts and future leaders.
Royal London Career Confidence programme
Our hybrid programme focuses on equipping you to feel empowered in your career and supported to explore new opportunities as they arise.
Apprenticeships
We offer a wide range of Apprenticeships that are targeted at both new joiners and existing colleagues.
Inclusion
We promote an inclusive culture at Royal London and have a range of inclusion networks for our colleagues to get involved with.
Our Women's Network is a community that celebrates and supports its members, helps everyone to learn more and inspires all of us to aim higher. Confidence and development are strong themes here and our events focus on three key areas of team working, finance, and wellbeing. There are two sub-groups to the Women’s Network – Women in Technology and our Periods and Menopause Group – focused on actions such as supporting over 20 new Periods and Menopause champions and launching guidance and training for leaders.