Senior Data Engineer: Sponsorship Available

Royal Cornwall Hospitals Trust

Job summary

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.

Main duties of the job

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.

Person Specification

Qualifications

Essential

  • Master’s degree or equivalent level of experience.
  • Microsoft SQL qualifications or equivalent experience.

Desirable

  • Advanced SQL qualifications
  • ITIL qualifications

Experience

Essential

  • Significant specialist experience of SQL and SSIS.
  • Significant experience of working in Information Management.
  • Specialist knowledge and experience of Business Intelligence design, development and implementation
  • Specialist knowledge and experience of data warehouse development and maintenance (particularly SSIS and SQL Server).

Desirable

  • Experience of NHS clinical and business systems.
  • Knowledge of JSON and XML.
  • Knowledge of Oracle, Postgres and MySQL.

Practical and Intellectual Skills

Essential

  • Expert use of SQL and the Microsoft Business Intelligence Stack (SSIS, SSAS, SSRS and Power BI).
  • Knowledge of relational database design, implementation and support.
  • Excellent communication, problem solving and troubleshooting skills
  • Good awareness of OLAP technologies and their relevance to information solutions.
  • Excellent level of ability with IT and advanced keyboard skills, including extensive MS Office knowledge and skills (spread sheets, databases, word processing).
  • Professional attitude, team player and self motivated.

Desirable

  • Knowledge of VBA, MDX, DAX, HL7v2, HL7v3, FHIR

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Closing Date: 23 August 2026

To apply for this job please visit apps.trac.jobs.