Operational Data Analyst - Brackenfell at Shoprite Group of Companies

Job Objectives

• Work with business stakeholders to understand and correctly frame analysis requirements, hypotheses and questions and propose fit-for-purpose data led solutions. 
• Work with business, technology and development teams and agree on the right data and application of the right analytical techniques to produce the right business insights. 
• Write complex business requirements/modifications to transform data into common and graphical formats, reports, and dashboards. 
• Scope, design, build and publish comprehensive and compelling dashboards, reports and analytical findings including insightful observations, commentary, and recommendations to optimise spend or increase the effectiveness of initiatives. 
• Support with complex data related queries from business stakeholders, helping to resolve issues or enable understanding and integration of findings to unlock key insights.   
• Validate datasets and reports and proactively resolve any data or metric related issues. 
• Evaluate the accuracy of data sources and data gathering techniques and ensure data quality and integrity is maintained. 
• Maintain documentation, user guides or training material, ensuring the same language and definitions are applied. 
• Guide and support new and emerging data analysts with new and complex projects. 
• Collaborate across teams and functions to fully leverage data and enable transformative insights that drive sound business decisions. 
• Stay updated on developments in data analytics and adjacent fields to ensure the latest techniques and methods are applied.

USAVE specific inputs

• Daily tracking of deranged stock of highest value stores to aggressively drive reduction of deranged stock
• Daily analysis of MPS (minimum presentation stock) vs ROS (rate of sales) on store level in conjunction with Store Replenisher.
• Identify & track high promotional OOS (out of stock) items daily during promotion period to minimize high OOS percentages
• Create and maintain daily GP (gross profit) tracker on Foods & Non-foods. High level investigation required to identify outliers
• Daily updates on high-risk expiry items on store level
• Create and maintain OOS dashboard to highlight items with a consistent high OOS
• Develop reporting structures for trend analysis on high OOS/lost sales Ubrand items
• GP Percentage (to be communicated with respective Buyers and Divisional Managers)
• Provide accurate and concise information regarding weekly Image Review outliers (i.e., items with highest weeks of stock, ranging and consistent supplier issues)
• Maintain Foodworld Deranged Stock Trackers
• Develop and maintain comparative analysis on sales growth (i.e. impact of inflation)
• Summary of Core Minimum Assortment (CMA) in-stock % to drive high in-stock levels
• Provide monthly Category Growth feedback per region RSA and Non-RSA
• Summary of deranged stock performance per division (trend)
• Maintain shelf-life master data file
• Measure monthly wastage per division on article level
• Monthly overview PowerPoint presentation of outliers, suggestions & recommendations.

Qualifications

• Degree or Diploma in Data Science, Computer Science, Information Technology, Information Systems / or Degree in commerce with a focus in (Accounting/Economics/Financial Management/Business management) 

Experience

• +2 years’ experience working as part of a progressive operational data team, ideally in a similar role, with proven experience developing analytics products and working with large data sets, distilling it down and shaping it in a way that informs operational improvements and decision-making 
• Knowledge and Skills
• Working knowledge of Visual Basic for Applications (VBA) in Excel, Power Query in Excel, Tableau, MS Power BI, Structured Query Language (SQL) – (essential).
• Experience applying analytical formula, modelling and trend forecasting of multiple data sources across systems – (essential).