Senior Data Warehouse Developer

Job summary

Please note that while the advertised closing date for applications is 5th July, we reserve the right to close the vacancy earlier if we receive a high volume of suitable applications. If this happens while you are part-way through an application, you would not be able to submit it. We therefore encourage you to submit your application as soon as possible to avoid missing out.

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.

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.