Senior Data Warehouse Developer: Sponsorship Available

Sheffield Health Partnership University NHS Foundation Trust

Job Summary

Do you want a role where you can harness the power of data to improve decision-making for the good of patients and staff?

Are you passionate about producing data sets, developing data pipelines and modelling data to build and maintain a comprehensive and high performing data warehouse?

We’re looking to appoint a Senior Data Warehouse Developer to join our growing Data Warehouse Team. Following investment into our Digital function, we are on a mission to transform complex healthcare data into trusted, accessible information that helps clinicians, managers and decision-makers improve services for our patients. This is an opportunity to work with large-scale datasets, modern data technologies and a highly collaborative and friendly team, delivering solutions that make a genuine difference across the organisation.

Hybrid working: our staff work a mix of from our office at Wardsend Road North and from home. Occasional travel to clinical sites will be required. Everyone is also welcome to work in the office full time.

Interviews are planned for 3rd, 4th & 5th August.

 

Main duties of the job

  • Development and maintenance of the Trust Data Warehouse and database systems.
  • Definition of key Trust measures and metrics in alignment with national guidance and the NHS Data Dictionary.
  • Development and maintenance of tabular models which support the needs of analysts to create service-based performance reports efficiently.
  • Creation, testing and maintenance of a suite of Power BI dashboards for use throughout the Trust.
  • Monitoring the performance of the Data Warehouse and report server to ensure efficiency and high availability for end users.
  • Developing and embedding the Trust technical reporting strategy.
  • Implementing data loading and data access capability from a range of sources using tools such as SSIS, SSRS and T-SQL.
  • Using source control tools (e.g. Azure DevOps, GitHub) to track work items and manage source control, builds, and release pipelines.
  • Leading and developing timely Trust wide access to the required business intelligence tools, supporting dataset returns, operational and performance reporting.
  • Taking responsibility for ensuring that all mandated datasets and data returns are completed within agreed deadlines, adhere to the specification and have appropriate cover in the event of absence.
  • Working with other teams in Digital and in other departments to promote high data quality and the use of self-serve reporting tools.
  • Leading and managing Data Warehouse Developers and Data Warehouse Analysts.

Person Specification

Knowledge and skills

Essential

  • Advanced knowledge of Microsoft SSIS and MS SQL Server database Technologies – SQL Server 2012 and above
  • Advanced T-SQL programming skills
  • Able to demonstrate excellent written, documentation and oral communication skills and abilities
  • Knowledge of NHS data standards and definitions
  • Analytical and logical planning skills

Training and qualifications

Essential

  • Degree in computer related subject or equivalent professional qualification or experience

Desirable

  • Certificate in database administration / data modelling

Experience

Essential

  • Appropriate demonstrable experience in relational database management systems (RDBMS)
  • Significant experience in a data warehousing, BI reporting or data analysis role
  • DW design methodologies

Desirable

  • Staff management
  • NHS information flows, hospital systems and applications
  • Experience of using source control tools (e.g. Azure DevOps, GitHub) for managing work

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: 05 July 2026

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