Workload and Resource Modeller
|Job Title:||Workload and Resource Modeller|
|Contact Name:||Lauren Byrne|
|Job Published:||January 22, 2021 10:22|
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. The role of Workload and Resource Modeller will play a critical role in ensuring that the business 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.
*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.
*Collaborate across departmental teams to help improve the delivery and consistency of the Forecasting Model.
*Respond to and deliver against ad-hoc requests for data from across the organisation.
*Review and audit data to ensure it is correct, raising issues and areas for action as required.
*Proactively inform the Operations about resource impacts, issues, opportunities, etc.
*Proactively identify ways to improve the Models and their accuracy.
*Present and explain Model inputs and outputs to Stakeholders, 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)
*Excellent standard of oral and written communication
*Planning, co-ordination and organisational skills with the ability to meet challenging deadlines.
*Excellent decision-making skills with the ability to use own initiative.
*Ability to adapt to an ever-changing environment and react quickly to emerging challenges.
*Experience using Microsoft SharePoint and QlikView an advantage
Duration: 6 weeks - pending extension
Electus Recruitment Solutions provides specialist engineering and technical recruitment solutions to a number of high technology industries. We thank you for your interest in this vacancy. If you don't hear from us within 7 working days please presume your application has been unsuccessful on this occasion. You are of course free to resubmit your CV/details in the future and we shall assess your suitability at that time.
Keywords: Power Queries, VLOOKUP, HLOOKUP, workload models, government, public sector
Electus Recruitment Ltd is acting as an Employment Business in relation to this vacancy.