Operational Data Analyst

5 months ago


Brackenfell, South Africa Shoprite Group Full time

**Purpose of the Job**:
The purpose of the **Operational Data Analyst USAVE** 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.

**Job Objectives**:

- Work with business stakeholders to understand and correctly frame analysis requirements, hypotheses and questions and propose fit-for-purpose 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 spend 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.

**USAVE specific inputs**
- Daily tracking of deranged stock of highest value stores to aggressively drive reduction of deranged stock
- Daily analysis of MPS (minimum presentation stock) vs ROS (rate of sales) on store level in conjunction with Store Replenisher.
- Identify & track high promotional OOS (out of stock) items daily during promotion period to minimize high OOS percentages
- Create and maintain daily GP (gross profit) tracker on Foods & Non-foods. High level investigation required to identify outliers
- Daily updates on high-risk expiry items on store level
- Create and maintain OOS dashboard to highlight items with a consistent high OOS
- Develop reporting structures for trend analysis on high OOS/lost sales Ubrand items
- GP Percentage (to be communicated with respective Buyers and Divisional Managers)
- Provide accurate and concise information regarding weekly Image Review outliers (i.e., items with highest weeks of stock, ranging and consistent supplier issues)
- Maintain Foodworld Deranged Stock Trackers
- 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 monthly Category Growth feedback per region RSA and Non-RSA
- Summary of deranged stock performance per division (trend)
- Maintain shelf-life master data file
- Measure monthly wastage per division on article level

Monthly overview PowerPoint presentation of outliers, suggestions & recommendations.

**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)

**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

**Knowledge and Skills**:

- Working knowledge of Visual Basic for Applications (VBA) in Excel, Power Query in Excel, Tableau, MS Power BI, Structured Query Language (SQL) - (essential).

**Applicant Feedback Policy**:


  • Risk Data Analyst

    5 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The Risk Data Analyst I is an entry-level position within the Enterprise Risk Management (ERM) department. This role involves supporting the collection, analysis, and reporting of risk-related data. The analyst will assist in maintaining data accuracy and integrity, performing routine data processing tasks, and supporting senior...

  • Data Analyst I

    5 months ago


    Brackenfell, South Africa ShopriteX Full time

    **About the Team** ShopriteX was established to accelerate the use of data to improve customer experience and business operations. Our Agile way of working allows for flexibility to grasp new opportunities and quickly transform them into insights that will have a direct impact on strategic initiatives. The Insights & Data Monetisation Tribe harnesses big...

  • Data Analyst I

    5 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Data Analyst role is to perform and build analysis of pricing developments and offerings and translate these into meaningful analytics and actionable insights to support the category management team meet its commercial and revenue goals and targets. The role gathers, consolidates and analyses relatively complex...

  • Data BI Analyst

    5 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Data BI Analyst(People) role is to leverage Shoprite’s rich People (HR) data assets to provide actionable trends and insights that enable business to make sound people orientated decisions. The role works collaboratively in a cross-functional, agile team, executing a variety of complex data analytics projects,...

  • Functional Analyst

    5 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: Performing assigned gap analysis to determine and understand the functional business requirements and changes as defined by the Business Analysts, Product Owners and other stakeholders. Identify problem areas, measure various areas of performance, propose changes and develop process improvement initiatives. Perform...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The Store Replenishment Analyst will assist in analyzing data to provide integrated and accurate feedback to enable the replenishment function ensure stock availability for customers. The Analyst will also maintain store replenishment parameters to create accurate store orders and support store operations with regards to all inventory...

  • Functional Analyst I

    5 months ago


    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: Performing assigned gap analysis to determine and understand the functional business requirements and changes as defined by the Business Analysts, Product Owners and other stakeholders. Identify problem areas, measure various areas of performance, propose changes and develop process improvement initiatives. Perform...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Data Administrator is to provide data administrative services to the enterprise by verifying the validity of helpdesk requests and accurately capturing and updating, master data in line with Shoprite standards to ensure a seamless flow of accurate data and maintain data quality. The role centralises the...

  • Lead BI Analyst

    6 months ago


    Brackenfell, South Africa ShopriteX Full time

    **Value Proposition** At ShopriteX we're re-imagining retail, removing friction for our customers' shopping experience, and driving a tech-led future for the biggest retailer in Africa. We're looking for talented minds to join our team in Cape Town. So, if you're enthusiastic about retail, working in a creative environment with a truly customer-first...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The Principal Data Science Lead is responsible for providing strategic input in the data science capability to unlock value through actionable insights to support decision-making across Shoprite Group. Your primary objective will be to implement best practice knowledge, methodologies, fit-for-purpose tools, and ways of work across the...

  • Product Owner

    5 months ago


    Brackenfell, South Africa ShopriteX Full time

    **Role Purpose** The role of the Product Owner: Data and Analytics Products at ShopriteX is to own and manage the entire lifecycle of data products, ensuring the creation of valuable, sustainable, and reusable solutions that meet the needs and expectations of customers and/or stakeholders. This role involves collaborating closely with Squad Leads and...


  • Brackenfell, South Africa Divergent Recruit Full time

    **JOB ALERT - NEW PERMANENT VACANCY!!!** **POSITION: STORE REPLENISHMENT ANALYST (DRY GOODS FMCG / RETAIL)** **LOCATION: BRACKENFELL, CAPE TOWN** **MINIMUM ESSENTIAL QUALIFICATIONS**: - Matric - B. Comm Degree in Business Sciences / Logistics, Supply Chain - Minimum of 3 years’ post qualification working experience in Replenishment / Supply Chain in...

  • Senior Data Scientist

    5 months ago


    Brackenfell, South Africa ShopriteX Full time

    **Role Purpose** **Role Description** - Contribute towards the development of Shoprite IT's data strategy to deliver best-in-class analytics across the organisation. - Work with business stakeholders to identify business requirements and model and frame business scenarios that are meaningful and which impact on critical business processes and/or...

  • Lead Data Scientist

    5 months ago


    Brackenfell, South Africa ShopriteX Full time

    **Role Purpose** Shoprite, Africa's largest retailer, is on a mission to revolutionize the retail landscape through its digital innovation unit, ShopriteX. Our Data Ecosystems Team is leveraging an ecosystem of partners focused on harnessing the power of data to unlock new possibilities for financial inclusion and improved healthcare. As the **Lead Data...

  • Lead Data Scientist

    2 months ago


    Brackenfell, South Africa ShopriteX Full time

    **Role Purpose** Shoprite, Africa's largest retailer, is on a mission to revolutionize the retail landscape through its digital innovation unit, ShopriteX. Our Data Ecosystems Team is leveraging an ecosystem of partners focused on harnessing the power of data to unlock new possibilities for financial inclusion and improved healthcare. As the **Lead Data...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: - The Application Specialist’s primary responsibility is to have a specialised knowledge of the system(s) in order to troubleshoot issues, working closely with project teams; functional teams and vendors. - The Application Specialist should be able to coordinate testing and perform quality assurance on the data and validate the...


  • Brackenfell, South Africa ShopriteX Full time

    **Role Purpose** The purpose of this role is to define and implement strategies that align with marketing and business objectives, by: - Producing meaningful digital marketing KPI dashboards - Delivering monthly cross channel performance reports with actionable insights - Be a source of expertise in digital conversion optimisation for both marketing and...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Reward Solutions Analyst role is to work with high volumes of reward and employee related data to create financial costing models using reward, employee and other business data to support reward and organisational effectiveness (OE) business case formulation and forecasting models. The role provides detailed...


  • Brackenfell, South Africa Divergent Recruit Full time

    **JOB ALERT - NEW PERMANENT VACANCY!!!** **STORE REPLENISHMENT ANALYST - (DRY GOODS FMCG / RETAIL)** **BRACKENFELL, CAPE TOWN, WESTERN CAPE PROVINCE** **MINIMUM ESSENTIAL QUALIFICATIONS**: - Matric - B. Comm Degree in Business Sciences, Logistics or Supply Chain **(ESSENTIAL)** - Minimum of 3 years’ post qualification working experience in...


  • Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Data Administration Team lead role is to provide operational and administrative support to the Data Management function through the execution of data processing operations including executing data inputting on various systems, prioritisation of business requests, resolving complex data scenarios and providing...