Excel Business Information Analyst
Public Sector Resourcing United Kingdom
Staffing and Recruiting · 201-500 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
The analyst will take ownership of workforce data and reporting, producing establishment and vacancy analysis to support recruitment and planning. They will also create executive-ready reports and slide decks to provide actionable insights for senior leadership.
What they look for
Requirements
Candidates must possess advanced Excel skills, including expertise in complex data analysis, validation, and dashboard creation. Additionally, they require strong proficiency in PowerPoint and the ability to translate complex datasets into clear, visually engaging narratives for executive stakeholders.
Full description
Description & Requirements
On behalf of HS2, we are looking for an Excel Business Information Analyst (Inside IR35) for a 4 month hybrid contract based in Birmingham.
HS2 is Britain’s new high-speed railway that supports the government’s number one mission growth. When it’s fully operational, the line will connect London and Birmingham in just 49 minutes. This will create better journeys for passengers. The railway links our two biggest economic centres, connects people with jobs and is attracting major investment before services begin. It then extends north of Birmingham to Handsacre in Staffordshire. Here, HS2 trains will connect to the West Coast Main Line for the Northwest and Scotland.
HS2 provides benefits for everyone faster, more reliable journeys for passengers; better connections to markets and people for businesses; and investment in infrastructure and skills for local communities.
As an Excel Business Information Analyst, your main responsibilities will be to:
- Take ownership of workforce data and reporting.
- Produce accurate establishment and vacancy analysis.
- Support recruitment approvals and workforce planning activities.
- Create executive-ready reports and slide decks with minimal supervision.
- Provide meaningful insight rather than simply reporting numbers.
- Identify risks, trends and opportunities within workforce data.
Essential:
- Advanced Excel capability to include expert use of: Pivot Tables; VLOOKUP/XLOOKUP; Data analysis and validation; Trend analysis; Workforce and establishment reporting; Comparing and contrasting multiple datasets; Identifying anomalies, gaps and performance trends; and creation of management information dashboards.
- Advanced analytical reporting capability, converting complex workforce and recruitment data into clear, actionable insights for executive decision-making.
- Highly proficient in PowerPoint and executive reporting, producing impactful presentations and reports for CFOs, Senior Leadership Teams and executive stakeholders.
- Skilled at translating large and complex datasets into concise, visually engaging narratives that support strategic planning and business performance.
Please be aware that this role can only be worked within the UK and not Overseas.
In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".
General information
Posting ID
PSR1JP00107785
Type of employment
Contract
Organisation
HS2
Location
Birmingham
Workplace Type
Hybrid
