Data Analyst

**Purpose of the Job**:
**Role Purpose***

The purpose of the **Data Analyst **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.

**The role aims to improve efficiency and processes and assist in recommending solutions to problems, the role seeks to provide full support to the buying and marketing team in terms of providing proactive data analytics that support marketing and buying analysis taking accountability for providing timeous recommendations.**

**Job Objectives**:
**Role Description**
- 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 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.
- Stay updated on product and consumer trends to provide valuable insights to the buying community

**Specific Inputs**
- Weekly tracking of deranged stock to aggressively drive reduction of deranged stock
- Identify & track high promotional OOS (out of stock) items daily during promotion period to minimize high OOS percentages
- Create and maintain OOS dashboard to highlight items with a consistent high OOS
- Develop reporting structures for trend analysis on high OOS/lost sales categories and articles
- 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 weekly and monthly Category Growth feedback
- Summary of deranged stock performance per division (trend) and buyer
- Monthly overview PowerPoint presentation of outliers, suggestions & recommendations.
- Compile reporting and feedback for the monthly executive meeting
- Report on Price surveys and highlight gaps and opportunities on pricing, consolidate and track with buying
- Post promotional performance analysis
- Analyse market share data to identify strengths, weaknesses, opportunities and threats and present buying with findings and insightful observations
- Mine available data through xtra savings and Rex platforms to present buyers with compelling findings and insights
- Analyse and present buying with ranging gaps and opportunities
- Measure and report on buying key objectives and metrics
- Measure and report on key customer data to provide buying with valuable insights on basket growths and customer migration within store universe and within categories

**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) - (essential).

**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 - (essential).
- Working knowledge of Visual Basic for Applications (VBA) in Excel, Power Query in Excel, Tableau, MS Power BI, Structured Query Language (SQL) - (essential).