Pricing Data Analyst

Shoprite; Cape Town; On-site; ZAR 200,000 - 300,000; Full time

Job summary

A leading retail company is seeking a Data Analyst to support the category management team. The role involves analyzing pricing strategies and providing meaningful insights, contributing to the optimization of pricing strategies and data tool development. Ideal candidates will have a Bachelor's in Data Science and experience with SQL, Python, and data analysis tools.

Qualifications

• Bachelor's degree in Data Science or related field essential.
• 1 year's experience in a Data Analyst role required.
• Knowledge of SQL, Python, and data analysis tools is essential.

Responsibilities

• Perform and build analysis of pricing developments and offerings.
• Assist in creating reports and recalculating metrics including competitor analysis.
• Monitor updates related to relationships of new Stock Keeping Units (SKUs).
• Support tool development and training.

Skills

SQL

Python

Data analysis

Excel

Education

Bachelor's degree in Data Science

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.

Data 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).