Workforce Planning and Insight Lead

**Details**:
**Reference number**:

- 298765**Salary**:

- £39,428 - £43,159- A Civil Service Pension with an average employer contribution of 27%**Job grade**:

- Senior Executive Officer**Contract type**:

- Fixed Term**Length of employment**:

- 12 months**Business area**:

- DFT - Corporate Delivery Group (CDG)**Type of role**:

- Administration / Corporate Support
- Analytical
- Human Resources**Working pattern**:

- Flexible working, Full-time, Job share, Part-time**Number of jobs available**:

- 1Contents

Location

About the job

**Benefits**:
Things you need to know

Location
- Birmingham, Hastings, Leeds, SwanseaAbout the job

**Job summary**:
**Locations: Birmingham, Leeds, Swansea, Hastings**

**Salary: £39,428 - £43,159**

Can you utilise Excel to create scenario modelling, and use data and insight to influence decision making?

Do you have experience building relationships with a range of stakeholders, and enjoy solving problems?

**If so, we'd love to hear from you**

Workforce Planning ensures departments have the right resource, capability and talent to deliver priorities, both in the short and long term. At the heart of this is translating business strategy into a strategic workforce plan which identifies future workforce requirements and capability gaps, so that strategic resourcing solutions can be developed to address the gaps. Effective and timely workforce planning goes beyond forecasting headcount and can provide agile people solutions to complement the future direction of a business.

**Job description**:
We are looking for someone with strong Microsoft Excel modelling skills with a keen interest in HR and who enjoys problem solving and working with others. This role will have the opportunity to help shape the core department’s workforce planning expert service and work across the HR function and wider department to deliver this.

This role would suit someone who enjoys being part of team and working with others but is also comfortable working independently. If you are new to Human Resources, then it offers the chance to explore the profession as workforce planning touches on the whole function and its different specialist areas. You will be supported to understand the role of the profession and the department it supports. If you are already an HR professional then you will be supported to develop further and work in a highly strategic area, looking to the future and assessing how priorities will be delivered through our people.

More information about choosing a career in Strategic Workforce Planning (SWP)

**Person specification**:
**Duties and responsibilities**:
You will have an integral role to play in the HR Function and wider department building Excel models to forecast our future workforce demand and to generate workforce insights to identify what skills and resource is required in the future and where we may have workforce issues and risks.

Key responsibilities and outcomes will include but are not limited to:

- Creating and maintaining spreadsheet workforce planning models using Microsoft Excel, that can be used to forecast the size and nature of future workforce demand to help create medium-to longer term resourcing plans, and help shape workforce planning interventions across the department.
- Supporting the Workforce Planning and Insight Manager working across the wider department building key working relationships with others such as finance and strategy to achieve a coordinated and joined up approach to business planning and workforce planning.
- Working with stakeholders across HR, (including the HR analytics team) to assure the requirements, integrity, and availability of workforce data, identifying any trends or workforce risks that make up our workforce “story”, sharing insights and best practice across teams to enhance the HR service for DfTc.
- Supporting the Workforce Planning and Insight Manager to develop departmental workforce narratives and strategies based on insight from workforce data and plans and credible relationships across the department.
- Producing monthly workforce packs for HR Business Partners providing key insights and narrative on DG Groups workforce position to support robust workforce planning across the department.

Please refer to the role profile for a full list of the roles responsibilities.

**Experience**

You must have experience in the following:

- ** Advanced Excel Skills** - Ability to utilise Excel to create user-friendly tools for complex scenario modelling, forecasting and analysis using a range of functions including VLOOKUP, Conditional Formatting and other Excel based techniques.
- ** Building and managing relationships and partnerships** - consulting and collaborating with key stakeholders, including experience of building effective working relationships with internal and external stakeholders.
- ** Using data and evidence to make decisions and influence** - interpreting data to create and present evidence-bas