Excel Business Information Analyst

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  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".