SYSTEM SUPPORT SPECIALIST – EXCEL MODELLING (12 MONTH CONTRACT)
Listing reference: woolw_001011
Listing status: Under Review
Apply by: 9 December 2024
Position summary
Industry: FMCG & Supply Management
Job category: FMCG, Retail, Wholesale and Supply Chain
Location: Western Cape
Contract: Fixed Term Contract
Remuneration: MARKET RELATED
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 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.
- Maintain 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.
- Experience with requirements gathering and solution design.
- Experience in manufacturing data management preferred.
- Excellent attention to detail skills
- Analytical thinking
- Results orientation
- Good communication skills
- Collaboration skills
- Adaptability
