Demand and Capacity Analyst

Detailed job description and main responsibilities

Key Duties & Responsibilities
• 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.