Job Description

The purpose of the Data Analyst role is to perform and build analysis of pricing developments and offerings and translate these into meaningful analytics and actionable insights to support the category management team meet its commercial and revenue goals and targets. The role gathers, consolidates and analyses relatively complex data, data sources and datasets to produce insights, predictions, recommendations and reports to optimise pricing strategies, whilst supporting the Category Insights team with ad hoc reporting and providing input to analytics tool development, monitoring, utilisation and training.Job Advert Details
Job Category Food Service
Job ObjectivesData and Competitor Analysis and Pricing Strategy

• Assist the Category Insights Manager in creating reports and re-calculating metrics including competitor analysis, category roles, Key Value Items (KVIs), and target price indices to provide insights on market trends and customer behavior.
• Assist the Category Insights Manager in creating and updating tool files from pricing strategy refresh (I.e., category role mappings, item roles, KVIs, target price indices etc.) to ensure that ensure that the pricing strategy remains up-to-date and reflects changes in market trends and consumer behavior.
• Assist the Category Insights Manager in coordinating with Analytical Engineer on competitor data source updates (e.g., if competitor is added/removed) to ensure that the data used for competitive analysis remains current and accurate.

Item Relationships Support

• Monitor updates related to the relationships of new Stock Keeping Units (SKUs), updated SKUs, incorrect item relationships, and dead/delisted SKUs in SAP.
• Manage the follow-up process, which includes reviews of new SKUs that are not timely.
• Organise and run weekly meetings with tool core team (Support Specialist, Category Specialists etc.) to discuss updates and ensure overall alignment on dependencies.
• Provide ad-hoc assistance and expertise to Category Specialists on item relationship updates upon request.
• Investigate "incorrect item relationships" flagged by Buyers in overrides and notify Master Data team if SAP data is incorrect to support smooth and efficient operations.
• Own and conduct quarterly clean-up of input sheets.

Tool Development, Monitoring, Utilisation and Training

• Support the Category Insights Manager by creating monthly tool usage reports to help identify Buyers/categories with high percentage overrides.
• Support buying teams on creating plans, monitoring new plans, and investigating overrides.
• Provide input to new functionality developments on the tool.
• Support the definition of tool training materials, training schedules, and engagements with Buyers in collaboration with Trainers and Category Insights Manager.

Ad hoc Support

• Support the Category Insights Manager and the Head of Category Management in handling exceptions (e.g., generating weekly reports, support meetings).

Qualifications

• Bachelor's degree in Data Science, Computer Science, Mathematics, Statistics, Information Technology, Information Systems or a related field - (Essential).

Experience

• +1 years experience in a Data Analyst or similar role, solving business and technology problems through applying data analysis techniques within a fast-paced environment - (essential).
• Experience applying data mining, modelling and mathematical and/or statistical concepts and methodology to support strategic business objectives - (essential).
• Experience in a retail, commercial or IT environment - (highly desired).

Knowledge and Skills

• Knowledge of SQL, Python and data analysis toolkits - (essential).
• Strong proficiency in MS Office 365 with advanced Excel skills - (essential).

Shoprite Holdings