Job summary
Job opportunity - Demand and Capacity Analyst
Permanent
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.
If you would like to discuss this opportunity, please contact craig.kynaston@nhs.net
Please note:
The role is based on a Hybrid working arrangement, where the successful applicant will be required to attend and work from the ICB office in Telford.
Equipment will be provided to ensure the working at home element meets the needs of the role.
The required office-based attendance will be discussed with the successful applicant in order to meet business needs, however will be circa 1 day per week
During the training and induction period, office attendance is likely to be increased to support the successful applicant effectively
Main duties of the job
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.
About us
About us - Shropshire, Telford & Wrekin (STW) Integrated Care Board (ICB)Our goal as an organisation is to lead and support delivery of the four Integrated Care System (ICS) aims across STW.o Improving outcomes in population health and careo Tackling inequalities in outcomes, experience, and accesso Enhancing productivity and value for moneyo 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.
Job description
Job 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.
AmbitionOur commitment to success is shown through supporting and trusting our people to tackle challenging tasks with integrity and creativity.CompassionOur shared purpose, supported by our empathetic, inclusive approach where the contributions of all are valued as we work together to reduce inequalities.OptimismWhere our drive for improvement will be shared with clarity, enthusiasm, and openness.FocusWhere 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.
Job description
Job 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.
AmbitionOur commitment to success is shown through supporting and trusting our people to tackle challenging tasks with integrity and creativity.CompassionOur shared purpose, supported by our empathetic, inclusive approach where the contributions of all are valued as we work together to reduce inequalities.OptimismWhere our drive for improvement will be shared with clarity, enthusiasm, and openness.FocusWhere 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.
Person Specification
Knowledge, Training and Experience
Essential
- Educated to degree level in relevant subject or equivalent level of experience of working at a similar level in specialist area
- Knowledge and expertise of data, and strategic planning functions
- Evidence of post qualifying and continuing professional development
- Demonstrated experience of co-ordinating projects in complex and challenging environments
- Understanding of the public sector
- Demonstrated experience in a Healthcare environment
Desirable
- Comprehensive knowledge of project principles, techniques, and tools, such as Prince 2 Foundation and Microsoft Project
- Previous experience in similar role in public sector
- A good understanding of the health and social care environment and roles and responsibilities within it
Communication Skills
Essential
- Clear communicator with excellent writing, report writing, and presentation skills; capable of constructing and delivering clear ideas and concepts concisely and accurately for diverse audiences
- Skills for communication on complex matters and difficult situations, requiring persuasion and influence
- Skills for nurturing key relationships and maintaining networks
Analytical
Essential
- Ability to analyse and interpret information, pre-empt and evaluate issues, and recommend and appropriate course of action to address the issues
- Problem solving skills and ability to respond to sudden unexpected demands
- Strategic thinking - ability to anticipate
- Attention to detail combined with the ability to extract key messages from complex analysis
- Independent thinker with demonstrated good judgement, problem-solving and analytical skills
- Takes decisions on difficult and contentious issues where they may be a number of courses of action
Desirable
- Takes decisions on difficult and contentious issues where they may be a number of courses of action
Planning Skills
Essential
- Skills for project management
- Previous experience in project management and planning
Desirable
- Previous experience in project management and planning
Autonomy
Essential
- Ability to work on own initiative and organise own workload without supervision working to tight and often changing timescales
Managment Skills
Essential
- Ability to engender trust and confidence and demonstrate integrity in the provision of advice and support
- Skills for managing projects ensuring they meet financial targets
Physical Skills
Essential
- Skills for manipulating information
- Intermediate keyboard skills
Equality and Diversity
Essential
- Understanding of and commitment to equality of opportunity and good working relationships
Person Specification
Knowledge, Training and Experience
Essential
- Educated to degree level in relevant subject or equivalent level of experience of working at a similar level in specialist area
- Knowledge and expertise of data, and strategic planning functions
- Evidence of post qualifying and continuing professional development
- Demonstrated experience of co-ordinating projects in complex and challenging environments
- Understanding of the public sector
- Demonstrated experience in a Healthcare environment
Desirable
- Comprehensive knowledge of project principles, techniques, and tools, such as Prince 2 Foundation and Microsoft Project
- Previous experience in similar role in public sector
- A good understanding of the health and social care environment and roles and responsibilities within it
Communication Skills
Essential
- Clear communicator with excellent writing, report writing, and presentation skills; capable of constructing and delivering clear ideas and concepts concisely and accurately for diverse audiences
- Skills for communication on complex matters and difficult situations, requiring persuasion and influence
- Skills for nurturing key relationships and maintaining networks
Analytical
Essential
- Ability to analyse and interpret information, pre-empt and evaluate issues, and recommend and appropriate course of action to address the issues
- Problem solving skills and ability to respond to sudden unexpected demands
- Strategic thinking - ability to anticipate
- Attention to detail combined with the ability to extract key messages from complex analysis
- Independent thinker with demonstrated good judgement, problem-solving and analytical skills
- Takes decisions on difficult and contentious issues where they may be a number of courses of action
Desirable
- Takes decisions on difficult and contentious issues where they may be a number of courses of action
Planning Skills
Essential
- Skills for project management
- Previous experience in project management and planning
Desirable
- Previous experience in project management and planning
Autonomy
Essential
- Ability to work on own initiative and organise own workload without supervision working to tight and often changing timescales
Managment Skills
Essential
- Ability to engender trust and confidence and demonstrate integrity in the provision of advice and support
- Skills for managing projects ensuring they meet financial targets
Physical Skills
Essential
- Skills for manipulating information
- Intermediate keyboard skills
Equality and Diversity
Essential
- Understanding of and commitment to equality of opportunity and good working relationships
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
