Data Analyst I

Shoprite Group; Pretoria; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A leading retail company in Pretoria seeks a Data Analyst I to support data-driven decision-making. The role focuses on gathering and analyzing complex datasets to generate insights that inform pricing strategies and promotional activities. The ideal candidate will hold a relevant Bachelor’s degree and have 2 years of analytical experience. Key responsibilities include delivering strategic reports, assessing project performances, and preparing data for management meetings, ensuring robust analysis supports business success.

Qualifications

• 2 years of experience as a Data Analyst or in a similar role within a business environment.
• Proven ability to analyze large datasets to inform pricing and promotional decisions.

Responsibilities

• Generate insights and actionable recommendations from complex datasets.
• Assess new projects' performance and inform buyers.
• Deliver reports supporting various business operations.

Skills

Strong analytical and conceptual thinking abilities

Excellent problem-solving skills

Proficient in English, both verbal and written

Financial and business acumen

Education

Bachelor’s degree in a relevant field (BCom, BSc) or a certification in Data Analytics

Tools

Tableau

MS Power BI

SAP Buying/Retail Systems

Power Query for Excel

VBA

SQL

R or Python

Job description

Overview

Data Analyst I performs descriptive data analysis by gathering, consolidating, and analyzing complex datasets to generate insights, predictions, and recommendations. This role supports a customer-centric category strategy focused on product assortment, pricing, promotions, and placement, and advises stakeholders on business challenges and sales opportunities while supporting long-term trading strategies.

Key Outputs

• Generate insights, predictions, and actionable recommendations.
• Produce tactical and strategic reports to support business activities.
• Contribute to the development and execution of long-term trading strategies.

Job Advert Details

Job Category: Retail

Job Objectives

• Provide buyers with robust data to inform pricing and promotional performance.
• Assess the performance of new projects, including changes in product range, pricing initiatives, promotions, and in-store displays.
• Deliver predefined reports to support business operations, including supplier performance reviews, pricing reviews, promotional planning, and sales analysis.
• Prepare data for weekly management meetings, focusing on critical issues and departmental KPIs.
• Collect and interpret initiatives from annual category reviews, briefing relevant buyers on insights prior to supplier meetings.

Qualifications

Bachelor’s degree in a relevant field (BCom, BSc) or a certification in Data Analytics.

Experience

• 2 years of experience as a Data Analyst or in a similar role within a business environment.
• Proven ability to apply research and analytical methods within large datasets to identify trends and purchasing behavior that inform pricing, promotional, merchandising, and trading decisions.

Knowledge and Skills

• Strong analytical and conceptual thinking abilities.
• Capacity to communicate insights clearly to inform business decisions.
• Excellent problem-solving skills and critical thinking.
• Strong work ethic and attention to detail.
• Proficient in English, both verbal and written.
• Financial and business acumen with a solid understanding of data utilization in retail trading.

Desirable Knowledge and Skills

• Knowledge of pharmaceutical products and front shop operations.
• Familiarity with SAP Buying/Retail Systems.
• Experience with Tableau or MS Power BI.
• Proficiency in Power Query for Excel, Visual Basic for Applications (VBA), Structured Query Language (SQL), and programming languages like R or Python.