Commercial Planning Analyst - 12 month FTC

Overview PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $68 billion in net revenue in 2020, driven by a complimentary food and beverage portfolio that includes Walkers, Gatorade, Pepsi-Cola, Quaker and Tropicana. PepsiCo's product portfolio includes a wide range of enjoyable foods and beverages, including 22 brands that generate more than $1 billion each in estimated annual retail sales. Guiding PepsiCo is our vision to Be the Global Leader in Convenient Foods and Beverages by Winning with Purpose. “Winning with Purpose” reflects our ambition to win sustainably in the marketplace and embed purpose into all aspects of the business. For more information, visit www.pepsico.com. Responsibilities Manage the robust administration and accounting of sales investments for a Top 4 account (especially promotions), including promotion review, invoice validation and deduction management. Support the period close process, including accruals management and balance sheet reconciliations. Support Business Partners & commercial teams to translate sales account initiatives into accurate sales data forecasts for promotions, new products and other initiatives, and determine the performance of historic sales promotions and record the sales uplifts accurately in the system (“actualisation”). Leverage insight of key business drivers to propose and execute action plans to enhance business performance, for e.g. support deal modelling Lead monthly forecasting process to ensure learnings from historic performance and trend analysis captured in ongoing outlook Own data reporting for each account, including standard reports on a weekly and monthly basis, plus ad hoc requests. Ownership for some key D&A SOX controls including monthly B/S reconciliations Take a leading CPA role to driving team to embed new business processes following new system implementation Qualifications CIMA or ACCA (Part Qualified) preferred Experience of working in an FMCG or Blue-Chip organisation Advanced Excel skills, e.g. comfortable with Pivots and V-Lookups & accounting Strong financial planning and forecasting skills Good knowledge of financial systems Assertive and independent with the ability to cope effectively under pressure and to tight deadlines Quickly analyses complex problems to find actionable, pragmatic solutions Consistently works against the right priorities and takes the initiative to find ways to get better results Demonstrates a ‘can-do’ attitude and sense of passion, enjoyment and pride about their work Innovative: 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 Ability to lead the agenda within their own working group