Data Engineer, Analytics Engineering

Royal Bank of Scotland; Greater London, City of Edinburgh; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Hybrid work model

London or Edinburgh office twice a‑wk

Job summary

Royal Bank of Scotland is hiring a Data Engineer for Analytics Engineering to shape canonical and semantic data layers powering analytics, AI, and reporting for PBWM. You will build trusted data products and govern data assets across the organization.

The role is hands-on with substantial influence on data structure, governance, and consumption. Hybrid work is available with office days in London or Edinburgh.

Qualifications

• Significant experience in analytics engineering or data architecture roles.
• Proven ability to design canonical and semantic data models with governance.
• Strong SQL and data modelling skills for large cloud datasets.

Responsibilities

• Develop data pipelines, data models, and semantic layers.
• Build and govern analytical data products with clear ownership and SLAs.
• Collaborate with architects, engineers, BI teams, and data scientists.
• Define data quality checks, governance practices, and compliance.
• Deliver reusable data products for PBWM across functions.

Skills

Analytics Engineer

BI Engineer

Data Architect

SQL

Data modelling

Data governance

Cloud data platform

Transformation-as-code

Version control

Stakeholder communication

Tools

Iceberg on AWS

SQL tooling

Data pipelines

Job description

Join us as a Data Engineer, Analytics Engineering

We're building a brand new Data Products factory capability at the Private Banking & Wealth Management (PBWM) franchise and are looking for a Data Engineer to shape the canonical and semantic data layers that power our Analytics, AI, reporting, and self service capabilities

You'll sit at the heart of our data ecosystem, partnering with Business, Technology and Functions to design clean, reusable data assets from the ground up, and turning them into trusted, governed data products that the business can rely on every day

This is a hands on role with significant influence over how data is structured, governed, and consumed across PBWM

You'll work from home some of the time, but you'll also spend at least twice a week working from our London or Edinburgh office

What you'll do

As a Data Engineer, you'll be looking to simplify our organisation by developing innovative data driven solutions through data pipelines, modelling and design, inspiring to be commercially successful while keeping our customers, and the bank's data, safe and secure.

You'll drive customer value by understanding complex business problems and requirements to correctly apply the most appropriate and reusable tool to gather and build data solutions.

You'll support our strategic direction by engaging with the data engineering community to deliver opportunities, along with carrying out complex data engineering tasks to build a scalable data architecture. In addition, you'll build a strong understanding of our Data Product ecosystem and contribute to the design and delivery of reusable Data Products that support PBWM business and functions.

Your responsibilities will also include:

• Working with business stakeholders to understand their needs and translate them into intuitive canonical and semantic data models
• Designing and evolving standardised, cross domain data models such as party, account, deposit, mortgages that align with our enterprise data model
• Building and maintaining governed analytical data products, ensuring they are well documented, discoverable, and consistently used across teams
• Defining and implementing data quality checks, SLAs, and governance practices so that our data is accurate, reliable, and compliant
• Collaborating with data architects, engineers, BI teams and data scientists to ensure models are scalable, performant, and easy to consume on our cloud data platform

The skills you'll need

To thrive in this role, you'll need a strong understanding of data usage and dependencies and experience of extracting value and features from large scale data. You'll also bring practical experience of programming languages alongside knowledge of data and software engineering fundamentals.

Additionally, you'll need:

• Significant experience as an Analytics Engineer, BI Engineer, or Data Architect and worked in complex, data rich environments
• Proven track record of managing governed data products with clear ownership, SLAs, documentation, and quality control
• Strong track record designing canonical data models that standardise entities across multiple systems or domains and semantic layers that present data in a clearly to different audiences or stakeholders
• Excellent SQL and data modelling skills on modern formats like iceberg on AWS, with confidence working on large and complex datasets in the cloud
• Hands on experience with modern analytics in engineering practices such as, transformation-as-code, testing, version control and automated deployment
• Ability to communicate complex data concepts in simple terms and lead workshops with nontechnical stakeholders

Hours

35

Job Posting Closing Date:

20/10/2026

Ways of Working:Hybrid