Data Analyst
HO KENL - Kenilworth Campus, South Africa
Pick n Pay
It's fun to work in a company where people truly BELIEVE in what they're doing!
The Space & Range Data Analyst is responsible for extracting, collating, analysing, auditing, and reporting KPIs, Master data, Metadata and Customer data pertaining to company space and range ecosystem, in support of the Commercial strategic objectives and the immediate team’s daily operational work.Minimum requirements
Relevant postgraduate qualification (preferably in Data Analytics)
3+ years retail experience
Advanced Excel skills essential
Other data query tool skills or capability is an advantage
Experience within Commercial Space and Range is an advantage
Knowledge of SAP, BI and Space Planning tools and data
Competencies
Demonstrates an aptitude for Data
Ability to establish relationships in data and draw conclusions
Analytical Thinking
Problem solving
Commercial performance acumen
Accurate and meticulous
Timeline driven with a sense of urgency
Key responsibilities
Assortment
Extract, collate and analyse category range and data, both in the reporting of micro space KPIs and to support ranging decisions, adjustments and category reviews.
Track and report on micro space and range governance, master data alignment and conformance to ranging and merchandising business rules.
Support the Assortment Analysts, Space Planners and Category Buying teams with insights derived from the category-related iformation.
Maintain a register of range change activity (e.g. listing / de-listing approvals, national Exit pipeline etc.) and report on the evolution of our offer across store clusters.
Micro Space
Extract, collate and analyse planogram data in order to report on category space performance , forward share and related KPIs.
Supply and / or oversee the accuracy of display data provided to Supply Chain for replenishment purposes.
Support the Assortment Analysts with relevant micro space data to support ranging and range densification decisions.
Collaborate with the Micro Space Planning service provider to enable the production of optimal planograms.
Provide Category Captains and Partners with relevant assortment, cluster and associated transactional data as requested from time to time.
Macro Space
Provide Macro Space Planners with relevant information that enables data driven space allocation decisions, including trading density, GMROS, category locational and adjacency performance analysis, and related insights pertaining to a particular store, cluster, format.
Assist in maintaining a space matrix of category space per store to enable accurate space productivity analysis and linking of the correct planograms.
Maintain an accurate register of store metadata and pertinent equipment attributes (e.g no. of tills, queueing system type, free-standing chillers, Clothing / Liquor) enabling real estate space to be analysed, optimised and / or and leveraged to support commercial arrangements with suppliers.
Report on company space productivity.
Overall
Report Space and range, profile, evolution, performance and opportunities holistically across Macro and Micro areas.
Support Face of Trade reporting, metadata and space / dimension maintenance requirements.
Audit and manage the maintenance of space & range metadata to accurately reflect the profile of store, equipment, space and assortment, enabling accurate reporting and maintenance of space and range.
Maintain our Commercial store segmentation document.
Closing date: 17 June 2025
If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!
Discover who we are
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Data Analytics Excel KPIs
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.