Data Analyst I

3 weeks 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, 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 SQL
- Should 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
- 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 independe

  • 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 Scientist I

    6 days ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2024/05/17 - Reference Number SHO240510-3 - Job Title Data Scientist I - 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 this role is to utilise multiple sources of data both internal and external to define and develop...

  • Data Governance Analyst Ii

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

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

  • Contact Centre Real Time Data Analyst

    6 days ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/02/24 - Reference Number SHO230216-3 - Job Title Contact Centre Real Time Data Analyst - 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 Contact Centre Real-Time Data Analyst role is to participate in and...

  • Contact Centre Real Time Data Analyst

    3 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of the Contact Centre Real-Time Data Analyst role is to participate in and support the gathering, analysis and understanding of the customer services’ operational data and analytics requirements and translating these requirements into real-time analytics. This role ensures the provision of meaningful operational...

  • Data Governance Analyst Ii

    7 days ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/01/26 - Reference Number SHO230119-1 - Job Title Data Governance Analyst II - Privacy - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job A Data Governance Analyst II (Privacy) specializes in managing the information flow for...

  • Data Scientist I

    5 days ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: The purpose of this role is to utilise multiple sources of data both internal and external to define and develop insights and strategies that align with marketing and business objectives to grow market share with a customer centric focus. Using this data with predictive modelling you will have a direct impact on shaping tactical and...

  • Data Governance Analyst Ii

    7 days ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: A Data Governance Analyst II (Privacy) specializes in managing the information flow for organizations, including the privacy, integrity, access to and security of data. They ensure that the data is protected both at rest and in motion. They are the custodian of the Data Privacy mailbox. Data Assurance establishes methods and...

  • SAP Functional Analyst

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

  • Data Scientist Iii

    6 days ago

    Brackenfell, South Africa Shoprite Group Full time

    **Purpose of the Job**: **Job Objectives**: - 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...

  • Data Scientist Iii

    6 days ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/04/21 - Reference Number SHO230414-28 - Job Title Data Scientist III - 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 Other - Job Objectives - Contribute towards the development of Shoprite...

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

  • Business System Support Analyst

    3 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...

  • Digital Commerce: Data Analyst

    6 days ago

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

  • Squad Lead: Healthcare Data Ecosystems

    7 days ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/03/22 - Reference Number SHO230315-7 - Job Title Squad Lead: Healthcare Data Ecosystems - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job The Squad Lead: Healthcare Data Ecosystems for ShopriteX is responsible for driving data...

  • Functional Analyst Ii

    7 days ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/07/19 - Reference Number SHO230705-3 - Job Title Functional Analyst II - Job Type Permanent - Location - Country South Africa - Location - Province Western Cape - Location - Town or City Brackenfell, Cape Town - Purpose of the Job - To evaluate business requirement specifications, transform the essential components into an abstract and...

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

  • Product Manager: Reporting Assets

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

  • Product Manager: Reporting Assets

    4 weeks ago

    Brackenfell, South Africa Shoprite Group Full time

    Closing Date 2023/12/04 - Reference Number SHO231127-3 - Job Title Product Manager: Reporting Assets - 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 Product Manager II role is to drive the building of products that meet customer...