The first Woolworths store opened its doors to the public in Cape Town in October 1931. And it was founder Max Sonnenberg who captured the public’s imagination with dynamic store policies that set Woolworths apart from its competitors.
Three years later, a second branch opened in Durban, with another two in Port Elizabeth and Johannesburg a year later. And...
Read more about this company
System Support Specialist – Excel Modelling (12 Month Contract)
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.
20 Initiatives to Boost Employee EngagementAre you struggling with improving employee engagement at work? This article covers everything from better communication to building a strong workplace culture.
30 Common Interview Mistakes to AvoidThis piece examines 30 of the most common mistakes applicants make at interviews, so you know how to better avoid them.