Excel Modelling Analyst (12 Month Contract)

Western Cape, South Africa

Job Description


Position summaryIndustry: FMCG & Supply ManagementJob category: FMCG, Retail, Wholesale and Supply ChainLocation: Western CapeContract: TemporaryEE position: NoIntroductionTo 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

Woolworths

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1388456
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Western Cape, South Africa
  • Education
    Not mentioned