Data analyst - insights & data monetisation

, Western Cape

R 400000 ZA Per annum

About the Team

Shoprite X 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/Power BI/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 / Py Spark)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 forthebusiness 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.

#J-18808-Ljbffr