Senior Data Modeller Technical Data Analyst

Job Title: Senior Data Modeller Technical Data Analyst

Contract Type: Permanent

Location: Alderley Park (Wilmslow) or Glasgow

Working Style: Hybrid - 50% from home / 50% office based

We have an exciting opportunity for a Senior Data Modeller - Technical Data Analyst to join our Core Engineering Team within Royal Londons Group Data & AI Office. Youll help us turn complex data into trusted well-governed data products that power analytics reporting and AI across the business.

In this role youll analyse and understand data integrate it with existing data models and data products and help maintain clear modelling and naming standards. Youll 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. Youll 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 youre excited by the role and can bring many of the skills listed wed 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 youd be a great fit for Royal London but dont meet every requirement wed 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

Were the UKs 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: Were 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.