Senior Data Engineer

Royal Cornwall Hospitals NHS Trust; Truro; On-site; GBP 65,000 - 90,000; Full time

Job summary

Royal Cornwall Hospitals NHS Trust is seeking an experienced Senior Data Engineer to join the Information and Business Intelligence Team to support the development and optimisation of the Trust's data warehouse, reporting and analytics platform (RADAR).

The post holder will lead on robust and scalable data flows, ETL processes using SQL Server, SSIS, SSRS and SSAS, and Power BI, collaborating with clinicians, operational teams and senior staff to deliver high-quality information for operational,

Qualifications

• Experience designing scalable data warehouses and ETL pipelines.
• Collaborating with clinical, operational and senior staff to meet reporting needs.
• Knowledge of NHS data standards and definitions is desirable.

Responsibilities

• Lead development, optimisation and maintenance of data flows from operational systems into the Trust data warehouse and RADAR.
• Develop data models and implement data quality, monitoring and documentation standards.
• Provide technical leadership and mentoring within the Information and BI service.

Skills

SQL Server

ETL pipelines

Power BI

SSIS

SSRS

SSAS

Data modelling

Data warehouse design

Tools

RADAR

Power BI

SQL Server

Job description

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.

For further details / informal visits contact:
Name: Brandon Chapman
Job title: Information Section Manager
Email address: [e-mail]
Telephone number: 07826929683