Retail Analyst at The Prestige Cosmetics Group

Purpose of the Role

• The Retail Analyst is a key source for business reporting and has a keen eye for detail based on data and trends that provides strategic insights and recommendations of actions to the business – the role co-ordinates these actions with the necessary departments ensuring we have the right stock in the right doors to drive sales and market share growth.

KEY RESPONSIBILITIES
ANALYSIS AND REPORTING

• Understands the retail environment through data analysis of each retailer to provide information on opportunities.
• Analyse stock and sales reports on a weekly basis to provide insights by door, by brand and by retailer.
• Analyse retailer stock levels to identify opportunities and challenges to optimise sell-out and stockturn by SKU by store – build recommended actions accordingly.
• Build sell-out targets by mall, by brand, by retailer annually and manage reforecasts monthly.
• Assist and support the Key Accounts Executive to deliver all weekly and monthly reports.

STOCK MANAGEMENT - RETAIL

• Analyse and interpret sales and stock trends to provide actionable insights and data-driven business decisions.
• Formulate strategies for slow moving inventory and days stock cover to ensure optimal stock levels that supports business growth.
• Guide and support the execution of planograms by analysing each brand and the respective stock model requirements.
• Conduct competitive analysis to refine stock strategies ensuring that PCG remains agile and responsive to market trends.
• Oversee the management of critical SKUs.
• Develop centralised reporting frameworks to track core in-stock metrics enabling clear visibility and timely interventions.
• Collaborate with Brand Team to ensure that promotions are executed with sufficient stock availability reducing missed sales opportunities and ensuring customer satisfaction (saleable and non-saleable stock).
• Monitor promotional in-stock levels to minimise out-of-stocks during key sales events.
• Maintain inventory expectations at store level to resolve any discrepancies and maintain operational consistency.

SALES TEAM SUPPORT

• Guide the Sales Team on best practices and how to manage stock efficiently at store level.
• Work with the sales team on store gridding and localisation.
• Supports KAE where retailer head office escalations are required to help resolve any issues around DI, stock input requests.
• Partner with the Sales team to ensure optimal usage and allocation of non-saleable stock – drive productivity.
• Provide insights and guidance on overstocks and understocks ensuring data-driven actions.
• Builds weekly new product trackers to track new launches versus prior launches.
• Stakeholder Engagement
• Build and maintain relationships with all internal and external stakeholders.
• Contribute meaningfully to create a great workplace experience for all team members.
• Actively engage in all Company culture initiatives.

MINIMUM REQUIREMENTS/QUALIFICATIONS

• Commerce/Business Degree
• At least 3-4 years’ work experience in a retail environment
• Strong analytical ability and commercial acumen
• Retail planning experience is preferred and advantageous
• Proven knowledge of MS packages Excel/Word/PowerPoint
• Advanced Excel: Non-negotiable
• Experience using Power BI is advantageous