Senior Data Modeller

Apply now »

Date: 04-Mar-2023

Location: Edinburgh, GB Macclesfield, GB Glasgow, GB

Company: Royal London Group

Job Title: Senior Data Modeller

Contract Type: Permanent

Location: Edinburgh, Glasgow or Alderley Edge

Closing date: 3rd April 2023


At Royal London we believe your difference is our strength and our organisation benefits from the different perspectives that diversity brings. Studies have shown that people from under-represented groups are less likely to apply unless they meet every requirement. So, if you’re excited about this role but your past experience isn't a perfect fit with the job description, we encourage you to apply anyway as you may be the right candidate for this or other opportunities.


About the role


We are looking for a Senior Data Modeller to join the Group Data Office and within this role you will report to the Enterprise Data Modelling Manager and your goal will be to design, map, model and document a critical mass of highly valuable and consumable customer, product, and proposition data in the Enterprise Data Model (EDM). The EDM is a valuable Royal London asset and you will manage and maintain the logical data model, as well as exploring new Data domains to model, such as Finance and Risk data.


This is an opportunity to join a newly formed team full of individuals passionate and motivated to deliver change.

We are investing significantly in data capabilities and this will result in further growth and development opportunities.  


Key responsibilities


  • Continue the extension and expansion of the Royal London Enterprise Data Model
  • Model new data domains and data attributes in the existing data model
  • Work on the conceptual and logical modelling to map critical data elements in source systems into the Royal London data model
  • Review modifications of existing systems for cross-compatibility to the EDM and implement data strategies for developing physical data models
  • Work as part of an agile delivery team




  • Excellent data modelling and enterprise-wide data architecture understanding and skills
  • knowledge of domain based data modelling
  • Strong experience of Cloud & Data Warehousing concepts (such as Kimball, Lakehouse, data fabric, data mesh)
  • Experience in Reference Data Management modelling
  • Knowledge of modelling data for Cloud Data & Analytics services to consume
  • Strong data Normalisation skills
  • An ability to present technical concepts to stakeholders of various levels


What we offer


We've always been proud to reward our employees by offering a number of great benefits including:

  • A generous group pension scheme (up to 14% matching employer contribution)
  • 28 days annual leave plus bank holidays with the option to buy/sell up to 5 days
  • Annual company and performance based bonus
  • Life assurance (up to 8 x annual salary)
  • Enhanced parental leave policies
  • Private medical insurance
  • Employee Assistance Programme - Access 24/7 to confidential health, legal & financial advice


Full details can be found on our benefits page


About Royal London


Royal London is the largest mutual life insurance, pensions and investment company in the UK.  Since its foundation 160 years ago, Royal London has supported millions of people to protect and provide for themselves and their families.


At Royal London, our People Promise is that we will all work somewhere inclusive, responsible, enjoyable and fulfilling. This promise has been at the heart of our approach to hybrid working, ensuing a balance of time working in our offices, supporting the culture of collaboration and inclusion and some working time from home, so we can all continue to benefit from the flexibility this brings. Our hybrid working approach is built around our mutual mindset, thinking about what is good for us as individuals (the ‘me’) and in the context of what is right for our customers, our colleagues and The Royal London group (the ‘we’). Together we belong- collaborate – learn and perform.


Our expectation is that colleagues working in hybrid roles will come into the office for 50% of their time, and the rest from home. We want to be as consistent as we can with our approach but we also appreciate some colleagues need adjustments based on personal circumstances. (e.g. to support a disability, or caring responsibility) and / or may wish to formally seek a flexible working pattern in line with our flexible working policy.


We appreciate the world of work continues to evolve and we will continue to listen to our colleagues views on this whilst ensuring our on-going approach is right for our business and customers


We are an equal opportunities employer. We work hard to attract the best talent for our award-winning team. We believe that embracing difference makes us stronger. Our diverse people bring us different skills – whatever their educational background, disability, gender, age, sexual orientation, race, religion or belief.


Our Alderley Park office is situated in 400 acres of natural parkland, based 2.2 miles south of Alderley Edge and 6.5 miles from Macclesfield in our newly refurbished site. We offer a free shuttle service to and from the office from Wilmslow train station and offer free on-site parking with electric car charging points.

Job Segment: Bank, Banking, Finance