Senior Data Engineer
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.
About us
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.
Job description
Job responsibilities
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 brandon.chapman@nhs.net
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.
Person Specification
Qualifications
- Master's degree or equivalent level of experience.
- Microsoft SQL qualifications or equivalent experience.
- Advanced SQL qualifications
- ITIL qualifications
Experience
- 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).
- Experience of NHS clinical and business systems.
- Knowledge of JSON and XML.
- Knowledge of Oracle, Postgres and MySQL.
Practical and Intellectual Skills
- 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.
- 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.
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.
Employer details
Employer name
Royal Cornwall Hospitals Trust
Address
Royal Cornwall Hospital
Truro
TR1 3LJ
United Kingdom
Employer's website
https://www.royalcornwall.nhs.uk/