Data Analyst I

3 weeks ago

Brackenfell, Western Cape, 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, technology and advanced analytics to derive revenue from customer insights.


It is made up of three squads:
Assortment & Customer Intelligence, Pricing & Promotions and Supplier Insights.

Some highlights of the Tribe duties include developing customer centric analytics products and insights, building recommendation models to ensure we have the correct product offering, evaluating the end-to-end effectiveness of promotions to reduce sales dilutive promotions and identifying key value items driving brand price perception to maintain price leadership.​ As a data analyst you must be curious, enjoy digging into data to unearth insights and be passionate about the value this can add.

Willing to take initiative, expand on new responsibilities and empower yourself with new skills and techniques as you grow with the team.

This is an exciting opportunity and will be a close and collaborative journey with the IDM Tribe to develop your technical skills and grow into an advanced analytics role.

​ Role Purpose The purpose of the Data Analyst role is to leverage Shoprite's rich customer and transactional retail data assets to provide actionable trends and insights that enables business to make sound commercial 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 metrics.

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.

Role Description Query large data sets and develop data tables Transforming data science outputs into consumable business output Transforming data into a story and presenting findings to business partners Reworking data and performing data cleansing ensuring integrity and usability Capacity to foster a healthy, stimulating work environment that frequently harnesses teamwork Value measurements of products (products are pieces of work delivered to business) Use Alteryx & VBA (or similar tools) to provide insights (rework data, and build logic recommendation models etc) Build, update & maintain use case driven Tableau dashboards to answer business questions Interacting with stakeholder to determine requirements, value & how reports will be used Presenting methodologies to business partners for sign off Qualifications and experience Degree or Diploma in Data Science, Computer Science, Information Technology, Information Systems or a related field Essential 2 years experience using SQLShould be able to join different data sets, understand how to bring together data on different data grains.

2-4 years Advanced Excel (pivot table is, h/vlookups, Index Match)Have built a dashboard using form controls in Excel or used a visualisation tool like Tableau/PowerBI/Qlikview to build insightful dashboards Advantageous but not required Alteryx / Knime (advantageous) Cloud Platform / AWS EMR (advantageous) AWS Athena or Zeppelin/Jupyter notebooks (advantageous)

  • Strong proficiency in MS Word with an advanced level of Excel skill Desired Knowledge of AWS cloud computing based solutions (Python / PySpark)Experience working in an agile environment Experience working with retailer specific data (e.g. brand, customer, shopper, category, sales, promotions, pricing, channel, POS, payment / tender, store, stock and supply chain data) Alteryx / Knime (advantageous) AWS Athena or Zeppelin/Jupyter notebooks (advantageous) Key competencies and work ethic Strong analytical thinking skills and highly numerate – Able to collect, organise and assimilate disparate, multiple and complex pieces of data to draw sound conclusions and arrive at optimal solutions. Able to dig deep to reach the right metrics that can be optimised Passion and excitement for data, new technologies and solutions and its range of possibilities, applications and value for the business and customers High level of self-motivation and drive to meet and exceed on 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. Is diligent and vigilantly watches over tasks, processes, and outputs to ensure accuracy while independently actioning and correcting any quality concerns Strong communication and presentation skills – Ability to communicate effectively both verbally and in writing. Able to explain and simply complex technical concepts and confidently engage with and discuss concepts with stakeholders. Able to compile visual reports that tells a concise and compelling story Team player and collaborative partner
  • Works effectively across functions and as part of a multi disciplinary team.
Is collaborative and able to build sound, professional relationships with internal and external stakeholders. Supports and mentors junior team members 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. Curious about exploring and answering business analytics questions Business acumen – Understands business principles in the digital environment and what is required to drive success Our Group is 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. We are committed to Employment Equity when recruiting internally and externally. Please take note that by responding to this application and providing your personal information, you confirm your express and informed consent for Shoprite Checkers (Pty) Ltd and all its subsidiaries and affiliates companies to process your personal information for the Company to consider your application for this position. All Personal Information which you provide to the Company will be used and/or retained only for the purposes for which it is collected, whereafter it will be permanently destroyed. Your information is only retained if it is required by law or where you have given consent to us to retain such information for an extended period. If you don't hear from us within 14 days, please consider your application unsuccessful. Any personal information collected as part of your application will be destroyed, securely, in accordance with South African legislation.

  • Functional Analyst I

    4 weeks 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...

  • Data Governance Analyst Ii

    1 month ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/03/29 - Reference Number SHO230322-4 - Job Title Data Governance Analyst II - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job The purpose of the Data Governance Analyst II role is to ensure that efficient and cost-effective data...

  • Data Governance Analyst Ii

    1 month ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Data Governance Analyst II role is to ensure that efficient and cost-effective data solutions and processes are in place to address current to long term (>1 year) business data needs/requirements. Data-led business decisions in this space will come to fruition within 1-3 years. The role strategises and facilitates...

  • Senior BI Analyst

    1 month ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The Business Intelligence Analyst plays two distinct roles: that of business analyst, responsible for translating Business Intelligence requirements into high-quality technical implementations; and that of data analyst, where they are expert users of BI tools and data. Through systematic and methodical investigation, analysis and...

  • SAP Functional Analyst

    1 month ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: Analyse and understand the functional business requirements as defined by the Business Analysts, owners, and other stakeholders. Understand the retail domain and applicable context of various business requirements specifications in relation to the specific SAP systems and operational processes. Review SAP technical...

  • Senior BI Analyst

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/04/27 - Reference Number SHO230420-4 - Job Title Senior BI Analyst - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job The Business Intelligence Analyst plays two distinct roles: that of business analyst, responsible for translating...

  • Junior Reward Analyst

    1 month ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2024/02/29 - Reference Number SHO240222-1 - Job Title Junior Reward Analyst - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job The Junior Rewards Analyst contributes to the Group Rewards Solutions team by providing essential support...

  • Product Owner

    4 weeks 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...

  • Senior Data Scientist

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: Contribute towards the development of Shoprite People Team’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...

  • Senior Data Scientist

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/03/04 - Reference Number SHO230225-1 - Job Title Senior Data Scientist (People) - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job - Job Advert Details - Job Category Human Resources - Job Objectives Contribute towards the...

  • Business System Support Analyst

    4 weeks ago

    Brackenfell, South Africa Adzuna ZA B C2 Full time

    Join a dynamic team as a Business System Support Analyst, where you'll be instrumental in ensuring the seamless operation and support of our Fusion CTRM system and its users. Your role will encompass technical solution creation, from design to testing, as well as end-user support and process enhancement.Duties & Responsibilities:Provide timely and...

  • Business System Support Analyst

    3 weeks ago

    Brackenfell, South Africa Frank Consult Full time

    Join a dynamic team as a Business System Support Analyst, where you'll be instrumental in ensuring the seamless operation and support of our Fusion CTRM system and its users. Your role will encompass technical solution creation, from design to testing, as well as end-user support and process enhancement. Duties & Responsibilities: Provide timely and...

  • Administration Clerk I

    4 weeks ago

    Brackenfell, South Africa Unitrans Recruitment Full time

    **Job Advert Summary**: **Minimum Requirements**: - Matric - A relevant tertiary qualification will be an advantage - 1-3 years Administration experience - Computer literate - MS office with intermediate to advanced excel skills - Strong administrative skills - Excellent communication skills - Reliable and dependent - Able to work under pressure - Must be...

  • Domain Architect I

    4 weeks ago

    Brackenfell, South Africa Disruptive IT Full time

    **PURPOSE OF THE JOB** As a recognized Integration authority the Integration Architect collaborates on Integration standards & controls and creates robust integration architectures in support thereof and leads the realization of the integration architecture into the target environments to deliver interfaces between systems. **JOB OBJECTIVES** - Lead and...

  • Tableau Administrator

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2024/02/02 - Reference Number SHO240126-2 - Job Title Tableau Administrator - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job - Job Advert Details - Job Category IT - Job Objectives - Monitor Tableau Server performance, capacity, and...

  • Solutions Architect Ii

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/12/18 - Reference Number SHO231204-3 - Job Title Solutions Architect II - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job As a recognized data engineering authority the Solution Architect collaborates in data engineering standards...

  • Solutions Architect Ii

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: As a recognized data engineering authority the Solution Architect collaborates in data engineering standards & controls and creates the data engineering architecture for the target environments to deliver data pipelines into the bigger Business Intelligence environments. The solution architect will collaborate closely with the data,...

  • Intermediate Analytics Engineer

    2 weeks ago

    Brackenfell, South Africa ShopriteX Full time

    Role Purpose   The Intermediate Analytics Engineer is an emerging data professional who will kick start their careers as part of the the analytics engineering team to build robust, integrated and efficient data products that delivers best-in-class use case led analytics across the organisation. The role works with a senior or lead analytics...

  • Executive Projects Officer

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2024/02/05 - Reference Number SHO240129-2 - Job Title Executive Projects Officer - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job The purpose of the Executive Projects Officer is to deliver operational enablement services and execution...

  • Product Manager: Reporting Assets

    1 month ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Product Manager II role is to drive the building of products that meet customer needs over the product-market lifecycle, by defining the roadmap and driving continuous exploration to define the benefit hypothesis, business processes and solution intent for program epics, in collaboration with business leads,...