Senior Data Engineer and Technical Lead

The Clatterbridge Cancer Centre; Bebington; Hybrid; GBP 49,000 - 57,000; Full time

Job summary

The Clatterbridge Cancer Centre NHS Foundation Trust in Wirral seeks a Senior Data Engineer and Technical Lead to steer the development and operation of the data warehouse, BI and dashboards. You will lead a small team across BI, RPA and SharePoint, delivering robust analytics to clinical, operational and corporate needs.

This fixed-term 24-month role offers hands-on data engineering leadership, strategic design of ETL processes, and close collaboration with analysts, clinicians and suppliers to

Qualifications

• Significant experience in designing and delivering data warehouse solutions.
• Strong ETL development and SQL Server expertise with SSIS/SSRS.
• Familiarity with NHS data sets and governance considerations.

Responsibilities

• Lead development and operation of the Trust's data warehouse and BI platforms.
• Oversee BI, RPA and SharePoint development; prioritize multiple workstreams.
• Provide technical leadership from design through testing and deployment.

Skills

Data warehouse design

ETL development

SQL Server

Analytical reporting

Team leadership

Education

Degree level education

CPD / continued professional development

NHS familiarity

Tools

Blue Prism

Power Automate

SharePoint Development

Meditech

Power Platform

Job description

Main area Business Intelligence; IT; Devlopment; IM&T Grade NHS AfC: Band 7 Contract Fixed term: 24 months (Or until postholder returns, whichever is earlier – covering vacancy) Hours Full time - 37.5 hours per week Job ref 158-26-258-DIG

Site The Clatterbridge Cancer Centre - Wirral Town Wirral Salary £49,387 - £56,515 per annum Salary period Yearly Closing 08/11/2026 23:59

In cases where we receive a high volume of applications, we reserve the right to automatically close any vacancies prior to the specified closing date - all vacancies are capped at a sufficient number to progress to shortlisting stage; you are advised to submit your completed application form as early as possible.

We want our recruitment process to be fair, inclusive, and accessible for everyone. If you need support or a reasonable adjustment at any stage of the application or interview process, please contact our Recruitment Team - 0151 5565176 or [e-mail]. Adjustments may include alternative formats, extra time for assessments, communication support, accessible interview arrangements, interview questions prior to interview or other changes tailored to your needs.

Right to work: We actively promote diversity and inclusion. Please note that this role is unlikely to meet the eligibility requirements for sponsorship under the Skilled Worker visa route. We recommend that you assess your eligibility before applying for this position. Skilled Worker sponsorship will be assigned in line with Trust procedure. Visit https://www.gov.uk/skilled-worker-visa

An exciting opportunity has arisen to join the award-winning Business Intelligence team at The Clatterbridge Cancer Centre. We are looking for a Senior Data Engineer and Technical Lead who can provide leadership and support to our development team while remaining hands-on with data engineering, Business Intelligence and automation processes.

The successful candidate will help lead the development and day-to-day operation of the Trust’s data warehouse and Business Intelligence platforms. They will also oversee the work of developers across Business Intelligence, Robotic Process Automation and SharePoint, helping to prioritise competing workstreams and deliver the Trust’s analytical and automated processing goals.

The team is on a transformational journey, making this an excellent opportunity to help shape and deliver innovative, robust and cutting-edge data and Business Intelligence solutions for the Trust.

Main duties of the job

The Senior Data Engineer and Technical Lead is responsible for the development and delivery of the Trust's data warehouse, Business Intelligence and dashboard reporting solutions. The postholder supports the Business Intelligence Manager in delivering a self-service approach to information, ensuring high-quality, accurate and timely intelligence is available to meet clinical, operational and corporate needs.

The role leads the development, implementation and optimisation of ETL processes and the integration of data from multiple information systems. They oversee the day-to-day operation and ongoing enhancement of the Trust's data warehouse, ensuring it remains efficient, reliable and capable of supporting analytical requirements across the organisation.

The postholder manages a small team supporting Business Intelligence, Robotic Process Automation and SharePoint development. They provide technical leadership throughout the development lifecycle, from requirements gathering and solution design to testing, implementation and support.

Working closely with analysts, clinicians, managers, operational teams and external suppliers, they deliver reporting, automation and data solutions that improve efficiency and support decision-making. The role also promotes best practice in system development, data quality, testing, documentation and automation, helping to reduce manual processes and maximise the value of the Trust's Business Intelligence platform and associated systems.

Working for our organisation

The Clatterbridge Cancer Centre NHS Foundation Trust is one of the UK’s leading cancer centres providing highly specialist cancer care to a population of 2.4m people across Cheshire and Merseyside, and the surrounding areas, including North Wales and the Isle of Man.

Our vision is to not only maintain this level of commitment to excellence but to work with our academic and healthcare partners across the region to ensure care, treatment and patient outcomes continuously improve in the future. We are very proud of all our expert and loyal staff and we welcome people who share the collective aim of delivering excellence in everything that we do.

Our values represent who we are and what we believe in. They define how we act to deliver the best possible care for our patients and shape The Clatterbridge Cancer Centre as a great place to work.

We are -

• Kind
• Empowered
• Responsible
• Inclusiv e

Detailed job description and main responsibilities

Please see attached Job Description and Person Specification for full details about this exciting role on offer at The Clatterbridge Cancer Centre.

This position is initially offered as a 24-month fixed-term contract following an internal promotion. The team currently works in a blended fashion, with opportunities to work at our Wirral site and The Spine office in Liverpool.

Person specification

Qualifications

• Educated to relevant degree level/ post graduate diploma (or the equivalent level of experience).
• Evidence of relevant continued professional development in specialist informatics area.
• Membership of a relevant Fed-IP recognised professional body is desirable (BCS, SOCITM, IHRIM, CILIP, AphA)
• Informatics related courses and qualifications.

Knowledge and Expertise

• Experience and advanced knowledge in the use of SQL Server (including SSIS and SSRS)
• Experience of MS SharePoint platform
• Experience or understanding of Robotic Process Automation
• Proficient use of T-SQL
• Highly developed knowledge in Microsoft Office skills and MS operating systems.
• Understanding of Business Intelligence dashboard/reporting, and design
• Good understanding of GDPR, FOI, Information Governance and Caldicott Guidance
• Experience of SharePoint Development
• Experience of Robotic Process Automation development using Blue Prism or MS Power Automat
• Experience of Microsoft Power Platform
• Thorough understanding of NHS performance targets and timescales

Experience

• Significant experience of extracting and analysing complex and sensitive data to support monitoring requirements.
• Able to demonstrate a track record of achievement in database and dashboard/report development
• Experience in implementing and managing and administrating Data Warehousing solutions
• Experience of setting up, and maintaining old and new extracts into a Data Warehouse
• Experience of Meditech
• Significant and relevant experience of working in the NHS or health setting.
• Experience of training and/or supporting software use
• Experience of NHS data sets, broad understanding of NHS information procedures, legislation and policies.
• Experience of managing or leading a team in a technical environment

If you are successfully shortlisted, you will be invited for an interview via email. Please ensure you regularly check your emails (including junk folders) following your application and let us know if you have any problems. If you would prefer for us to communicate with you in a different way, or need adjustments to the interview process, please contact the Recruitment Team on 0151 556 5176 or [e-mail] . All interviews will be undertaken in person unless extraordinary circumstances apply.

If you do not receive confirmation that you have been shortlisted for interview, please assume that you have not been shortlisted on this occasion. It is with regret that we are unable to provide feedback to all non-shortlisted candidates.

The cost of processing a new DBS application is met by the successful applicant. DBS costs are recovered via salary deduction following commencement in post - further details including cost are available from the Recruitment Team. It is a Trust recommendation that candidates requiring a DBS check subscribe to the DBS Update Service - further details are available here - https://www.gov.uk/dbs-update-service . Candidates who withdraw post-DBS submission will be invoiced for the full cost of the check including administration fee.

The Trust takes active responsibility for meeting national guidance and legal requirements in relation to our Safeguarding Policy, including local arrangements for the protection of adults at risk.

The Trust is committed to providing high standards of both patient and staff experience. To support us in doing this the Trust, in partnership with Trade Unions has developed and embedded key values and behaviours that all staff are required to demonstrate throughout their employment. The Trust's values and behaviours support the Trust Vision 'to provide the best cancer care to the people we serve' and our Mission 'to improve health and wellbeing through compassionate, safe and effective cancer care'.

We promote and support diversity in our workforce. The Trust have staff networks such as Ethnic Diversity Staff Network, LGBTQ+ Staff Network, Armed Forces Staff Network, MAPLE Staff Network & Menopause Support Group. The Trust does not tolerate discrimination, bullying or harassment and has firmed up processes for reporting this, including a dedicated Freedom To Speak Up (FTSU) Guardian.