Return to Search →  Asia Pacific   Europe   Latin America   Eurasia & Africa   North America

Returning Applicants

Australia Planning & Reporting Analyst

The Coca-Cola Company

  • Location: North Sydney, Australia - AUS
  • Post Date: 1/1/2019
  • Job Type: FULL TIME
  • Job Level: 01. Regular
  • Post End Date: January 31 - 2019
Share This Job
Job ID: R-19949

Position Overview:

A career at Coca-Cola South Pacific is truly a one-of-a-kind experience. It's more than working for the global beverage leader; it's an opportunity to be a part of something that impacts the world. From our product portfolio to the planet itself, we offer you not only the chance to build a successful career -- we offer you an opportunity to make a difference in the world.

As a global icon and keeper of the world's most valuable brand, our boundless opportunities attract the very best experienced professionals, like you. Now more than ever is the time to become part of Coca-Cola South Pacific.

Budgeting & Forecasting: To support the Budget & Planning Manager in managing the Australia P&L from a budgeting, forecasting & actuals perspectives, as well as providing rigorous financial and business support.

Management Reporting: To deliver on Management Reporting needs for the Australia, SP Business Unit, and local Finance Management team

Function Specific Activities:

Primary Responsibility:

  • Specifically, the preparation of the monthly Actual Result and monthly Rolling Estimate for Australia
  • P & L reporting and analysis (local, regional, Group and HQ), including commentaries
  • Ensure accuracy of financial information
  • Work with Bottlers and supply points to obtain and verify information, and to compile monthly reporting
  • Assist to provide regular Risk and Opportunity analysis on basis of volume, shipment information & monthly estimate expenditures
  • Work with Commercial Finance associates to ensure DFR and DME is within planned budget
  • Reconcile and track latest shipment forecasts from CPS against production demand from the Bottler to ensure alignment and accuracy for the RE process.
  • Prepare bottler ending inventory reconciliations on a quarterly basis.
  • Ensure accuracy of financial information on consolidation into requested templates
  • Deliver timely submission of adhoc reports and analysis to Group and Corporate including weekly volume reporting, DSI analysis, and Actual/RE scorecards.

1.)Business Planning and Budgets (preparation of the Australia Business Plan):

  • Understand assumptions and guidelines and impact on business performance
  • Work with Budget & Planning Manager, Commercial Finance associates  to compile Business Plans and Budgets
  • Work with bottler, Franchise team, and Commercial Finance team to determine financial and volume aspects of joint system business planning
  • Help developing financial models to facilitate the financial aspects of the business plan
  • Manage the business plan models in Hyperion (Official planning tool)
  • Submission of  Business Plan results to Group and Atlanta HQ

2.)Co-ordinate and prepare Management Reporting Packs as well as all information requests and financial analysis for the BU as requested by Local Management, Group and Supply Points within the time frames specified:

  • Prepare Monthly Management reporting Package based on latest Submitted RE.
  • Provide leadership and accountability for all requests
  • Ensure accuracy of information provided
  • Submit information on time and in the requested formats.

3)  Custodian of Hyperion (Official Planning Tool) for Australia :

  • Understand system structure and workflow
  • Maintain Master data files for Australia
  • Responsible for all business processes and information submissions done through Hyperion.
  • Ensure Accuracy and completeness of Data for Australia in the system
  • Australia and SPBU Hyperion power user, representing the BP in all Hyperion related matters
  • Troubleshooting of Hyperion, Compass / NSR 1.0 and Financial Data Warehouse (FDW) system issues and performed master data maintenance for all systems involved throughout the planning process.

 4.)Equity income Reporting

  • Facilitate equity income reporting (Actual / Forecast) and narratives for SPBU.
  • Collect equity income supporting information on timely base, follow up with counter parties to understand all changes and business rationales
  • Directly communicate with Corporate unconsolidated entities team for all equity income results 

5.) Value Added Analysis & Ad hoc Projects:

  • Provide Brand profitability analysis
  • Assist in the compilation of ad hoc value added analysis and insights
  • Assist in ad hoc projects related to the role upon request from Finance Management.

6.)  Work with Budget & Planning Manager to strengthen internal controls:

  • To assist the Budget & Planning Manager & BU Finance Team to manage financial risks through the development and implementation of control and monitoring systems

Qualifications & Experience required:

  • University Degree in related field
  • CPA/CA/CIMA qualifications
  • 3-5 years post qualified experience in commerce & industry
  • Strong Analytical ability
  • Problem solving skills
  • Flexibility & adaptability
  • Organisational & time management skills
  • Attention to detail
  • Hyperion & SAP Proficiency
  • Excel Proficiency


General Accountabilities:

  • Deliver all reporting requirements within agreed time frames and formats
  • Financial analysis to support the SPBU Management Team
  • Financial support to the local team
  • Responsible for implementation and performance of financial administration initiatives
  • Plan and execute multiple deliverables
  • Monitor results in line with project plans using effective execution
  • Gather data using fact based analysis for decision making
  • Gather data for recommendations into process and practice improvement
  • Provide input into Business Plans that maximises opportunity
  • Troubleshooting of Hyperion, Compass / NSR 1.0 and Financial Data Warehouse (FDW) system issues and performed master data maintenance for all systems involved throughout the planning process.

Job Requirements:

Years of Experience:

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.

Back to Top

Stay up to date on job openings that match your skills & experience.

Sign Up now
At A Glance

Become part of our professional community to receive company information, news and upcoming events.

Join Now
Who We Are: The Coca-Cola Company
Coca-Cola Millennial Voices
Multicultural Leadership Council