Data Warehouse Developer
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.
Please note, the number of applicants for this vacancy is capped and will close early if the maximum number of applications has been reached.
Main duties of the job
o Taking ownership of the development and submission of national dataset submissions (e.g., MHSDS, CSDS, NHS Benchmarking).
o Collaborating with the Performance and Clinical Systems teams to understand dataset definitions and ensure compliance with NHS Digital specifications.
o Developing and maintaining validation routines to ensure data accuracy, completeness, and timeliness.
o Monitoring submission schedules and ensure proactive planning for submission deadlines.
o Promoting the use of self-service tools such as Power BI to enable teams to access and explore data effectively.
About us
We are passionate about providing the very best care to the people we support, and we're looking for amazing people who share this passion to join us.
What is it that makes our Trust such a special place to work? Well, it's all about the people. Our staff, service users, carers and families all come from such diverse backgrounds and all have expertise and stories to share.
It's important that you feel supported in your role, that the people who you work with are as passionate as you are and that your health and wellbeing is taken care of
If you're interested in developing your career, you'll have access to a range of training and education opportunities, including apprenticeships, work experience and placements, as well as the chance to get involved in research.
We are very proud of the difference we make to people's lives each and every day and if that's something that you'd like to be part of we'd love to have you with us.
Job description
Job responsibilities
Analytical Skills
Assist in the design, development, and maintenance of ETL processes using SSIS to populate the Data Warehouse.
Write and interpret complex queries using SQL to produce measures and KPIs in alignment with national guidance.
Investigate and analyse data quality issues, data completeness and trends using SQL and propose solutions to improve performance.
Design and manage tabular models (SSAS) to support efficient reporting.
Create and maintain SQL objects such as stored procedures, views, and functions using T-SQL.
Planning and Organisation
Work on own initiative and manage own workload accordingly taking advice from the Senior Data warehouse Developers when required.
Investigate problems and provide technical responses in relation to data set enquiries and plan tasks accordingly.
Ensure data set returns are diarised a year in advance and a schedule of work with responsible owners is kept up to date.
Resource Management
Provide day-to-day supervision, mentoring, and task management to a Band 5 Data Warehouse Analyst.
Support their professional development through knowledge sharing, task delegation, and feedback.
Work collaboratively with other developers to share learning and ensure consistency in development practices.
Undertake audits of data warehouse developments and metric definitions as required.
Produce procedure documentation to support cross cover of work.
Undertake development and/or project work as agreed with Data Warehouse Manager
Information
Work with the Senior Data Warehouse Developer and Business Intelligence colleagues to ensure a high standard of data integrity across all systems.
Support exception reporting to highlight and address quality issues and develop automated checks to prevent recurrence.
Contribute to the Trusts Data Dictionary, helping to define and document data items and measures.
Provide documentation and user guidance to ensure that analysts and end users can fully utilise the data warehouse tools.
Communication
Interpret requirements for information into complex work packages and seek clarity in a non-technical, jargon free way
Freedom to act
They will be consulted as data experts on service improvement relating to our national performance and occasionally provide specialist advice, for example relating to clinical information recording in the EPR.
Research and Development
Attend meetings and webinars related to Local and National Initiatives on the use of data to support quality improvements and meet the Trusts data set obligations.
Keep up to date with newsletters, bulletins and developments on the NHS Futures platform relating to our dataset submissions.
Ensure information and database users and analysts are fully supported and informed on the use of the Data Warehouse for maximum benefit and liaise where necessary with system leads to set up knowledge communities.
Special Conditions
The post holder will be required from time to time, and on relevant issues, to deputise for the Senior Data Warehouse Developers.
The post holder will be required to work out of hours as and when required to perform database administration tasks, for example patching of database systems.
Person Specification
Qualifications
- Degree in computer related subject or equivalent professional qualification or experience.
Knowledge
- Knowledge of Microsoft SSIS and MS SQL Server database Technologies - SQL Server 2012 and above.
- Working knowledge of NHS data and information flows.
Skills
- 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
- 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.
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
Sheffield Health Partnership University NHS Foundation Trust
Address
SHPU Digital
45 Wardsend Road North
Sheffield
S6 1LX
Employer's website
https://www.sheffieldpartnership.nhs.uk/