Job Description

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.

• 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