Senior Data Warehouse Developer

Job overview

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.

Detailed job description and main responsibilities

You can find further details about the role, including key responsibilities and accountabilities, alongside the organisational structure and person specification in the attached job description.

Please ensure your supporting statement includes demonstrable evidence and specific examples on how you meet the criteria for each of the key skills specified. This will be used in the shortlisting process.