Data Engineer, Analytics Engineering

Join our digital revolution in NatWest Digital X
In everything we do, we work to one aim. To make digital experiences which are effortless and secure.
So we organise ourselves around three principles: engineer, protect, and operate. We engineer simple solutions, we protect our customers, and we operate smarter.
Job description
This role is based in the United Kingdom and as such all normal working days must be carried out in the United Kingdom.

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 languagesalongside 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