Demand and Capacity Analyst

The Demand and Capacity Analyst supports the Business Intelligence and Analytics team and departments across the ICB. The post holder will be responsible for providing a clear picture of demand and capacity of services across STW using advanced modelling techniques., Our goal as an organisation is to lead and support delivery of the four Integrated Care System (ICS) aims across STW.

• Improving outcomes in population health and care


• Tackling inequalities in outcomes, experience, and access


• Enhancing productivity and value for money


• Helping the NHS to support broader social and economic development.

All staff are required to model the values of the organisation detailed below, to support the ICB to successfully deliver these aims.,
• Assist the ICB quality team in improving quality and outcomes of the STW population.


• Play a key part in supporting the demand and capacity team to produce reports and dashboards and analytical to predict future demand for care services.


• Overlay this with capacity in the system to advise on potential upcoming risks in capacity gaps.


• Respond to specific demand and capacity questions required of the ICB with support from the Business Intelligence and Analytics team.


• Responding to requests for data and analysis from across the ICB and ICS.


• application of advanced modelling techniques for demand forecasting and how this relates to capacity.


• Gather and cleanse data from multiple sources, of different types and formats.


• Use advanced modelling techniques to forecast demand and validate outputs with colleagues. This will involve the use of R software but training will be provided where necessary.


• Provide analytical support to specific contract teams.


• Produce reports and dashboards, using automation where possible and appropriate.


• Use and analyse SLAM (Service Level Agreement Management) contract monitoring datasets.


• Analyse and interpret complex data to produce detailed, concise reports, suitable for formal presentation to clinicians and managers within the ICB.


• Load data into SQL databases to allow SQL querying and R-based analysis.


• Contribute to the development of local system data and knowledge infrastructure by improving data quality, identifying data gaps, ensuring that any new datasets are standardised and aligned with wider local requirements, that new data flows are stored in a centralised data warehouse environment, and accessible to all analysts, ensuring that any code sets, definitions or coding scripts produced by the analyst are available for reuse and replication by other analysts within the wider system.


• Align to multiple ICB contracts which require monitoring, reporting and activity forecasting.


• Working with analysts from other health and social care organisations within the system to allow the best sharing and use of data.


• Work with provider organisations to understand how capacity metrics can be used to understand if they meet demand e.g., bed days, hours worked, number of staff.


• Participate in relevant internal and external working groups/projects, services, and initiatives to provide information and analytical input to strategic leads.

4

• Work with members of the System Analytics Intelligence Unit (SAIU) to develop and implement project data collection systems that will provide accurate and timely data.


• Support the ICB in their duties to submit operational and strategic activity plans and trajectories as part of national returns and work with colleagues across the ICB including health and social care provider analysts to encourage the flow of data and intelligence in relation to demand and capacity.


• Support demand planning, including development of annual activity plans for a range of health service provider contracts.

Our Values & Behaviours
We embody compassion, respect, drive, and integrity in our unique role within the STW health and care system. We value diverse contributions, drawing on the expertise and experience of local people, staff and partners, alongside high-quality intelligence to serve our communities effectively.
The below measures help assess how effectively we foster a compassionate culture, communicate our optimism, engage with stakeholders to drive positive change, are transparent in decision making and ensure our efforts are aligned with the priorities of our communities to address health outcomes and inequalities.
Ambition
Our commitment to success is shown through supporting and trusting our people to tackle challenging tasks with integrity and creativity.
Compassion
Our shared purpose, supported by our empathetic, inclusive approach where the contributions of all are valued as we work together to reduce inequalities.
Optimism
Where our drive for improvement will be shared with clarity, enthusiasm, and openness.
Focus
Where our efforts are concentrated towards, to improve health and wellbeing with the people of STW.
These values are measured by evidence of behaviours captured through performance appraisals, feedback from ICS partners and staff surveys and our lived experience groups. Additionally, we ensure transparency in decision-making and ethical considerations in our records, and we demonstrate the impact of lived experiences in developing and tracking plans.

A new and exciting opportunity has arisen for an inquisitive thinker to join the ICB's Business Intelligence and Analytics Team. We are looking for an individual who has the determination to truly understand demand and capacity for health & care services across NHS Shropshire, Telford and Wrekin. You will drive the delivery of a coordinated approach to demand and capacity modelling across the system working with ICB and wider system colleagues. This will involve the population and ongoing development of a system wide model which is directly fed by partners' individual organisational models. This will allow us to better understand our existing and future demand & capacity challenges, predict our medium-term requirements which in turn will inform our medium term financial planning and the strategic commissioning of services.
You will need excellent modelling and reasoning skills, be experienced in forecasting and statistical techniques with the ability to translate outputs into informative decision-making pieces of analysis.