Data Warehouse Developer: Sponsorship Available

Sheffield Health Partnership University NHS Foundation Trust

Job Summary

Join our Digital team and use your data expertise to make a genuine impact on mental health and community services across Sheffield. As a Band 6 Data Warehouse Developer, you will design, develop and maintain robust ETL processes using SSIS, write and optimise complex T-SQL queries to deliver national KPIs and performance measures, manage SSAS tabular models, and proactively investigate and resolve data quality issues to ensure high standards of integrity across our systems.

Working closely with Senior Developers and Business Intelligence colleagues, you will translate complex information requirements into clear technical solutions, contribute to our Trust Data Warehouse, provide operational reports and support national dataset submissions. You will also mentor a Band 5 Data Warehouse analyst, promote consistent development practices, and help drive continuous improvement in our data warehouse environment.

Experience with mental health datasets and Rio EPR is advantageous but not essential. If you are a skilled SQL developer who wants your work to directly support frontline care within SHPU, we would love to hear from you.

Main duties of the job

  • Taking ownership of the development and submission of national dataset submissions (e.g., MHSDS, CSDS, NHS Benchmarking).
  • Collaborating with the Performance and Clinical Systems teams to understand dataset definitions and ensure compliance with NHS Digital specifications.
  • Developing and maintaining validation routines to ensure data accuracy, completeness, and timeliness.
  • Monitoring submission schedules and ensure proactive planning for submission deadlines.
  • Promoting the use of self-service tools such as Power BI to enable teams to access and explore data effectively.

Person Specification

Qualifications

Essential

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

Knowledge

Essential

  • Knowledge of Microsoft SSIS and MS SQL Server database Technologies – SQL Server 2012 and above.
  • Working knowledge of NHS data and information flows.

Skills

Essential

  • Strong analytical skills and ability to understand complex data relationships.
  • Advanced T-SQL programming skills
  • Able to demonstrate excellent written, documentation and oral communication skills and abilities.
  • Highly methodical and organised with ability to work on own initiative and in setting of priorities and objectives for self and others.

Experience

Essential

  • Substantial experience in a data warehouse, BI reporting or data analysis role
  • Experience of using tools such as ETL, SSIS, SSRS, SSAS and T-SQL.
  • Experience of submitting timely, statutory and mandatory returns.

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: 27 March 2026

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