18 Oct
Shoprite Group
Pretoria
**Purpose of the Job**:
To increase competitiveness and profitability of a product category by providing analysis, support, planning and executing the customer centric category strategy based on product assortment, pricing, promotions and product placement.
The role performs descriptive data analysis by gathering, consolidating and analysing relatively complex data and datasets to produce insights, predictions, recommendations and reports that advises stakeholders on business challenges and sales opportunities while supporting long-term trading strategies.
**Key outputs include**:
- Produce insights, predictions and recommendations
- Produce tactical and strategic reporting
- Support long-term trading strategies
- Data Gathering and Processing Responsibility
**Job Objectives**:
**1.
Produce insights, predictions and recommendations**:
- Perform analytics based on a defined set of reports, models and standards to deliver insights that supports business decision-making, addresses business or trading challenges and provides actionable solutions.
- Analyse nuances in customer profile and behaviour and make recommendations around adjustment in offer, pricing, promotions and other trade related decisions to better meet customer demands.
- Perform analysis and interpretation of performance of new projects e.g., changes in range, pricing initiatives, new products and promotions, changes in display in-store, changes in product on-shelf availability.
- Proactively support buyers with robust data that informs pricing and promotional performance.
- Integrate various data sources to unlock and realise sales opportunities e.g., data from other departments, local census.
- Implement a statistically sound and consistent approach to measuring the effectiveness of proposed pricing strategies within the department.
**2.
Produce tactical and strategic reporting**:
- Deliver predefined reports to support business activities e.g., preparation for supplier performance reviews, pricing reviews, promotional planning and performance and sales analysis.
- Integrate reports with sound recommendations based on fact-based scenarios.
- Prepare for weekly management meetings on critical data related issues and departmental KPIs.
- Produce integrated reports including sales and profitability performance reports, competitor pricing and merchandising reports and other general reports as the business need rises.
**3.
**Support long-term trading strategies**:
- Support long-term strategy level decisions using customer science techniques.
- Collect and interpret initiatives proposed in annual category reviews and thoroughly brief relevant buyers on insights prior to supplier meetings.
- Support buyers with the preparation of annual category strategies by reporting performance on key initiatives.
- Collaborate with cross functional teams, leveraging successful initiatives, findings and analytics techniques to benefit the broader national team.
**4.
Data Gathering and processing Responsibility**
- Converting raw data into meaningful insights and Reports
**Qualifications**:
**Essential**:
- Bachelor's degree in commerce with a focus in (Statistics,
Accounting/Economics/Financial Management/Business management)/Diploma in Information systems or similar.
**Experience**:
**Essential**:
**Knowledge and Skills**:
**Essential Knowledge and Skills**:
- Understanding the Data Analysis Process.
- Strong analytical and conceptual thinking skills.
- Ability to relay insights in plain language, such that these can be used to inform business decisions.
- Excellent problem solving skills.
- High critical thinking skills.
- Strong work ethic.
- Excellent English communication skills - verbal and written.
- Strong proficiency with MS Office 365 with an Advanced level of Excel skills.
**Desirable Knowledge and Skills**:
- Exposure to SAP Buying / Retail Systems
- R or Python Programming
- Working knowledge of Visual Basic for Applications (VBA) in Excel, Power Query in Excel, Tableau, MS Power BI, Structured Query Language (SQL)
▶️ Junior Data Analyst
🖊️ Shoprite Group
📍 Pretoria