Job Openings at Diageo

Purpose of Role

The Demand Planner is responsible for all SAP APO statistical forecasting and data integrity activities.  The planner will create baseline forecast models to support the monthly S&OP process.  The demand planner will own and drive statistical forecast accuracy performance to achieve targets.  They will collaborate with the DP Business Partner on history adjustments to drive robust statistical forecasts.   The demand planner is responsible for data integrity, ensuring that the weekly forecast sent to Supply is applied to the correct sku/location.

Top Accountabilities

Generate base line statistical demand forecast for at least 18 months rolling:

• Pro-actively works with the Demand Manager and the DP Business Partner, owning the statistical forecast and highlighting deviations to the shipment and/or depletion trends.
• Use and maintain the APO software as the primary forecasting system tool
  • Collaborate with DP Business Partner on all forecast history cleaning activities including documenting adjustments and assumptions (market trends, seasonality, promotions).
  • Maintain statistical parameters for “best fit” model & generate a baseline at least 18 month rolling.
• Maintain APO master data including CVC creation, disaggregation factors and attributes.
• Analyse outliers through appropriate reports and make corrections.
• Support scenario planning for promotions, innovation and major events (duty, economics change, etc.) through stat analysis.
• Provide reports and insights to stakeholders to maximise the use of baseline forecast.

Provide key input to S&OP/IBP process

• Participate where relevant in S&OP process to align upon consensus forecast.
• Review statistical input to Strategic Planning and AOP process and challenge projected growth based on historical trends.
• Collaborate with Demand Business Partners to conduct root cause analysis to identify drivers of forecast error and work together to take the necessary corrective action to drive continuous improvement in forecast accuracy and bias performance.

Continuously improve statistical forecasting method:

• Test and implement new models
• Implement best practices
• Support system developments

Qualifications and Experience Required

Skills and Capabilities

• Baseline understanding of the end-to-end Supply Chain Planning processes; Supply Planning, Distribution Requirements Planning, Inventory Planning, Conversion, Logistics, Procurement and Customer Service
• Demonstrated proficiency in statistics and/or forecasting methodologies with an understanding of their financial and operational impacts
• Strong analytical, organizational and decision making skills
• Good communication skills – verbal, written and presentation.
• Proficient in MS applications e.g. Excel, Word, PowerPoint, Access, Outlook

Experience

• 3  years’ experience working within the Demand and/or Supply Chain Planning process; Consumer Packaged Goods Industry preferred
• Experience with advanced planning software with Supply Planning (SAP APO system and Business Intelligence/BW )

 Qualifications

• Bachelor’s degree in appropriate supply chain, mathematical, engineering, or business degree.
• APICS CPIM / CSCP or equivalent desirable.

go to method of application »

About the role

The Commercial Performance Analyst will be responsible for collecting, compiling and analyzing sales & related data and providing valuable feedback and actionable insights to guide the various commercial planning process.

Reports To:    Business Governance & Performance Manager

Role Responsibilities

Data management and Analysis

• Create and updates the SFA system with all the approved activities for execution by the sales team.
• Reviews the data changes processes to ensure compliance with business process and highlight any deviation for actions by the Commercial Performance Manager – BTL
• Defines the structure of any additional data sets required to complete analysis of a given business problem, collects and cleanses the data for analysis.
• Support with data quality assurance and data cleansing of existing data sets for analysis

Performance Reporting & Management

• Engages with the divisional Commercial Performance Managers to identify issues affecting execution of BTL plan and updates for actioning by the Commercial Performance Manager – BTL
• On an ongoing and ad hoc bases reports on and verifies daily, Weekly and monthly Key performance Indicators (KPI) are updated based on the customer marketing team needs
• Identifying and understanding performance trends, assessing performance against targets and highlights opportunities
• Process and analyze large datasets, producing clear findings and recommendations
• Manage and book the calendar of the various stakeholders to execute the customer marketing routines.

Dashboard Automation and Change Management

• Gathering and refining of requirements to build dashboards that address customer marketing team business needs, working with reporting tools including Power BI, Qlik sense.
• Develops tests and trains the team to navigate and generate insights from the dashboard developed.
• Develops a business case on any additional enhancements that are not within the current system capabilities.
• User Acceptance Testing (UAT) on enhancement build in the existing systems (DMS, Trax, CPM, SDP).
• Develops monthly greenbook for commercial team that focuses on insights to direct business outcomes (NSV, volume and ROI).

Vendor Management and internal Communications

• Manages the relationship vendors delivering non-Shopper and Channel activities – Branding and licenses for vehicles and outlets.
• Tracks and follows through the approvals of NACADA and BCLB approval for activities.
• Publication of the bi-weekly sales magazines.

Qualifications and Experience Required   

•  A business-related degree or equivalent.
• Advanced MS Excel and MS SQL skills
• 2 years’ experience in analytics or sales role
• Strong attention to detail.
• Ability to follow defined business processes.
• Ability to manage and monitor data quality.
• Excellent interpersonal skills including the ability to influence