Data Analyst - Umhlanga, South Africa - Shoprite Group

Shoprite Group
Shoprite Group
Verified Company
Umhlanga, South Africa

2 weeks ago

Thabo Mthembu

Posted by:

Thabo Mthembu

beBee Recruiter
Description
Closing Date
2023/12/1- Reference Number

SHO

  • Job Title
Data Analyst (BUYING/MARKETING)

  • Job Type
Permanent

  • Location
  • Country
South Africa

  • Location
  • Province
KwaZulu-Natal

  • Location
  • Town or City
Umhlanga

  • 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 Advert Details
  • Job Category
Marketing

  • Job Objectives
**Role Description

  • Work with business stakeholders to understand and correctly frame analysis requirements, hypotheses and questions and propose fitforpurpose 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) instock % to drive high instock 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 s
More jobs from Shoprite Group
See all jobs of Shoprite Group