Data Analyst I

3 weeks ago

Cape Town, South Africa Shoprite 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 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.

  • Data Analyst

    1 month ago

    Cape Town, South Africa Telebest Full time

    Our client has an opportunity available for a Data Analyst.Requirements:Data analysis, advanced Excel and Cognos analytics skills.Bachelor’s degree or equivalenting in a numerical or analytical field such as statistics, accounting and or computer science.3 to 5 years in an analytical role such as Data analytics, BI and Consumer...

  • Junior Data Analyst

    4 weeks ago

    Cape Town, South Africa PBT Group Full time

    We have an opportunity for a_ Data Analyst _with 2+ years of experience in performing data/systems/information analysis in a BI environment. **Essential to your skills toolbox.** - Functional experience in analytics, data visualisation, reporting, and technical proficiency in database design development, data models, techniques for data mining, and...

  • Data Analyst

    1 month ago

    Cape Town, South Africa RPO Recruitment Full time

    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. **Responsibilities**: - Develop and implement databases, data collection systems, data...

  • Data Analyst

    1 month ago

    Cape Town, South Africa PBT Group Full time

    Key Responsibilities: - Analyse large data sets to identify trends and patterns - Develop and maintain data reporting and dashboard tools - Ensure data accuracy and integrity through regular audits and quality control processes - Work closely with stakeholders to understand their data requirements and develop solutions to meet their needs - Collaborate with...

  • Mobile Test Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Mobile Test Analyst, you'll help the development team ensure that our applications are functioning correctly on all devices and operating systems. You'll test apps on multiple mobile platforms including iPhone/iPad, Android and BlackBerry. You will also be required to follow up with developers for specific issues that may arise in their work flow or...

  • Senior Business Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Senior Business Analyst, you'll be responsible for analyzing and testing new software applications. You'll be tasked with ensuring that the application is working as intended before it goes live to customers. You will work closely with other development teams and the business analysts in order to ensure that all aspects of our product are functioning...

  • Functional Analyst I

    1 month ago

    Cape Town, South Africa Expleo Full time

    Overview: Expleo is a trusted partner for end-to-end, integrated engineering, quality services and management consulting for digital transformation. We are looking for a **_Functional Analyst I_**: - _to join our dynamic team in **_Cape Town._** **Responsibilities**: - Performing assigned gap analysis to determine and understand the functional business...

  • Business Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a Business Analyst, you will be working on a project that involves business process analysis and requirements gathering. You'll use the relevant software tools to gather information for your team to work from. You may also be required to help test new functionality or build prototypes of new features using web applications. Requirements ...

  • System Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    As a System Analyst, you'll be responsible for maintaining and managing the company's IT infrastructure. You will be responsible for identifying issues and recommending solutions to maintain the network, database systems, servers and workstations in good working order. You will also have to manage the installation of new hardware as well as software...

  • Data Analyst

    1 month ago

    Cape Town, South Africa Olive Branch Recruitment Full time

    Looking for a Data Analyst to join a growing Tech organization. This position is Hybrid and based in Cape Town. Should you meet the requirements and are passionate about making a difference in the lives of others, please be sure to apply. **Requirements**: Tech/B.Sc. Engineering, Maths; Stats; Actuarial Science 1 to 3 years of work experience Must have...

  • Systems Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    The Systems Analyst will be responsible for implementing and maintaining a number of technology systems including but not limited to: - Azure, AWS (AWS Database, Redshift, ElasticSearch) - Oracle Databases and SQL databases - SAP applications in Finance/HR/CRM and Marketing. You'll also be responsible for data migration from various legacy systems into...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa New Beginnings Recruitment Full time

    **Responsibilities** - Interpret data, analyze results using statistical techniques and provide ongoing reports - Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality - Acquire data from primary or secondary data sources and maintain databases/data systems - Identify,...

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

  • System Analyst

    4 weeks ago

    Cape Town, South Africa PBT Group Full time

    We are seeking a talented System Analyst to join our team and help us build innovative solutions for our clients. As a System Analyst, you will be responsible for designing and supporting workflow solutions, developing and delivering systems specifications, and ensuring the delivery of high-quality solutions to our clients.Required Experience and...

  • Junior Data Analyst

    4 days ago

    Cape Town, South Africa Tigonthrive Consulting Full time

    Tigonthrive Consulting is seeking a motivated and detail-oriented Junior Data Analyst to join our team. The Junior Data Analyst will assist in collecting, processing, and analyzing data to support our HR consulting services. This is a remote position with the potential for occasional travel for team meetings and client interactions. **Key...

  • Senior Security Analyst

    1 month ago

    Cape Town, South Africa Dimension Data Full time

    FunctieomschrijvingAre you fed up of working in the same job for years? Do you want to take that next step and become a Senior Security Analyst? This role is perfect for you if the following describes your experience:The Senior Security Analyst will be responsible for the analysis of network infrastructure, security and compliance issues. This includes...

  • Data Analyst

    1 month ago

    Cape Town, South Africa Paracon Full time

    We are on a search for a Data Analyst to be part of a diversified financial services group that operates across the African continent. Additionally, the Data Analyst will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights. Our client...

  • Data Analyst

    4 weeks ago

    Cape Town, South Africa PEP Africa Full time

    **PPURPOSE OF THE POSITION**:To develop, maintain and administer reports and to provide a technical support service with regards to Business Intelligence tools and general data related requests. **KEY RESPONSIBILITIES** - Development and deployment of new Business Intelligence reports (Business Objects, Looker Studio, Qlikview, Google Sheets) and ad hoc...

  • Data Analyst

    1 month ago

    Cape Town, South Africa BVNK Full time

    **About us**: BVNK is a next-generation payments platform. We're on a mission to make payments as accessible as the internet. We bridge traditional and digital finance to make payments borderless, fast, and secure. Using our platform, businesses can incorporate stablecoins into their payment flows, and send and receive payments anywhere in the world. We...

  • Data Analyst

    2 weeks ago

    Cape Town, South Africa GG Financial Recruitment Full time

    Fantastic position for a mid-level analyst aspiring to leadership. My client is a leading & stable medium sized FMCG company who requires a Data Analyst / Customer Insights Analyst to provide data/dashboards and reports on both existing as well as forecasted customer behaviour. The ideal candidate should be committed to gaining and learning more about...