Job Description

Closing Date 2025/09/22


Reference Number SHO250915-5


Job Title Data Analyst II


Job Type Permanent


Location - Country South Africa


Location - Province Gauteng


Location - Town or City Pretoria


Purpose of the Job

Purpose of the Job

To drive the competitiveness and profitability of a product category through comprehensive analysis, strategic support, and the execution of customer-centric category strategies, focusing on product assortment, pricing, promotions, and placement. This role encompasses advanced data analysis, leveraging complex datasets to generate actionable insights, predictions, and recommendations. The Senior Data Analyst II will also oversee a team of analysts, guiding them in delivering high-quality analysis and reporting that addresses business challenges and capitalizes on sales opportunities, while aligning with long-term trading strategies.

Key Outputs

Deliver impactful insights, predictions, and recommendations. Drive the development and implementation of long-term trading strategies Produce tactical and strategic reporting to support decision-making.




Job Advert Details


Job Category Retail


Job Objectives

Produce Insights, Predictions, and Recommendations:

+ Analyze customer profiles and behaviors, making informed recommendations for adjustments in offers, pricing, promotions, and trade-related decisions to enhance customer satisfaction and sales.
+ Evaluate and interpret the performance of new initiatives, including product range changes, pricing strategies, new product launches, and promotional effectiveness.
+ Provide proactive, data-driven support to buyers, equipping them with robust insights to inform pricing and promotional strategies.

Produce Tactical and Strategic Reporting:

+ Integrate reports with actionable recommendations based on fact-driven scenarios, ensuring stakeholders are well-informed.
+ Prepare and present critical data insights during weekly management meetings, focusing on departmental KPIs and ongoing data-related challenges
+ Generate integrated reports that encompass sales and profitability performance, competitor analysis, and merchandising insights, responding to evolving business needs.
+

Support Long-term Trading Strategies:

+ Collaborate with stakeholders to collect and interpret insights from annual category reviews, briefing relevant buyers prior to supplier meetings.
+ Support the development of annual category strategies by reporting on key initiatives' performance and effectiveness.


Qualifications

Essential:

Bachelor's degree in Commerce or a related field, with a focus in Statistics, Accounting, Economics, Financial Management, or Business Management.

Desirable:

+ Data analytics certification (e.g., Certified Analytics Professional).







Experience

Essential:

3-5+ years of experience as a Data Analyst or in a similar analytical role within a business environment. Proven track record of managing teams (2+ years) and delivering impactful analytics that informs pricing, promotional, merchandising, and trading decisions.


Knowledge and Skills

Essential Knowledge and Skills:

Strong financial and business acumen with a comprehensive understanding of data application in a retail trading environment. Proficient understanding of the Data Analysis Process and advanced analytical methodologies. Exceptional analytical and conceptual thinking skills, with the ability to simplify complex insights for business application. Advanced problem-solving capabilities and high critical thinking skills. Strong work ethic, demonstrating initiative and accountability. Excellent verbal and written communication skills in English, facilitating effective stakeholder engagement. Advanced proficiency in MS Office 365, particularly Excel, with strong mathematical skills. Working knowledge of data analysis tools such as VBA in Excel, Power Query, Tableau, MS Power BI, and SQL.

Desirable Knowledge and Skills:

Familiarity with pharmaceutical products and front shop operations. Experience with SAP Buying/Retail Systems. Proficiency in programming languages such as R or Python.


To drive the competitiveness and profitability of a product category through comprehensive analysis, strategic support, and the execution of customer-centric category strategies, focusing on product assortment, pricing, promotions, and placement. This role encompasses advanced data analysis, leveraging complex datasets to generate actionable insights, predictions, and recommendations. The Senior Data Analyst II will also oversee a team of analysts, guiding them in delivering high-quality analysis and reporting that addresses business challenges and capitalizes on sales opportunities, while aligning with long-term trading strategies.

Key Outputs

Deliver impactful insights, predictions, and recommendations. Drive the development and implementation of long-term trading strategies Produce tactical and strategic reporting to support decision-making.
", "datePosted":"2025-09-15", "validThrough":"2025-09-22", "identifier":{ "@type":"PropertyValue", "name":"Shoprite Group", "value":"SHO250915-5" }, "hiringOrganization":{ "@type":"Organization", "name":"Shoprite Group", "sameAs":"https://shoprite.erecruit.co/candidateapp/?source=GoogleJobs" }, "jobLocation":{ "@type":"Place", "address":{ "@type":"PostalAddress", "addressLocality":"Pretoria", "addressRegion":"", "addressCountry":"" } } }