Job Description

Job Details
Closing Date 2024/02/14
Reference Number SHO240131-3
Job Title Data Analyst (BUYING/MARKETING)
Job Type Permanent
Location - Country South Africa
Location - Province KwaZulu-Natal
Location - Town or City Umhlanga, KwaZulu Natal
Purpose of the Job

Role Purpose

The purpose of the Data Analyst role is to leverage Shoprites 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.

"Our Group and all its operating companies are committed to creating, embracing, and preserving a diverse workplace that values the unique talents, perspectives, backgrounds, and abilities that enrich our organisation. A place where everyone matters and feels included."

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 fit-for-purpose data led solutions.

• Work with business, technology and development teams and agree on the right data and application of the right analytical techniques to produce the right business insights.

• 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).

• Experience applying analytical formula, modelling and trend forecasting of multiple data sources across systems - (essential).

Knowledge and Skills

Key competencies and work ethic

• Strong analytical thinking skills and highly numerate - Collect, organise, and assimilate disparate, multiple, and complex pieces of data to draw sound conclusions and arrive at optimal solutions.

• Passion and excitement for retail and related data, new technologies and solutions and their range of possibilities, applications, and value for?the?

• High level of self-motivation and drive to meet and exceed goals and expectations. Able to work independently and use own initiative to deal with challenges across a range of problem-solving challenges as and when they arise.

• Detailed, organised and quality focused - Has an affinity for detail, structure and efficiency, balancing planning, and execution.?

• Strong communication and presentation skills - Explain and simplify complex technical concepts and compile visual reports that tell a concise and compelling story.

• Team player and collaborative partner.

• Ability to work under pressure and under tight time constraints, efficiently prioritising workloads, balancing multiple and competing priorities and demands and managing time effectively in a high-volume, fast-moving environment.??

• Is curious and open to learning with a strong interest in data, discovery and trying new ideas.

Shoprite Holdings