Job summary
System Workforce Analyst - Bedfordshire, Luton & Milton Keynes Integrated Care Board
Bedfordshire, Luton & Milton Keynes (BLMK) Integrated Care Board (ICB) is a statutory NHS organisation responsible for developing a plan for meeting the health needs of the population, managing the NHS budget, and arranging for the provision of health services across the BLMK Integrated Care System area.
We are looking for a Data Analyst to support the ICB's Workforce Planning function.The post is being offered as an 12-month fixed term post or secondment opportunity.This is a hybrid role; the successful candidate will work a minimum of 4 days a monthat one of our bases across Bedfordshire, Luton & Milton Keynes.For more detailed information about the role, please contact Alexandra Farkas - alexandra.farkas@nhs.net
Main duties of the job
The Analyst (post holder) will collect, cleanse, process and analyse NHS and other workforce data to provide system-wide workforce intelligence and analysis. The role will support integrated workforce planning across health and social care organisations within the area.
The Analyst will be part of a network of workforce planning and transformation specialists across the East of England, working within the ICB's People Directorate and with partners in Health Education England (HEE) and NHS England (NHSE).
The Analyst will play a pivotal role in supporting the Workforce Planner in profiling the local health and social care workforce, modelling future workforce supply and demand, and collating provider workforce plans into a single ICS/system picture.
About us
We are committed to promoting equal opportunities to achieve equity of access, experience and outcomes and to recognising and valuing people's differences. We are passionate about creating an inclusive workplace that promotes and values diversity; we see this as a strength and part of our founding mission, values and behaviours. We know through experience that different ideas, perspectives and backgrounds create a stronger and more creative work environment that delivers patient outcomes.
We are committed to creating the best place to work, where your contribution is valued, your wellbeing is supported and all our colleagues can reach their full potential. We welcome and encourage applications from all areas of the community, who meet the criteria for the role, regardless of their protected characteristic. We work to ensure that our recruitment processes are as inclusive as possible to everyone, including making adjustments for people who have a disability or long-term condition and support with the recruitment process for people with lived experience.
We are happy to discuss flexible working options for all roles.
We operate a Carer friendly working environment that is supportive and inclusive. We actively encourage Carers to self-identify themselves.
We are a Disability Confident Employer and commit to shortlisting suitable applicants who meet the essential criteria for an interview. Please inform us of any adjustments you may require.
Job description
Job responsibilities
The successful candidate will have ADVANCED proficiency with MICROSOFT EXCEL, with the ability to utilise complex formulas (e.g. SUMIFS, XLOOKUP, Dynamic Array Formulas), functions and visualisation tools (e.g. PivotTables, Charts).
Ideally, the successful candidate will have some proficiency with SQL and PowerBI - although training can be provided for the right candidate.
Job description
Job responsibilities
The successful candidate will have ADVANCED proficiency with MICROSOFT EXCEL, with the ability to utilise complex formulas (e.g. SUMIFS, XLOOKUP, Dynamic Array Formulas), functions and visualisation tools (e.g. PivotTables, Charts).
Ideally, the successful candidate will have some proficiency with SQL and PowerBI - although training can be provided for the right candidate.
Person Specification
Experience and Education
Essential
- Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area
- Significant experience of successfully operating in a politically sensitive environment
- Evidence of continued professional development
- Experience of working in the NHS in a senior administrative or managerial role or equivalent. Experience of managing people.
- Partnership working with a wide range of stakeholders
- Experience of budget management
- Previous experience of working in an analytical role/function
- Experience of working in crossorganisational teams/projects
- Experience of leading and implementing systems development projects
- Demonstrable experience of using/interrogating relational database systems and other large datasets.
- Demonstrable expertise and experience of using a computerized HR/workforce management information system
- Theoretical and practical knowledge of strategic workforce planning at both provider and health economy level
Desirable
- Demonstrable experience of working in a large complex organisation
- Experience of crossorganisational/system working in health and social care
- Knowledge of project principles, techniques and tools, such as Prince 2 Foundation and Microsoft Project
- Experience of managing people
- Knowledge and experience of performance management techniques
Organisational Skills
Essential
- Ability to manage competing priorities in a busy and changing environment
- Project management skills
Communication Skills
Essential
- Ability to prepare and produce concise yet insightful communications for dissemination to senior stakeholders and a broad range of stakeholders as required
- Experience of creating and giving presentations to a varied group of internal and external stakeholders
- Enthusiastic and resilient and can demonstrate commitment.
- Adaptable - with the ability to deal effectively with a wide range of people.
- Effective attention to detail and continuously seeks to improve quality of work.
- Effective telephone manner with the ability to think quickly.
Analytical
Essential
- Advanced proficiency with Microsoft Excel - with the ability to utilise complex formulas (e.g. SUMIFS, XLOOKUP, Dynamic Array Formulas), functions and visualisation tools (e.g. PivotTables, Charts).
- A working knowledge of standard statistical software and spreadsheets, ensuring that the most appropriate statistical techniques can be applied to benefit the team's reporting processes.
- Ability to analyse very complex issues where material is conflicting and drawn from multiple sources.
- Analysing large data sets into meaningful workforce information
Desirable
- Proficiency with SQL.
- Proficiency with PowerBI.
Planning Skills
Essential
- Demonstrated capability to plan over short, medium and longterm timeframes and adjust plans and resource requirements accordingly
- Experience of setting up and implementing internal processes and procedures
Flexibility
Essential
- Ability to travel to other sites within the BLMK area
Desirable
- Able to work outside of traditional office hours on occasion.
Autonomy
Essential
- Demonstrated capabilities to manage own workload and make informed decisions in the absence of required information, working to tight and often changing timescales
- Self-motivated, proactive, and creative.
- Flexible and able to work collaboratively with colleagues.
- Conscientious and responsible
Equality & Diversity
Essential
- The promotion of equality of opportunity and good working relations (providing practical leadership)
Person Specification
Experience and Education
Essential
- Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area
- Significant experience of successfully operating in a politically sensitive environment
- Evidence of continued professional development
- Experience of working in the NHS in a senior administrative or managerial role or equivalent. Experience of managing people.
- Partnership working with a wide range of stakeholders
- Experience of budget management
- Previous experience of working in an analytical role/function
- Experience of working in crossorganisational teams/projects
- Experience of leading and implementing systems development projects
- Demonstrable experience of using/interrogating relational database systems and other large datasets.
- Demonstrable expertise and experience of using a computerized HR/workforce management information system
- Theoretical and practical knowledge of strategic workforce planning at both provider and health economy level
Desirable
- Demonstrable experience of working in a large complex organisation
- Experience of crossorganisational/system working in health and social care
- Knowledge of project principles, techniques and tools, such as Prince 2 Foundation and Microsoft Project
- Experience of managing people
- Knowledge and experience of performance management techniques
Organisational Skills
Essential
- Ability to manage competing priorities in a busy and changing environment
- Project management skills
Communication Skills
Essential
- Ability to prepare and produce concise yet insightful communications for dissemination to senior stakeholders and a broad range of stakeholders as required
- Experience of creating and giving presentations to a varied group of internal and external stakeholders
- Enthusiastic and resilient and can demonstrate commitment.
- Adaptable - with the ability to deal effectively with a wide range of people.
- Effective attention to detail and continuously seeks to improve quality of work.
- Effective telephone manner with the ability to think quickly.
Analytical
Essential
- Advanced proficiency with Microsoft Excel - with the ability to utilise complex formulas (e.g. SUMIFS, XLOOKUP, Dynamic Array Formulas), functions and visualisation tools (e.g. PivotTables, Charts).
- A working knowledge of standard statistical software and spreadsheets, ensuring that the most appropriate statistical techniques can be applied to benefit the team's reporting processes.
- Ability to analyse very complex issues where material is conflicting and drawn from multiple sources.
- Analysing large data sets into meaningful workforce information
Desirable
- Proficiency with SQL.
- Proficiency with PowerBI.
Planning Skills
Essential
- Demonstrated capability to plan over short, medium and longterm timeframes and adjust plans and resource requirements accordingly
- Experience of setting up and implementing internal processes and procedures
Flexibility
Essential
- Ability to travel to other sites within the BLMK area
Desirable
- Able to work outside of traditional office hours on occasion.
Autonomy
Essential
- Demonstrated capabilities to manage own workload and make informed decisions in the absence of required information, working to tight and often changing timescales
- Self-motivated, proactive, and creative.
- Flexible and able to work collaboratively with colleagues.
- Conscientious and responsible
Equality & Diversity
Essential
- The promotion of equality of opportunity and good working relations (providing practical leadership)
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.
Employer details
Employer name
NHS Bedfordshire, Luton and Milton Keynes Integrated Care Board
Address
Home Working / BLMK ICB Priory House, Monks Walk, Shefford, Bedfordshire,
Home Working / BLMK ICB Priory House, Monks Walk, Shefford, Bedfordshire,
Shefford, Bedfordshire,
SG175TQ
Employer's website
https://bedfordshirelutonandmiltonkeynes.icb.nhs.uk/ (Opens in a new tab)
