**Banding subject to confirmation of Agenda for Change evaluation**
This is a newly created position, to support the delivery Digital Service Roadmap supporting the Trust’s vision and strategic goals.
It is an exciting time to be joining The Shrewsbury and Telford Hospital NHS Trust (SaTH) to build and lead an exceptional Data Warehouse team. You will lead and develop the delivery of data systems to support management commissioning and Trust business systems as well as enabling efficient communications internally and externally aligned to the Trusts strategic plan.
You will define the data architecture framework, standards and principles, including modelling, metadata, security, reference data and to define reference architecture, which is a pattern that others can follow to create and improve data systems.
You will need to have strong logical reasoning skills, insight and analytics development skills, and be experienced in optimising data visualisation. You will drive requirement gathering and analytics developments with an aim towards providing data visualisation tools to guide short-term and long-term decisions for the Trust.
The postholder will provide senior managerial leadership, support and development for teams, ensuring that strict business targets are met as well as leading on strategic planning for BI systems.
The postholder will be part of the Digital Service Senior Manager On-call Rota.
Main duties of the job
To lead a Data Warehouse Team
Highly developed specialised knowledge in data systems, Business Intelligence and information reporting
An ability to build relationships quickly and work effectively with other senior leaders
To formulate strategies and make recommendations for the improvement of systems and processes based on this analysis.
To be the Trust expert in data and Business Intelligence Systems and support the project management and implementation of Trust wide IT systems
To develop and maintain robust contingency plans to ensure that key information systems can continue to be used during periods of downtime or system failure.
Contribute and formulate to long term strategic plans and takes the lead in advising long-term strategic data and BI system planning
To develop road maps for the BI systems for the next 5 years ensuring the strategic vision of the Trust is incorporated into the Digital Services strategic plan
Responsible for the planning, development, update and / or upgrade of new major IT systems into the organisation to ensure that the developments meet user requirements e.g. re-design of the Data Warehouse, Business Intelligence and Clinical dashboards.
To ensure robust systems are in place for the collection and analysis of waiting list, activity data and A & E services, ensuring issues are resolved in line with national guidance
Working for our organisation
As a member of the Digital Service's Directorate, this role will be critical to improving the organisation’s understanding of opportunities and risks and in improving the quality of decision-making. The role will support the delivery of the Trust’s vison and strategic goals though the identification of key insights that drive improvements to the effectiveness and efficiency of the services provided. Your team will create central reporting systems to ease the day to day job of staff at all levels. This in turn will help the Trust deliver its integrated care vision.
Detailed job description and main responsibilities
For full duties and responsibilities please refer to the attached document entitled Job Description.
Educated to master’s degree level or equivalent level of experience and training
Relevant qualification in data architecture
Background in Microsoft Stack including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
Highly proficient database design, management and querying skills with a proven ability to write complex stored procedures, functions and triggers.
Demonstrate excellent skills in analysis, design and presentation methods relating to information systems, using a range of software applications including Microsoft Visio, databases, OLAP and executive and management information systems to an advanced level.
Advanced skills in Microsoft Office 365 products including Excel, Power Query, Power Pivot, Power BI and Power Automate.
Ability to communicate in a persuasive manner, a range of highly complex information to large groups and senior managers.
A logical approach to investigating, analysing and resolving data and programming problems.
Experience of workforce management
Project management skills.
Proficient in the analysis and process mapping of clinical workflows.
Office VBA skills
Detailed knowledge of NHS Standard Data Sets and information and data flows between NHS Organisations.
Understanding of the multidisciplinary clinical components involved during a patients journey in an Acute Trust.
Understanding the patient flows, including coding processes, discharge and follow up processes, outpatient processes.
Specialist knowledge and experience of database design using current Microsoft technologies.
Knowledge of the national IM&T strategy.
Understanding of the clinical governance agenda, clinical risk strategies and national service frameworks and their relevance to the EPR.
Knowledge of the review process for policy review and development.
Knowledge of data in a cloud environment eg Azure or AWS