Planning Analyst at Coca-Cola

Job ID: R-25389
Job Level: 01. Regular

Position Overview

• Everybody knows Coca-Cola. But only the best people work in The Coca-Cola Company. This is your chance: we are looking for someone who is ready to join us in turning our passion into action
• The person must provide related analysis and reports in an accurate, timely manner to ensure optimal allocation of system resources in implementation of the Company's business strategies.
• The person must prepare accurate analysis and reports in order to support BU P&A Manager for identification of risks & opportunities across the system, optimization and standardization of Planning & Analysis' processes and tools within his/her responsibility area.
• The selected candidate will support BU P&A organizations for efficient, effective and sustainable processes and transactions; and provides services according to business needs. Supports BU P&A Team on system thinking related to policies, programs, company, productivity and objectives.

Key Duties/Responsibilities
Provides analysis and reports to support BU P&A and Franchises Finance Team:

• Performs GP analysis
• NSR review/analysis
• Co-ordinating feedback on weekly shipment status and shipment timing variance analysis
• Co-ordinates confirmation of finalization of actual postings with CPS & Finance Managers
• Ensures concentrate revenue and costs are accurately posted
• Ensures accuracy of concentrate write off accruals
• Follow up on deduction postings with Finance Managers as per RE/expectations
• Follow up on processing of GPIE
• Prepares and submits monthly, quarterly, annual and ad-hoc actual reports including
• Actual narratives (P&L and OPCAP)
• Management Reporting deck for Business unit leadership team meetings
• Ad-hoc reports prepared upon Region, BU requests
• Annual UC P&L execution and Brand Con. reporting
• Following up on key issues arising on balance sheet reconciliation review process with GFO team
• Actuals and month close process
• Coordinates confirmation of finalization of actual postings with Finance Managers
• Ensures concentrate revenue and costs are accurately posted
• Follow up on processing/posting of GPIE
• Analysis of UCs P&L
• Prepares and submits monthly, quarterly, annual and ad-hoc actual reports including
• Actual narratives (P&L and OPCAP)

Provides related analysis for Forecast (RE/BP) in his/her responsibility area, while adhering to RE/BP calendar deadlines:

• Coordinate and load RE inputs into Hyperion according to Group/BU/Franchises requests:
• Coordinates inputs and outputs templates with Franchises and BU: UCs, CSE, GR, DFR, NSR, COGS, GP
• Follow up on deduction postings with Finance Managers as per RE/expectations
• UC P&L execution and Brand Con. Reporting
• Follow up on system outputs to keep stakaholders aligned on expectations (Franchis Finance Managers, Planning Manager, FD)
• Coordinate OpCap inputs from franchises and BU
• Prepares RE/BP interim output reports for Regions and BUs during planning period
• Supports RE/BP management reporting and financial consolidation at BU level
• Analyzes BP/RE management reports (scorecards, dashboards, brand contribution, MEM reports)
• Prepares RE/BP narratives and manual templates
• Prepares Region, BU office and BU consolidated R&Os
• Prepares ad-hoc reports upon Region & BU requests

Job Requirements
Education:

• Minimum of 3 to 4 years of experience
• Accounting experience is a strong plus
• University/Bachelor's Degree minimum

Required Skills

• Financial analysis
• Planning and forecasting skills
• Performance management
• GAAP, cost accounting / analysis
• Excellent computer skills (i.e. Excel)

Growth Behaviors:

• Growth Mindset: Demonstrates curiosity. Welcomes failure as a learning opportunity.
• SMART RISK: Makes bold decisions/recommendations.
• Externally Focused: Understands the upstream and downstream implications of his/her work. Tracks and shares external trends, best practices or ideas.
• Performance Driven And Accountable: Has high performance standards. Outperforms her/his peers.
• FAST/AGILE: Removes barriers to move faster. Experiments and adapts. Thrives under pressure and fast pace.
• Empowered: Brings solutions instead of problems. Challenges the status quo. Has the courage to take an unpopular stance.