Data Engineer, Analytics Engineering

NatWest Group; City of Edinburgh; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

NatWest Group is building a brand-new Data Products factory capability for PBWM and seeking a Data Engineer to shape canonical and semantic data layers powering Analytics, AI, reporting, and self-service capabilities.

You will sit at the heart of our data ecosystem, partnering with Business, Technology and Functions to create trusted data assets, governed data products, and scalable data architectures across PBWM.

Qualifications

• Significant experience as Analytics Engineer, BI Engineer, or Data Architect in complex data environments.
• Proven track record of governed data products with ownership, SLAs, docs, and quality control.
• Strong ability to design canonical data models and semantic layers for multiple systems.

Responsibilities

• Develop data driven solutions through data pipelines, modelling and design.
• Collaborate with business stakeholders to translate needs into canonical and semantic data models.
• Build and maintain governed analytical data products, document and ensure discoverability.
• Define data quality checks, SLAs, and governance practices for accurate, reliable data.
• Work with data architects, engineers, BI teams and data scientists to ensure scalable, performant models on our cloud data platform.

Skills

SQL

Data modelling

Data governance

Stakeholder communication

Cloud data platform

Tools

Iceberg on AWS

Job description

Join us as a Data Engineer, Analytics Engineering

• We’rebuildingabrandnewData ProductsfactorycapabilityatthePrivate Banking & Wealth Management(PBWM) franchise andarelookingfor a Data Engineer to shape thecanonicaland semanticdata layers that power ourAnalytics,AI,reporting, andself servicecapabilities
• You’llsit at the heart of our data ecosystem, partnering withBusiness,TechnologyandFunctionsto design clean, reusable dataassetsfrom the ground up, and turning them into trusted, governed data products that the business can rely on every day
• This is ahands onrole withsignificant influenceover 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

Whatyou'lldo

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

You’lldrive customer value by understanding complex business problems and requirements to correctly apply the mostappropriateand reusable tool to gather and build data solutions.

You’llsupport 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’llbuild a strong understanding of ourData Productecosystem and contribute to the design and delivery ofreusable DataProductsthatsupportPBWM business and functions.

Your responsibilities will also include:

• Working with business stakeholders to understand their needs and translate them into intuitivecanonicaland semantic data models
• Designing and evolving standardised,cross domaindata models such asparty, account,deposit, mortgages that align with our enterprise data model
• Building andmaintaininggoverned analytical data products, ensuring they arewell documented, discoverable, and consistently used across teams
• Defining and implementing data quality checks, SLAs, and governance practices so that our data isaccurate, reliable, and compliant
• Collaborating with data architects, engineers, BIteamsand data scientists to ensure models are scalable, performant, and easy to consume on our cloud data platform

The skillsyou'llneed

To thrive in this role,you’llneed a strong understanding of data usage and dependencies and experience of extracting value and features from large scale data.You’llalso bring practicalexperience of programming languagesalongside knowledge of data and software engineering fundamentals.

Additionally,you’llneed:

• Significant experienceasanAnalytics Engineer, BI Engineer, or DataArchitectand worked in complex,data richenvironments
• Proventrack recordof managing governed data products with clear ownership, SLAs, documentation, and quality control
• Strongtrack recorddesigningcanonicaldata models that standardise entities across multiple systems or domainsand semantic layers that present data in a clearly to different audiences or stakeholders
• Excellent SQL and data modelling skillsonmodern formats like iceberg onAWS,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