Insights and Analytics Analyst

2 weeks ago


Cape Town, South Africa Shoprite Full time

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.
  • Analyst Manager

    4 weeks ago


    Cape Town, South Africa Meltwater Group Full time

    **Description** Join our team as the Manager of Media Insights & Analytics, where you will lead a group of talented analysts, guide their career development, and ensure the team's high-quality performance. As part of the management team, you will contribute to optimizing workflows, developing educational initiatives, and driving methodology innovation....

  • Data Insights Analyst

    1 month ago


    Cape Town, South Africa Recruitment Matters (Pty) Ltd Full time

    Our client is looking for a Data Insights Analyst to join their team. The primary objective of the Data Insights Analyst role within our client's coffee chain business, comprising 320 outlets, is to harness the vast transactional data using our BI Tool Qlik and POS system GAAP. The aims is to unearth actionable insights and trends that empower informed...

  • Data Insights Analyst

    1 month ago


    Cape Town, South Africa Recruitment Matters Full time

    Our client is looking for a Data Insights Analyst to join their team. The primary objective of the Data Insights Analyst role within our client's coffee chain business, comprising 320 outlets, is to harness the vast transactional data using our BI Tool Qlik and POS system GAAP. The aims is to unearth actionable insights and trends that empower informed...

  • Data Insights Analyst

    1 month ago


    Cape Town, South Africa Adzuna ZA B C2 Full time

    Our client is looking for a Data Insights Analyst to join their team. The primary objective of the Data Insights Analyst role within our client's coffee chain business, comprising 320 outlets, is to harness the vast transactional data using our BI Tool Qlik and POS system GAAP. The aims is to unearth actionable insights and trends that empower informed...

  • Data Insights Analyst

    1 month ago


    Cape Town, South Africa HR Genie Full time

    Our client is looking for a Data Insights Analyst to join their team. The primary objective of the Data Insights Analyst role within our client's coffee chain business, comprising 320 outlets, is to harness the vast transactional data using our BI Tool Qlik and POS system GAAP. The aims is to unearth actionable insights and trends that empower informed...

  • Data Insights Analyst

    3 weeks ago


    Cape Town, South Africa HR Genie Full time

    Our client is looking for a Data Insights Analyst to join their team. The primary objective of the Data Insights Analyst role within our client's coffee chain business, comprising 320 outlets, is to harness the vast transactional data using our BI Tool Qlik and POS system GAAP. The aims is to unearth actionable insights and trends that empower informed...

  • Junior Data Analyst

    1 month ago


    Cape Town, South Africa Idiro Analytics Full time

    Idiro Analytics, a European headquartered AI and analytics company is looking for a number of junior data analysts to work for our clients, who are based in Europe and N. AMerica, primarily in the following industries: retail, insurance, banking and telecoms. **Requirements**: - Perfect fluent English - Very strongt SQL skills - Experience in Tableau,...


  • Cape Town, South Africa AnyVan Ltd Full time

    AnyVan makes moving anything, anywhere easier, more affordable and greener for everyone. With Over 8 million customers across the UK and Europe since our launch over a decade ago, we’re proud to be known as the largest, fastest growing tech company in the logistics industry. Like many popular marketplaces, we’re asset light - i.e., we don’t own any...


  • Cape Town, South Africa NielsenIQ Full time

    ABOUT THIS JOB NielsenIQ works with clients to provide insights, thought leadership to drive their business and grow their portfolios. Our work helps our clients set growth strategies and determines what products you ultimately see on the shelf. Our team members are experts across various categories and are viewed as trusted partners by our...


  • Cape Town, South Africa NielsenIQ Full time

    Job Description ABOUT THIS JOB NielsenIQ works with clients to provide insights, thought leadership to drive their business and grow their portfolios. Our work helps our clients set growth strategies and determines what products you ultimately see on the shelf. Our team members are experts across various categories and are viewed as trusted partners...


  • Cape Town, South Africa TMF Group Full time

    We never ask for payment as part of our selection process, and we always contact candidates via our corporate accounts and platforms. If you are approached for payment, this is likely to be fraudulent. Please check to see whether the role you are interested in is posted here, on our website. About TMF Group TMF Group is a leading global provider of...

  • Project Manager

    4 weeks ago


    Cape Town, South Africa Meltwater Group Full time

    **Description** **Global Delivery Services Project Manager - Media Insights & Analytics** Are you looking for an exceptional opportunity to develop your analytical and project management skills while working with industry-leading clients? Join Meltwater's Professional Services team as a Global Delivery Services Project Manager, where you'll thrive in a...


  • Cape Town, South Africa NielsenIQ Full time

    Job Description (This position is exclusively for our Cape Town office, and we prefer a local candidate.) ABOUT THIS JOB NielsenIQ works with clients to provide insights, thought leadership to drive their business and grow their portfolios. Our work helps our clients set growth strategies and determines what products you ultimately see on the shelf....


  • Cape Town, South Africa AnyVan Ltd Full time

    AnyVan makes moving anything anywhere, easier, more affordable and greener for everyone. With Over 8 million customers across the UK and Europe since our launch over a decade ago, we’re proud to be known as the largest, fastest growing tech company in the logistics industry. Like many popular marketplaces, we’re asset light - i.e., we don’t own any...

  • Senior BI Analyst

    4 weeks ago


    Stellenbosch, Western Cape, South Africa Capital H Staffing and Advisory Solutions Full time

    Our client in the Banking industry is looking for Senior BI Analysts to join their fast-growing, and exciting business in Retail (Stellenbosch). The purpose of the position is to enable business to make better and faster decisions by utilising data and analytical skills to provide support to the wider Product Team, specified internal clients within the...

  • Insights Manager

    1 month ago


    Cape Town, South Africa Hire Resolve Full time

    Hire Resolve's client in the Beverage Industry is seeking a dynamic and experienced Insights Manager to join their team in the Western Cape region. The Insights Manager will be responsible for providing actionable consumer, market, and category insights to drive business growth and inform strategic decision-making. They will lead a team of analysts,...

  • Mi/data Analyst

    1 month ago


    Cape Town, South Africa TTEC Full time

    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 external sources to provide insight to decision-makers. The Reporting Analyst work...

  • Senior Media Analyst

    4 weeks ago


    Cape Town, South Africa Meltwater Full time

    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 monitoring, **Meltwater is a global leader in media intelligence and social analytics SaaS...

  • Financial Analyst

    7 days ago


    Cape Town, South Africa FROGG Recruitment Full time

    **Finance Analyst Cape Town** Our client focussed on customers is looking for a Finance Analyst in Cape Town Waterfront with 5 years experience. The person will oversee and provide support to the functional business heads which includes budgeting and forecasting submissions and the management of month-end procedures. **Salary Negotiable** **Minimum...


  • Cape Town, South Africa Acuity Consultants Full time

    Job Description This is an excellent opportunity for a SENIOR BUSINESS INTELLIGENCE ANALYST (SENIOR BI ANALYST) to join the world’s largest and fastest growing tech-enabled logistics and delivery platform, used by consumers, businesses, and international retailers. This SENIOR BI ANALYST role is based in CAPE TOWN (Hybrid-remote) and offers a...