Central Pricing Data Analyst at Woolworths

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.

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 work to demanding timelines whilst maintaining high standards and levels of accuracy.
• Able to work with large volumes of data.
• High degree of commercial awareness and can make the links between product quality, pricing, profit and customer value.
• Able to analyze complex data and make recommendations in support of the Foods Pricing strategy, minimize risk, and drive financial KPI’s.
• Advanced Excel skills with demonstrated experience in data analysis.
• 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.
• Commercial Awareness - Creating value by making the link between product quality, pricing, profit and customer value.
• Analytical - Translate analytics into actionable and clear recommendations.
• Dashboard Management - Creation, maintenance, and management of accurate Dashboards to support business reporting and decisions.
• Advanced Excel - VLOOKUP, Index Match, Advanced conditional formatting, Pivot tables and reporting, Macros and VBA, Data Simulations.
• Stakeholder Engagement - Maintain and develop strong relationships with internal & external stakeholders.
• Team Player -   Self-starter who is driven to deliver, can work independently and inter-dependently.
• MS suite proficiency – Excel (advanced), Powerpoint & Excel
• Qliksense development/design beneficial
• Strong understanding of business processes, IT systems, and data analytics methodologies.