Job Description

Position summary
Industry: FMCG & Supply Management
Job category: Other: FMCG, Retail, Wholesale and Supply Chain
Location: Cape Town
Contract: Permanent
Remuneration: Market Related
EE position: No
Introduction
To efficiently manage the end-to-end process of loading and maintaining pricing data in the Trusted Price Dashboard to provide the Foods business with a single source of pricing which will enable the buying teams in effectively executing the Foods Pricing strategy. This role will provide the information to equip stakeholders to make sound commercial decisions. A thorough understanding of our products and our business is imperative.
Job description
Create and maintain a single source of truth for Foods Pricing data.

• Collect, prepare, and maintain pricing source data as input to the Pricing Dashboard.
• Maintain and enhance the Pricing Dashboard user interface to deliver intuitive, relevant, and value-adding pricing insights.
• Manage the process of consolidating Role & Price Tier UDA attributes with the Commercial Pricing Specialists & sharing this info with Food Ops in a timeous manner.
• Management of the Pricing Basket indicators and ensuring they are maintained for accurate weekly basket reporting.
• Ensure quality, accuracy and consistency of information received. Ensure regular communication between stakeholders, ensuring that all relevant teams are aware of any data integrity issues which may affect price reporting & communication issues to all stakeholders.

Innovation & Continuous Improvement

• Collaborate with Category Commercial Specialists & BI team to identify opportunities to enhance current functionality of the Competitor Dashboard & implement changes as required.
• Identify areas for BAU process improvement and implement solutions to enhance operational efficiency and effectiveness.
• Keep abreast of competitor and leading industry Pricing strategies.

Build capabilities of Sales Development and Buying matrix teams to leverage pricing analysis and reporting tools.

• Proactively foster a price conscious mindset in all stakeholder engagements.
• Transfer knowledge, insights and equip the Sales Development and Buying teams with the skills required to leverage pricing tools and reports developed.

Run base price analytics and reports for all Foods categories

• Develop and deliver a standard set of base pricing reports at a defined delivery frequency, to key stakeholders within the Foods business. (Pricing team, Foods Leadership Team, Buying teams, Category Assessment and Value Delivery teams).
• Undertake ad-hoc pricing analysis as required by the pricing and buying matrix teams.
• Develop and demonstrate an understanding of the unique commercial dynamics of items within each Foods category.

Documentation of process

• Maintain accurate and up-to-date documentation of current process & update as enhancements and improvements are made.

Training

• Where required, provide training to both new and existing users of the Trusted Price Dashboard & Competitor Dashboard to demonstrate the features and functionalities.

Integrate within the Sales Development team.

• Work closely Category Pricing Specialists, where applicable, to update and maintain Category pricing data in line with the Foods Pricing strategy and architecture.
• Work with internal teams to define and translate functional requirements to advance Price reporting and analytics capabilities to proactively support the changing needs of the business.

Minimum requirements

• Bachelor's degree in Business, Economics, or Mathematics, or equivalent educational qualification
• Min of 5 years working experience, 3 years' experience in analytics
• Min 2 years Retail experience
• Highly numerated and structured with a strong analytical mind.
• Able to analyze complex data and make recommendations in support of the Foods Pricing strategy, minimize risk, and drive financial KPI's.
• Able to work to demanding timelines whilst maintaining high standards and levels of accuracy.
• Able to work with large volumes of data.
• Able to analyse complex data and make recommendations in support of the Foods Pricing strategy, minimize risk, and drive financial KPI's.
• High degree of commercial awareness and can make the links between product quality, pricing, profit and customer value.
• MS suite proficiency - PowerPoint, Advanced Excel skills with demonstrated experience in data analysis. Needs to be comfortable with VLOOKUP, Index Match, SUMIFS, Advanced conditional formatting, Pivot tables and reporting, Macros and VBA, Data Simulations.
• Stakeholder Engagement - Maintain and develop strong relationships with internal & external stakeholders.
• Able to liaise at all levels to proactively resolve issues and contributes positively to working together to achieve desired outcomes.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.
• Strong problem-solving abilities and strategic thinking.
• Dashboard Management - Creation, maintenance, and management of accurate Dashboards
• Team Player - Self-starter who is driven to deliver, can work independently and inter-dependently.
• QlikSense development/design beneficial
• Strong understanding of business processes, IT systems, and data analytics methodologies