PepsiCo

750 werknemers

Forecasting & Reporting Analyst

Utrecht
Geplaatst op: 11 augustus 2016
Deadline: 07-07-2017 12:00:00
Niveau
HBO & WO
Richting
Aanmelden talentpool

Main Purpose

 

  1. Consolidate NR at different levels (category/ brand /channel/ segment/ customer) to track top line performance
  2. Lead data provision for IS&OP

 

Accountabilities

 

  • Own a standard suite of reports and toolkits to drive transparency of performance and enable business to make decisions
  • Maintain and issue routine performance reporting (daily, weekly & monthly basis)
  • Support compilation of the rolling net revenue forecasts, assisting in data management, validation analysis and compilation of output reports
  • Provide analytical support and insight to the Sales Finance Manager and Business Partners to continuously improve accuracy of future forecasts
  • Provide analytical support and visibility of promotions effectiveness (ROI) through ownership of monthly promotion scorecard
  • Reconciliation of forecasts by account versus total business, identify amendments and ensure accuracy by period from Volume down to Margin
  • Support the team in preparation of monthly presentations to senior team, including preparation of Hit Plan material and material for other commercial meetings
  • Own the forecasting of Export volumes and Net Revenue
  • Own the administration of the Promote (promotional forecasting system) tool
  • Partner with TM1 system analyst (FP&A team) to ensure integrity of data and hierarchies

 

Job Dimensions

 

  • Provide timely and accurate information for management reporting;
  • Multiple systems (TM1, SAP, Business Intelligence, Promote)
  • 2 Market Units (complexity)

 

Key Skills/Experience Required

Functional competences

  • Financial Reporting - Provide timely and accurate information for management reporting
  • Financial Process - Manage internal processes to optimize revenue, cost, cash flow and customer service.
  • IT Management - Leverage technology resources against business priorities

Leadership Effectiveness

  • Driving for Results: Demonstrates perseverance and resilience in the pursuit of goals; Confronts and works to resolve tough issues; Exhibits a "can-do" attitude and a willingness to take on significant challenges
  • Innovating: Takes the initiative to find ways to get better results; Actively seeks and takes advantage of ideas, best practices, and solutions developed elsewhere; Develops creative solutions and different ways of doing things that add value
  • Collaborating: Keeps others informed so there are no unnecessary surprises; Collaborates well with others to deliver results; Keeps others informed so there are no unnecessary surprises; Effectively listens to and understands what other people are saying
Vooraanmelden