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.
• Monitor 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.

How to Apply;

Interested and qualified candidates should:
Click here to apply online for this job