Workload Analyst - (Excel, VBA, Power Query)

GB  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Description

REMOTE WORKING/INSIDE IR35/REMOTE WORKING/INSIDE IR35/REMOTE WORKING/INSIDE IR35

Our government client has increased their capabilities to carry out inspections related to COVID secure workplaces in the UK. Supported by an analytics and intelligence functions; this new model has allowed the organisation to take on a large scale approach.

They are increasing the size and scale of the Spot Check operations in the coming weeks and now need a new Workload and Resource Modeller.

This role is an operational position that is focused toward modelling the workload and the capacity across the operation, forecasting volumes at each stage and anticipating the resource and cost implications. This is an essential role in ensuring that the organisation can deliver against the requirements of the Covid process by ensuring that the operational team have an accurate forecast of their workload and the necessary resource to manage it.

This role plays a key part in COVID response in ensuring that they deliver our objectives and can effectively respond to changing priorities and ultimately provide public assurance that GB workplaces are COVID secure.

Key Responsibilities

Construct, adapt, improve, expand, maintain, present, explain, regularly update and calibrate a clear and user-friendly Operational and Resource Forecasting Model, including impacts on costs, workload, FTE and capacity.
Conduct and provide Statistical Analysis to support the ongoing Forecasting processes
Prepare Data and MI to support and guide operational decision making
Produce scenario analysis and sensitivity analysis when required
Review and audit data to ensure it is correct, raising issues and areas for action as required
Proactively identify ways to improve the Models and their accuracy.
Present and explain Model inputs and outputs to Stakeholders, if and when required.

Essential Skills and Experience

Strong analytical and numerical skills and attention to detail.

Advanced Microsoft Excel skills to manipulate, manage, analyse and present data, including knowledge and experience with Pivot Tables, Excel Functions (such as VLOOKUP, HLOOKUP, INDEX, MATCH, COUNTIF, IF, etc), Macros and basic VBA

Experienced using Power Queries in Microsoft Excel to prepare and transform data from multiple sources
Capability to present outputs (tables, charts, slides, etc) in an accurate, user-friendly and consistent manner, with good presentation.

Extensive experience in the creation and maintenance of Workload and Resource Forecasting Models in an operational setting (such as a Contact Centre)

Understands the context and nature of the Covid challenge and the response
Experience using Microsoft SharePoint and QlikView an advantage

This is a home/remote based role.

Start date
ASAP
Duration
2- 3 months
From
IT Talent Solutions Ltd
Published at
26.01.2021
Project ID:
2036447
Contract type
Freelance
To apply to this project you must log in.
Register