Data Analyst

NatWest Group; City of Edinburgh; Hybrid; GBP 40,000 - 55,000; Full time

Job summary

A leading banking institution in Edinburgh is seeking a Data Analyst to join their innovative team. You will manage complex data analysis, develop solutions, and improve data quality. Ideal candidates should have experience with SQL, Python, and knowledge of banking products. The role involves hybrid working and offers opportunities for professional growth.

Qualifications

• Experience in data analysis in a technology or IT function.
• Understanding of data interrelationships across multiple domains.
• Knowledge in Banking and Finance domain.

Responsibilities

• Perform data extraction, storage, manipulation, processing, and analysis.
• Identify and document data migration paths and processes.
• Build and maintain partnerships with business stakeholders.

Skills

Data analysis tools

SQL-based database systems like Oracle, Snowflake

Python

AWS cloud services (S3, Athena)

Excellent communication skills

Problem-solving skills

Job description

Join us as a Data Analyst

Take on a new challenge in a cutting-edge data team, in which you’ll manage the analysis of complex bank, franchise, or function data to identify business issues and opportunities. We’ll look to you to provide high-quality analytical input to help develop and implement innovative processes and resolve problems across the bank. This is a hands-on role in which you'll hone your data analysis expertise and gain valuable experience in a dynamic area of our business.

What you'll do

As a Data Analyst, you'll play a key role in supporting the delivery of high-quality business solutions. You’ll be performing data extraction, storage, manipulation, processing, and analysis, alongside developing and performing standard queries to ensure data quality and identify data inconsistencies and missing data.

Day-to-day, you’ll also be:

• Collecting, profiling, and mapping appropriate data to use in new or existing solutions as well as for ongoing data activities
• Identifying and documenting data migration paths and processes, standardizing data naming, data definitions, and modeling
• Interpreting customer needs and turning them into functional or data requirements and process models
• Building and maintaining collaborative partnerships with key business stakeholders

The skills you'll need

We’re looking for someone with experience of using data analysis tools and delivering data analysis in a technology or IT function.

We’ll also look for:

• An in-depth understanding of the interrelationships of data and multiple data domains
• A background in delivering research based on qualitative and quantitative data across a range of subjects
• Excellent communication, interpersonal, documentation, and presentation skills
• Excellent hands-on experience on SQL-based database systems like Oracle, Snowflake
• Excellent knowledge in the Banking and Finance domain, specifically various banking products and payment standards like ISO20022 and payment journeys
• Strong problem-solving, analytics, and reasoning skills
• Experience using Python and various AWS cloud services such as S3, Athena, and various file formats like parquet to query/pull/profile the data from heterogeneous sources

Hours: 35

Job Posting Closing Date: 10/10/2025

Ways of Working: Hybrid