Data Analyst (IDM Jnr)

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 Associate Data Analyst role is to leverage Shoprite’s rich customer and transactional retail data assets to provide actionable trends and insights that enable business to make sound commercial decisions. The role works collaboratively in an agile team, modelling and framing well-defined business scenarios to solve analytical problems, performing experimental design approaches to validate findings or test hypotheses, depicting the rationale of findings in easy-to-understand terms for business and providing consolidated business reports and metrics. The Associate Data Analyst has a passion for developing their skills in the art of data analytics, requiring a combination of technical, analytical and communication skills to infer meaning from data and translate these in a concise, cohesive story. Role Description • Under the guidance of the Lead / Senior Data Analyst, work with business stakeholders to understand and correctly frame analysis requirements, hypotheses and questions and propose fit-for-purpose data led solutions. • Prepare data sets, ensuring the right data is collected and the right analytical techniques are applied to produce the right business insights. • Write standard business requirements/modifications to transform data into common and graphical formats and reports. • Design, code, debug, test, document and support applications consistent with established business requirements and specifications and participate in post-implementation reviews. • Build and publish comprehensive dashboards, reports and analytical findings that enable business to draw meaningful insights. • Support with 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. • Evaluate the accuracy of data sources and data gathering techniques and ensure data quality and integrity is maintained. • Maintain documentation, user guides or training material, ensuring the same language and definitions are applied. • Share insights across teams to inform collaborative efforts. • Stay updated on developments in data analytics and adjacent fields to ensure the latest techniques and methods are applied. Qualifications and experience • Degree or Diploma in Operations Research, Statistics, Engineering, Information Technology, Information Systems or a related field – (essential). Essential: • +1 years’ experience working as part of a data team, in an Associate Data Analyst or similar role, with good exposure to working with analytics products and applying analytical formula and models to transform data into insights – (essential). • Strong proficiency in MS Word with well-developed Excel skills – (essential). Desired: • Exposure to creating dashboards and reports using data visualisation tools (e.g., Tableau, Power BI) • Foundational knowledge of SQL and relational databases • Foundational knowledge of AWS cloud computing based solutions (Python / PySpark) • Foundational knowledge of cloud-based data and AI platforms (like Snowflake) • Exposure to an agile environment • Exposure to retailer specific data (e.g. brand, customer, shopper, category, sales, promotions, pricing, channel, POS, payment / tender, store, stock and supply chain data) Key competencies and work ethic • Analytical and numerate – Able to collect, organise and assimilate disparate and multiple pieces of data to draw sound conclusions. Solves data problems using their knowledge in scientific disciplines. • 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 goals and expectations. Able to work independently and use own initiative to deal with challenges in areas of familiarity. • Detailed, organised and quality focused – Has an affinity for detail, structure and efficiency, balancing planning and execution. Is diligent and vigilantly executes tasks to ensure accuracy while promptly escalating and correcting any quality concerns. • Good communication skills – Communicates well both verbally and in writing. Able to explain and simply technical concepts and confidently convey information to stakeholders. Able to compile well-developed and visual reports. • Team player and collaborative partner – Works effectively as part of a multi-disciplinary team. Is collaborative and able to build sound, professional relationships with business stakeholders