Senior Data Modeller

Royal London Group; City of Edinburgh; Hybrid; GBP 50,000 - 80,000; Full time

Job summary

A leading company in the UK is seeking a Senior Data Modeller to join their Core Data Engineering function. This role is crucial for developing the Enterprise Data Platform, focusing on maintaining and optimizing data models while collaborating with various teams to ensure alignment with business strategies. The ideal candidate will have extensive experience in data modelling, ETL concepts, and data warehousing, with a strong understanding of Azure services.

Benefits

28 days annual leave plus bank holidays

Up to 14% employer matching pension scheme

Private medical insurance

Qualifications

• Proven experience in data modelling for complex projects.
• Familiar with data warehousing concepts like Kimball and OLAP.
• Skilled in data mapping and transformation logic.

Responsibilities

• Maintain data models at conceptual, logical, and physical levels.
• Collaborate with Business Analysts and Data Engineers.
• Document mapping and transformation logic for data.

Skills

Data Modelling

ETL Concepts

Communication

Agile Practices

Education

Expertise in data modelling and enterprise data architecture

Tools

Idera ER/Studio Data Architect

Azure Data Factory

Databricks

Job description

Job Title: Senior Data Modeller

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 Azure Databricks.

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

1. Data Modelling:

• Maintaining data models at conceptual, logical, and physical levels.
• Understanding and clarifying business requirements and working with Business Analysts and Data Engineers to design and implement changes to data structures.
• Helping establish and improve modelling processes and standards within the Data Modelling team.
• Data Mapping: Documenting the mapping and transformation logic for source system data into conformed and denormalised structures.
• Strategic Alignment: Ensuring data modelling aligns with enterprise, business, and technology strategies.
• Coherence and Flexibility: Maintaining a coherent, extensible data model that aligns with operating models, change budgets, and TCO.
• Collaboration: Working closely with Principal Data Engineer and Data Architects to ensure alignment with data architecture.
• Advocacy: Collaborating with Product Owners to promote the EDP as a democratizing tool for data insight.

About You

• Expertise in data modelling and enterprise data architecture, with knowledge of different modelling levels and complex source-to-target mappings.
• Proven experience in data modelling for complex projects, familiar with data warehousing concepts (Kimball, Inmon, star schemas, OLAP, data lakes).
• Skilled in data modelling tools (preferably Idera ER/Studio Data Architect) and knowledgeable about Azure cloud data services (Azure Data Factory, Databricks).
• Proficient in ETL concepts, including data cleansing, CDC, integration, mapping, extraction, transformation, and loading.
• Excellent communication and documentation skills, with experience in agile practices, and understanding of financial services regulations.

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, underpinned by our Spirit of Royal London values: Empowered, Trustworthy, Collaborate, Achieve.

We offer great benefits such as 28 days annual leave plus bank holidays, up to 14% employer matching pension scheme, and private medical insurance.

Inclusion and Diversity

We’re an inclusive employer, valuing different backgrounds and cultures. Our diverse perspectives enhance our skills and are recognized and respected.