Operational Data Analyst

**Purpose of the Job**:
The purpose of the **Operational Data Analyst USAVE** role is to leverage Shoprite’s rich data assets to provide actionable trends and insights that enable business to make sound decisions. The role works collaboratively in a cross-functional, agile team, executing a variety of complex data analytics projects, including modelling, and framing of business scenarios to solve analytical problems, performing experimental design approaches to validate findings or test hypotheses, depicting, and presenting the rationale of findings in easy-to-understand terms for business and providing consolidated business reports and dashboards. The Data Analyst is a critical thinker who applies their technical, analytical and communication skills to infer meaning from data and translate these in a concise, cohesive, and engaging story.

**Job Objectives**:

- Work with business stakeholders to understand and correctly frame analysis requirements, hypotheses and questions and propose fit-for-purpose data led solutions.
- 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).

**Applicant Feedback Policy**: