This role has been approved for advertising; however, it is also being assessed as a suitable alternative employment opportunity. As a result, the vacancy may be withdrawn or there may be a delay before shortlisting can begin.
This role is open to all applicants. However, in line with Cornwall First recruitment principles, initial shortlisting will prioritise applicants from Royal Cornwall Hospitals NHS Trust, Cornwall Partnership NHS Foundation Trust, and the Integrated Care Board for Cornwall and the Isles of Scilly.
An exciting opportunity has arisen for an experienced Senior Data Engineer to join the Information and Business Intelligence Team at Royal Cornwall Hospitals NHS Trust.
This key senior role will support the development and optimisation of the Trust’s data warehouse, reporting and analytics platform; Utilising SQL Server, SSIS, SSRS, SSAS and Power BI. The post holder will lead on robust and scalable data flows, maintaining existing flows whilst also supporting the teams aspects of migrating to a new EPR system, and work closely with clinical, operational, technical and senior colleagues to ensure high-quality information for operational, statutory and strategic reporting.
Operating with significant autonomy as a senior role in the design, development, implementation and support of the Trust’s data engineering capability, with particular responsibility for building and maintaining robust data flows from operational systems into the Trust data warehouse and analytics platform (RADAR).
To lead on the development, optimisation and maintenance of complex ETL processes, SQL scripts, data models and related technical components across the Trust’s Business Intelligence estate, including SQL Server, SSIS, SSRS, Power BI and associated reporting databases and services such as RADAR.
To provide specialist technical leadership within the Information and BI service, translating business and information requirements into scalable data engineering solutions, and ensuring that data products are designed to meet the needs of clinicians, operational teams, managers and external reporting bodies.
To lead on the implementation of data quality, validation, monitoring and documentation standards across data engineering processes so that information products are reliable, reproducible and aligned to NHS definitions, national standards and local Trust requirements.
To mentor and support other analysts and developers within the team, promoting good engineering practice, strong version control, knowledge sharing and continual service improvement across the Information and BI service.
Royal Cornwall Hospitals NHS Trust (RCHT) is at the heart of acute and specialist care for Cornwall and the Isles of Scilly. We care for a population of around 470,000 people, a number that increases during visitor seasons. We employ around 6,700 staff, united by a shared commitment to deliver safe, high‑quality care. We provide services across three main hospital sites, with around 780 inpatient beds:
Royal Cornwall Hospital in Truro
St Michael’s Hospital in Hayle
West Cornwall Hospital in Penzance
As a teaching hospital, we’re proud to work in partnership with the University of Exeter Medical School, the University of Plymouth School of Nursing and Midwifery, and Peninsula Dental School, supporting the next generation of health professionals. We’re committed to staying at the forefront of medical advance; investing in our people, developing our facilities, and expanding the specialist care we can offer locally so more patients can receive the care they need closer to home. We have a growing reputation for research and innovation that helps shape better care for the future. The Knowledge Spa, located on our Truro site, is a vibrant hub for medical, nursing and professional education across clinical and non‑clinical roles. It plays a vital role in attracting, developing and retaining highly skilled teams.
We are driven by one clear ambition, Outstanding Care for One and All, care that’s safe, kind and high-quality. We are RCHT.
Please see attached job description and specification for all details.
Interviews for this role will be held on-site at Royal Cornwall Hospital in Truro, Cornwall.
Home / Remote working will be considered for this job role.
If you are interested in the role and would like an informal chat for any queries you may have prior to applying, please contact
[email protected]
To be an employee of the NHS you need to successfully complete the following:
Identity Checks
Professional registration and qualification checks
Employment history and reference checks
Occupational Health clearance
Satisfactory Disclosure and Barring Service check
Right to work in the UK
For further information please visit:
https://www.nhsemployers.org/topics-networks/employment-standards-and-regulation
We reserve the right to close this advert early.
We may be able to offer flexible working. Please discuss at interview.
