Job Description

:
Overview
This role is focused on delivering and improving upon PBNA reporting and analytics to deliver valuable insight to PBNA colleagues and leadership. This role provides support to the Deputy Manager FP&A in managing the Bev DSD P&L in support of close, forecast and AOP - with particular emphasis on the BU P&L.
Responsibilities
Functional Responsibilities

• Leverage P&L knowledge to drive decisions
• Provide support to Finance Manager, FP&A on duties related to close, forecast and AOP
• Provide overall support for the period end results and preparation of forecast (complete BU P&L forecast in WK1 of each period)
• Develop and manage models, tools and reporting
• Complete core weekly reporting requirements: i.e. Out of Network, KDP, Mileage Report and Sales Excellence Scorecard, etc. while collaborating with cross-functional partners on improvements, S&D Cost Tracker, Waste reporting
• Troubleshoot and oversee automated reports via VBA macros and/or working with automation Center of Excellence on reports generated using Robotic Process Automation (RPA). PBI dashboarding
• Lead updates and usage of key reports including Modern Finance Power BI Daily & Weekly Sales reports
• Complete file updates to P&L Output file prior to each period close
• Lead performance analysis and reporting for Canada BU P&L
• Develop PowerPoint presentiation to communicate business results and insights
• Collaborate with Sales, Supply Chain and Finance functions on ad-hoc projects
• Create an inclusive and collaborative environment