Job Description

Listing reference:

woolw_001104

Listing status:

Online

Apply by:

28 February 2025

Position summary

Industry:

FMCG & Supply Management

Job category:

FMCG, Retail, Wholesale and Supply Chain

Location:

Western Cape

Contract:

Temporary

EE position:

No

Introduction

To own and serve as custodian of the Value Delivery Excel-based toolset, as well as the related inputs and outputs. Design & build new functionality in excel-based toolset, maintain & enhance existing tools.

Job description

Work with the Value Delivery Category Leads to gather their requirements, design & develop solutions for those requirements in the excel-based toolset. Convert conceptual user needs into practical solutions that are operationally viable in excel, scalable within the constraints of the project, and minimise the risk of user error in their design. Constantly seek to optimise user experience of the tools, by adapting the existing tools or creating new ones according to need & viability. Collaborate in the planning, sizing, dependency identification and timing of functional enhancements to the tools & supporting system. Own the maintenance of the existing tools; support with troubleshooting, fix bugs, prioritise & communicate bug-related fixes to the relevant stakeholders. Work with the Value Delivery System Support Specialists to drive the optimisation of BAU tools & related processes to enable scalability. Work with the Value Delivery System/Database Custodian to develop new exports as required to populate new solutions in excel tools.

Minimum requirements

Relevant commercial degree/diploma. Strong numeric acumen & logical thinking. Demonstrated independent experience with building models & tools in Excel. Extensive proven capability in using Excel functions such as lookups (VLookup, HLookup, XLookup), Index Match, Data management in tables, Power Query, intermediate mathematical formulas, IF statements, conditional formatting, validations, pivots & slicers, graphs. Prior experience with requirements gathering and solution design. Prior experience in manufacturing data management preferred. Attention to detail Analytical thinking Results orientation Good communication skills Collaboration skills * Adaptability