Financial Analyst I

Job description

DESCRIPTION & REQUIREMENTS:

Position Overview:

JOB SUMMARY :

Provides support in GFO’s Planning and Business Analytics’ core service areas – Management Reporting and Operating Expense Planning and Analysis (Employee Costs Planning and Other OPEX) to clients in Asia Pacific.

Coordinates the relevant management reporting and planning governance or instructions from Corporate and Group Offices across the units in the geography.

Identifies and implements appropriate actions to standardize and simplify the existing planning and reporting process in GFO – Planning and Business Analytics.

KEY RESULT AREAS  and PRINCIPAL DUTIES / RESPONSIBILITIES

A.    Actuals Reporting

·  Processes and maintains SAP reports database and prepares a monthly summary of actual transactions in SAP;
·  Reconciles journal voucher entries in SAP with the payroll register provided by the third-party payroll service provider or GFO payroll team;
·  Reviews monthly payroll entries, the applicable balance sheet accounts (ie accruals and prepayments) and other significant transactions for accuracy, reasonableness and completeness; 
·  Connects directly with the payroll team and/or other cross-functional teams in Finance (Business Process Teams, Legal Entity Controllers, and others) for any transaction entry which needs clarification and for any book adjustments that are necessary;
·  Reviews and validates headcount reports from HR vs the employee listing in the payroll register.  Clarifies and resolves any discrepancies between the two reports with HR and the payroll team (or third-party payroll service provider).
B.    Forecasting (Rolling Estimates and Budget Plan)

·  Connects directly with the client’s Human Resources Strategic Business partner (HR SBP) for their respective headcount forecasts (Budget / Rolling) in the year
·  Coordinates the related discussions of headcount and financial assumptions with the client’s management teams (ie HR, Finance and other Functions), COEs (Compensation & Benefits and Mobility) , GBS HR and other relevant parties involved in the forecasting process;
·  Prepares an annual forecast or plan (BP) following discussions with the client of headcount and financial assumptions for the budget year;
·  Facilitates discussions of the annual budgets with the clients and their relevant budget owners/teams;
·  Updates the monthly rolling estimates (RE) based on latest headcount plan and financial assumptions;
·  Ensures that forecasts incorporate the appropriate assumptions on C&B based on the Company’s approved C&B matrix for salary, benefits and merit.  Ensures that such guidelines including any applicable statutory regulations are explained to the clients in coordination with the COE Comp/Ben in Asia Pacific.
C.    Management Reporting and OPEX Control

·  Completes a monthly a management reporting package on OPEX (Employee Costs) and updates the related reporting dashboards in the sharepoint portal;
·  Explains employee cost variances versus prior year, BP and RE, highlights significant trends or unusual transactions and discusses recommendations on potential savings or productivity;
·  Evaluates and communicates impact of changes in forecasts assumptions and provides risk and opportunity analysis;
·  Prepares a monthly detailed accounts analysis and discusses significant movements on OPEX (Employee Costs)  with the client;
·  Supports discussions on OPEX (Employee Costs) results versus BP and RE and the recommended action points with the clients’ budget owners/teams
·  Supports the clients’ budget owners in controlling their OPEX (Employee Costs) within the BP (or latest forecasts as applicable) D.    Operational Excellence (OE)

·  Ensures 100% compliance to the Service Level Agreements with the Clients;
·  Maintains a good metrics system by monitoring service level performance against the SLA elements on a monthly basis;
·  Identifies and implements the appropriate actions to standardize and simplify the existing planning and reporting process in GFO – Planning and Business Analytics.
·  Maintains and updates the OPEX Reporting Sharepoint site for relevant areas in Employee Cost Planning
·  Works independently and supports team initiatives on OE E.    Others

·  Manages ad hoc requirements and works as an SME for employee cost planning
·  Ensures compliance with the company policy on confidentiality

Education

Bachelor's degree in Accountancy, Statistics or any related field

CPA preferred

Experience

·  Experience in Financial Planning and Analysis and financial modelling, preferably from financial services companies with some knowledge of compensation and benefits structure and planning
·  Exposure to advanced reporting systems (SAP, Oracle and others)
·  High proficiency in MS Excel and other MS applications

Functional Competencies


·  Accounting, Financial Planning and Reporting
·  Ø Basic accounting and financial reporting
·  Ø Preparation of financial reports (actual results, annual or interim budgets, rolling forecasts, etc).
·  Systems
·  Ø Excellent in MS Excel and other MS applications
·  Ø SAP basic skills
·  Presentation
·  Ø Ability  to prepare using  powerpoint presentation materials or other medium
·  Business Process Improvement
·  Ø Can identify, analyze and improve existing processes  (ei financial reporting and planning)
·  Strong Organizational Skills
·  Ability to multitask and shift from one task/detail to another
·  Tenacity to build strong relationships with teams and key stakeholders
·  Ability to communicate effectively and interact through strong interpersonal skills

Core Competencies


·  Delivers Results - Focuses on the critical few objectives that add the most value and channels own and others' energy to consistently deliver results that meet or exceed expectations.
·  Balances Immediate and Long-term Priorities - Seeks to meet critical objectives while considering the impact of those decisions and activities on the ability to achieve long-term goals.
·  Imports and Exports Good Ideas - Relentlessly seeks, shares and adopts ideas and best practices in and outside the Company and embraces change introduced by others.
·  Lives the values - Demonstrates the values of The Coca-Cola Company through words, actions, and by example; fosters an environment that reflects the values of the company.

At The Coca-Cola Company you can cultivate your career in a challenging and dynamic environment. We are the largest manufacturer and distributor of nonalcoholic drinks in the world-selling more than 1 billion drinks a day. Unlock your full potential with a future-focused company that is known and respected throughout the world.