Jobs
>
Cape Town

    Insights and Analytics Analyst - Cape Town, South Africa - Shoprite

    Default job background
    Permanent
    Description

    Purpose of the Job

    The purpose of the Insights and Analytics Analyst role is to leverage Medirite Healthcare'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 modeling, 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 into 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 timely 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 CategoryRetail 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.
  • Collaborate with business, technology, and development teams to agree on the appropriate data and application of analytical techniques to generate valuable 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.
  • Assess the accuracy of data sources and data gathering techniques, and ensure that data quality and integrity are 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 the promotion period to minimize high OOS percentages.
  • Create and maintain an OOS dashboard to highlight items with a consistently 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 category.
  • Monthly overview PowerPoint presentation of outliers, suggestions, and recommendations.
  • Compile reporting and feedback for the monthly executive meeting.
  • Report on price surveys and highlight gaps and opportunities in 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 the store universe and within categories.
  • Qualifications

    Essential:

  • 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

    Essential:

  • +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.
  • Working knowledge of Visual Basic for Applications (VBA) in Excel, Power Query in Excel, Tableau, MS Power BI, Structured Query Language (SQL).
  • Experience applying analytical formulas, modelling and trend forecasting of multiple data sources across systems
  • Desirable:

  • Experience in retail
  • Knowledge and Skills

    Essential Knowledge and Skills:

  • 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.
  • 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 with 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 .
  • Exposure to SAP Buying / Retail Systems.

  • PepsiCo

    Analytics Analyst

    5 hours ago


    PepsiCo Cape Town, South Africa

    Overview: · **We are PepsiCo** · PepsiCo is proud to be one of the world's leading food and beverage companies. Every day, we are dedicated to bringing our mission to create more smiles with every sip and every bite to life. Our products are enjoyed more than one billion times a ...


  • Guardian Recruiting Cape Town, South Africa

    **_Job Specification_** · Purpose of this job is to provide portfolio analytics and other supporting analysis in relation to institutional client portfolios and within the relevant regulatory frameworks · Retrieve, validate, reconcile, analyse, and prepare data for monthly, quart ...


  • Yoco Cape Town, South Africa

    Yoco was founded in 2015, and we've been breaking down barriers, unlocking economic opportunities and opening commerce for people to thrive ever since. · We're the payments provider for over self-employed, and we process over US$2 billion annually. · We have ±350 team members glo ...


  • CSG Cape Town, South Africa

    Hi, I'm · - Zandile Vanqa · , your Recruiter and guide to joining CSG. At CSG, you're more than your resume. We want your diverse perspective and unique background to help us enrich the work we do together. We believe that by channeling the power of all, we make ordinary customer ...


  • Santam Bellville, South Africa

    What will you do? · Santam's Actuarial and Data Analytics team has an exciting new opportunity available for a general insurance professional. The position will be based at Santam's Head Office in Bellville, Cape Town. What will make you successful in this role? · **KEY ACCOUNTAB ...


  • CSG Cape Town, South Africa Full time

    Hi, I'm Zandile Vanqa, your Recruiter and guide to joining CSG. At CSG, you're more than your resume. We want your diverse perspective and unique background to help us enrich the work we do together. We believe that by channeling the power of all, we make ordinary customer and em ...

  • Clockwork Media

    Data Analyst

    5 days ago


    Clockwork Media Cape Town, South Africa

    If your numerical abilities are off the charts (see what we did there?), or you were a proud mathlete at school, we want you But mostly your brain. Clockwork is looking for a Data Analyst to join our dynamic team. · Our new Data Analyst will develop analysis and reporting capabil ...

  • TTEC

    Mi/data Analyst

    4 days ago


    TTEC Cape Town, South Africa

    MI/Data Analyst · Reporting Analyst · **Responsibilities**: · The Reporting Analyst is fully dedicated to and receives work from the Retail Contact Center Business Intelligence (RCC BI) team. The role solves complex business problems and issues using data from internal and extern ...


  • Meltwater Cape Town, South Africa

    Senior Media Analyst · - Applications are considered on a rolling basis · - Cape Town**We are looking for a talented Media Analyst to join our growing team in our beautiful Cape Town location** · **Who are we?** · With 20 years of experience in the field of online media monitorin ...


  • SUMMIT Africa Recruitment Cape Town, South Africa

    We have an opportunity for a Senior Decision Support Analyst to join our Decision Support team. The purpose of the Senior Decision Support Analyst is to drive business value to our internal and external stakeholders, in order to optimize business decisions and processes, as well ...

  • APS Resources

    Commodity Analyst

    6 days ago


    APS Resources Cape Town, South Africa

    We are looking for a Commodity Analyst (Coal) for the relocation to Dubai. · The role is open at a leading coal mining company. · **Responsibilities**: · - Analysis of the international coal market; · - Formation of conclusions and recommendations for business based on data array ...

  • RPO Recruitment

    Data Analyst

    4 days ago


    RPO Recruitment Cape Town, South Africa

    Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design. Data analysts will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to identify improvements. · **Resp ...

  • Dash BPO

    Reporting Analyst

    1 week ago


    Dash BPO Cape Town, South Africa

    **Reporting Analyst/Specialist** · Focuses on the creation, maintenance, and automation of organizational reports. · The Reporting Analyst/Specialist focuses on the development, maintenance, and optimization of business reports. This role involves ensuring the accuracy and timeli ...


  • HotelJobs Cape Town, South Africa

    **Loyalty Campaign Manager** · **Food Service Industry - **Western Cape** · **R45 000 CTC** · **A new position as Loyalty Campaign Manager / Customer Business Analyst has become available within this established restaurant group boasting a portfolio of cool, casual dining outlets ...

  • Elchemie

    Laboratory Analyst

    1 week ago


    Elchemie Cape Town, South Africa

    **Water Treatment company based in Cape Town region, has a vacancy for a Laboratory Analyst. Diploma in Analytical Chemistry or similar and a minimum of 1-3 years' experience in Laboratory environment preferably an accredited water/ wastewater analysis laboratory.** · **The role ...


  • Genii Analytics (Pty) Ltd Cape Town, South Africa

    Monitor & Analyse transactions for assigned client programs · - Use appropriate forms and definitions for assigned programs · - Use analytics monitoring tools, systems, and processes as directed · - Maintain knowledge and understanding of assigned client program's products and pr ...


  • Panthera Cape Town, South Africa

    Role: Counter Wildlife Crime Regional Analyst · Employment: One year contract (renewable) · Work station: Cape Town with travel to focal project sites in southern Africa · **The Organization** · Founded in 2006, Panthera is devoted to the conservation of the world's 40 species of ...

  • CDW

    Tester, Data

    1 day ago


    CDW Cape Town, South Africa

    **Description** · **BACKGROUND** · CDW has a mission to become the leading B2B integrated technology solutions provider in the markets that we serve. Enabling, supporting and accelerating our ambitious plans to grow from a £1.35bn business to £5bn by 2025 requires a major program ...


  • LRI Invest Cape Town, South Africa

    · L2 SOC/Security Analyst Cape Town · Summary of the position · Outline of main duties and responsibilities · The main responsibilities of the role will be: · - Correlating data from various sources to assess the impact on critical systems or data sets. · - Providing guidance on ...

  • Teleroi

    Data Analyst

    1 week ago


    Teleroi Cape Town, South Africa

    We are excited to announce a new job vacancy for the position of Data Analyst at Teleroi. As a data analyst, you will be responsible for collecting, processing, and performing statistical analyses on large datasets. The role involves interpreting data, identifying trends, and pre ...