# Senior Data Engineer

> NHS job listing from Job Clerk for The Royal Marsden NHS Foundation Trust.

## Canonical URLs

- **HTML:** https://www.jobclerk.com/job/senior-data-engineer/a04cd65b-3644-4ddc-99e1-73072607325b
- **Markdown:** https://www.jobclerk.com/job/senior-data-engineer/a04cd65b-3644-4ddc-99e1-73072607325b.md

## Summary

- **Status:** Live
- **Employer:** The Royal Marsden NHS Foundation Trust
- **Town:** London
- **Region:** London
- **Country:** England
- **Profession:** Administrative and IT
- **Grade:** Band 8
- **Salary:** £63,665 - £70,887 per annum inc HCAS
- **Contract type:** Permanent
- **Employment type:** Full time - 37.5 hours per week
- **Closing date:** 2026-06-16T23:59:00.000Z
- **Posted:** 2026-06-02T12:31:35.913Z
- **Source information URL:** https://www.healthjobsuk.com/job/UK/London/Sutton/The_Royal_Marsden_NHS_Foundation_Trust/Administration/Administration-v8052219
- **Application URL:** https://apps.trac.jobs/job-advert/8052219?ShowJobAdvert=&feedid=9002
- **Employer website:** https://www.royalmarsden.nhs.uk

## Job Content

### Job overview

The Royal Marsden NHS Foundation Trust is a centre of excellence for research, education, and care in the treatment of Cancer.

The Trust has an outstanding reputation for information and has recently implemented a new digital health record, data warehouse and business intelligence solutions.

The information team currently support management and clinicians throughout the organisation by providing information and analysis for planning, decision making, quality assurance and improvement. We are further developing our analytical tools and capabilities to rapidly increase the utilisation of anonymised clinical data to support research and to maximise the use of clinical data to increase understanding of the disease and treatment outcomes. We are looking for motivated experienced data engineer to join our team, to play a pivotal role supporting the Information Development Manager to shape, develop, and maintain the Trusts new data ecosystem.    You will be educated to degree level and have experience and expertise in developing and maintaining Microsoft based SQL data warehouses and producing technical documentation to support  a wide range of users.

You must be self-motivated and possess excellent interpersonal skills and the ability to establish effective working relationships with all levels of staff within and external to the organisation.

For more information, please contact Des Campbell, Information Development Manager at \[email protected\]

### Main duties of the job

1.1.    To develop, maintain and support the corporate data warehouse and Trusted Research Environment. This will include and is not limited to data engineering tasks, data pipeline development,  and resolving performance issues.

1.2.    To work with our cloud hosting provider to ensure effective resource utilisation and consumption patterns.

1.3.    To develop complex data structures, data models and Extract Transformation and Load processes using Azure Synapse Analytics and related Azure services to support the trust Data warehouse at the direction of the Database Architect and Data Infrastructure Manager.

1.4.    To apply data engineering techniques including data wrangling, cleansing, transformation and integration to ensure high-quality data pipelines and datasets.

1.5.    Develop, implement, and assist in the maintenance of a data asset catalogue to facilitate data discovery.

### Detailed job description and main responsibilities

For further information on this role, please see the attached detailed Job Description and Person Specification

- To work as part of the Information Development team to develop, support, and enhance the corporate data warehouse environment.
- Support the integrity of the data warehouse and contribute to the design and implementation of adequate back-up solutions.
- Contribute to business continuity and disaster recovery planning.
- Maintain an in-depth knowledge of Microsoft Azure Synapse Analytics, and related Azure data services, and provide expert advice regarding their application, act as a point of escalation for investigation and resolution of complex technical issues.
- Lead the development and implementation data pipelines using Synapse Pipelines and other ETL/ELT tools to ingest, transform and load data from various sources.
- Act as the SME for data engineering, providing authoritative input on schema design, data quality, and interoperability.

## Job Details

The Royal Marsden NHS Foundation Trust is a centre of excellence for research, education, and care in the treatment of Cancer.

The Trust has an outstanding reputation for information and has recently implemented a new digital health record, data warehouse and business intelligence solutions.

The information team currently support management and clinicians throughout the organisation by providing information and analysis for planning, decision making, quality assurance and improvement. We are further developing our analytical tools and capabilities to rapidly increase the utilisation of anonymised clinical data to support research and to maximise the use of clinical data to increase understanding of the disease and treatment outcomes. We are looking for motivated experienced data engineer to join our team, to play a pivotal role supporting the Information Development Manager to shape, develop, and maintain the Trusts new data ecosystem. You will be educated to degree level and have experience and expertise in developing and maintaining Microsoft based SQL data warehouses and producing technical documentation to support a wide range of users.

You must be self-motivated and possess excellent interpersonal skills and the ability to establish effective working relationships with all levels of staff within and external to the organisation.

For more information, please contact Des Campbell, Information Development Manager at \[email protected\]

## Job Description

1.1. To develop, maintain and support the corporate data warehouse and Trusted Research Environment. This will include and is not limited to data engineering tasks, data pipeline development, and resolving performance issues.

1.2. To work with our cloud hosting provider to ensure effective resource utilisation and consumption patterns.

1.3. To develop complex data structures, data models and Extract Transformation and Load processes using Azure Synapse Analytics and related Azure services to support the trust Data warehouse at the direction of the Database Architect and Data Infrastructure Manager.

1.4. To apply data engineering techniques including data wrangling, cleansing, transformation and integration to ensure high-quality data pipelines and datasets.

1.5. Develop, implement, and assist in the maintenance of a data asset catalogue to facilitate data discovery.

## Responsibilities

For further information on this role, please see the attached detailed Job Description and Person Specification

To work as part of the Information Development team to develop, support, and enhance the corporate data warehouse environment.

Support the integrity of the data warehouse and contribute to the design and implementation of adequate back-up solutions.

Contribute to business continuity and disaster recovery planning.

Maintain an in-depth knowledge of Microsoft Azure Synapse Analytics, and related Azure data services, and provide expert advice regarding their application, act as a point of escalation for investigation and resolution of complex technical issues.

Lead the development and implementation data pipelines using Synapse Pipelines and other ETL/ELT tools to ingest, transform and load data from various sources.

Act as the SME for data engineering, providing authoritative input on schema design, data quality, and interoperability.

## Person Specification

### Experience

**Essential**

- Significant experience in a database developer role in a multi-professional organisation
- Evidence of having developed complex database systems
- Evidence of having administered Azure data warehouses including but not limited to: SQL Server including SSIS, T-SQL, Data Factory/ Synapse Pipelines, Azure DevOps, including Repos & Test Plans, Azure Data Catalogue, Serverless application development
- Knowledge and understanding of modern data analytics platforms including but not limited to: Python, R, PowerBI, Office 365
- Experience of working within an Agile and Continuous Integration environment

**Desirable**

- Knowledge and experience of working with sensitive information within the NHS
- Knowledge and understanding of Machine Learning data pipelines

### Other Requirements

**Essential**

- Self-motivated: generates ideas and carries them forward, keen to deliver results and take ownership of work
- Self-disciplined: able to work on own initiative, works to high standards
- Team working ability to work and contribute well within a team
- Good communicator: able to communicate clearly and effectively, both verbally and in writing

### Education/Qualifications

**Essential**

- Educated to degree level (or equivalent qualification/experience)

**Desirable**

- Evidence of on-going professional development
- Microsoft certified: Azure Fundamentals, Data Fundamentals, Database Administrator, Designing & implementing DevOps Solutions

### Skills Abilities/knowledge

**Essential**

- A strong commitment to customer service delivery and excellent organisational skills
- Ability to evaluate and respond to rapidly changing operational situations, often under pressure and with changing and sometimes conflicting priorities
- Excellent communication skills especially when dealing with complex technical information and colleagues who have limited IT knowledge and understanding
- Ability to document technical procedures/standards
- An in depth understanding of schema creation for databases & management of permissions

## Documents

- [282-od1518 jdps (pdf, 619.6kb)](https://www.healthjobsuk.com/documents?vdoc=10341731)
- [royal marsden trust values (pdf, 715.5kb)](https://www.healthjobsuk.com/documents?edoc=2360)
- [282-od1518 job features form (pdf, 128.6kb)](https://www.healthjobsuk.com/documents?vdoc=10341730)
- [workplace wellbeing and rewards guide (pdf, 1.2mb)](https://www.healthjobsuk.com/documents?edoc=2580)

## Agent Notes

- This Markdown page is generated from the same Job Clerk job record as the HTML job detail page.
- Use the canonical HTML URL for user-facing references.
- Use the application URL when the user wants to apply on the source NHS site.
