The Coca-Cola Company Job Vacancy in Kenya : BU Planning & Analysis Analyst

The Coca-Cola Company Job Vacancy in Kenya : BU Planning & Analysis Analyst
February 16, 2015 Job Description

The closing date for this role will be 24th February 2015.JOB SUMMARY:

Provides related analysis and reports in an accurate, timely manner to ensure optimal allocation of system resources in implementation of the Company’s business strategies. Prepares 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.

Supports BU P&A organizations for efficient, effective and sustainable processes and transactions; provides services according to business needs. Supports BU P&A Team on system thinking related to policies, programs, company, productivity and objectives, while taking into account a broad system approach.

KEY DUTIES/RESPONSIBILITIES:

Provides Reports as follows : 45%
Performs GP analysis
Co-ordinating feedback on weekly shipment status
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
Quarterly CAPEX reporting
Annual UC P&L execution and BC reporting
Updating opex analysis report BP vs Actuals on a monthly basis.
Following up on key issues arising on balance sheet reconciliation review process with GFO team
Co-ordinates submission of Earning release template on a quarterly basis
Prepares and provide analysis for Opex people costs by:
Updating actuals Vs Plan on a monthly basis and sharing with Human Resources and Function heads as appropriate highlighting main issues and suggested solutions
Co-ordinating the alignment with human resources on open position hiring status for alignment with Finance
Confirmation of actuals on opex people cost: follow up on Payroll Jv’s,charge backs expected on benefits to ensure completeness of actuals on a monthly basis
Supports the process of client management by updating Function heads on their tracking of opex spend inclusive of people costs as agreed with the team.

2.Provides related analysis for Forecast (RE/BP) in his/her responsibility area, while adhering to RE/BP calendar deadlines: 50%
Prepares input assumptions and adjusts BPC according to Region / BU requests:
OR/PF
Concentrate shipment planning (inventory based, DSI based, or manual)
Volume driven rebates, freight, sales tax
OPEX
DME
Working capital( Balance sheet)
Performs RE/BP financial statement line items and adjusts according to Region/BU guidance. Performs RE and BP activities
Uploads UC and CSE forecast in BPC
Deduction planning in BPC
DME planning in BPC (including FDW extractions)
OPEX planning in BPC (including coordination of OPEX input files in BP period)
B/S forecasting in BPC
UC P&L planning in BPC
Coordinates input and output templates with Regions and BUs
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
Supports People Opex planning in collaboration with SBP during RE/BP by:
Supports the people financials planning process by simulating expected costs per position as per guidelines on grade and package for review by relevant stakeholders in BP process by use of the people cost planning team
Provide forecasts for RE for people costs as per expectations as aligned with HR
Follow through on the alignment of people cost planning during BP process as per aligned organization chart within the planning calendar.
Supports the process of client management by updating Function heads on their tracking of opex spend inclusive of people costs as agreed with the team.

3. Process Improvement: 5%
Supports BU P&A Team to achieve efficient, effective and sustainable finance processes and transactions
Provides support to Finance Managers on reports/updates needed in Planning system
Works with process owners to identify and implement continuous improvements in processes, systems and procedures
Acts as a part of the process and ensures standard processes are followed.

4. Client Management:
Provide accurate feedback on queries raised by Corporate or other stakeholders as appropriate on actuals,RE and BP reports
Provide support during RE and BP submissions to Finance Managers and System Economics analysts on submissions made working to closing on requirements on a timely basis
Balance sheet follow up and review as allocated by Management

COMMUNICATION COMPLEXITIES:

Internal
BU Planning & Analysis Manager (problem solving, brain storming, receives guidance, supervision, coaching)
Region Finance Manager (service requests, issue management)
Group planning team( Feedback on expectations/Client Management)
Financial Services Representative( Following up Feedback on queries)

ANALYSIS:

This position consists of routine tasks or processes in accordance with predetermined, clearly defined steps. The individual must possess collaboration, organization skills/capabilities; with the ability to multi-task, set priorities proactively and meet deadlines.This position will require information management and analytic skills.

JUDGMENT AND DECISION MAKING
The rules set in agreed Deliverables will be used to regulate transactions between BU and the Region.

INNOVATION:
Supports continuous improvement by applying standardized processes and templates.

QUALIFICATIONS / COMPENTENCIES / SKILLS:


Foundational competencies
Analytical skills
Influencing and negotiation skills
Financial knowledge
Optimizing strategic relationships and networks
Attention to detail
Communicating effectively
Thinking systemically
Understanding the system
Acting as a team member
Planning and organizing
Demonstrating self-confidence

Leadership Behaviors: Leader of Self

• Drive Innovation – Generate new or unique solutions and embrace new ideas that help sustain our business (encompassing everything from continuous improvement to new product and package innovation).

• Collaborate with the System, Customers and Key Stakeholders – Develop and leverage relationships with stakeholders to appropriately stretch and impact the System (Company and Bottler).

• Act Like an Owner – Deliver results, creating value for our brands, our System, our customers and key stakeholders.

• Inspire Others – Inspire people to deliver our mission and 2020 Vision, demonstrate passion for the business and give people a reason to believe anything is possible

• Develop Self and Others – Develop self and support others’ development to achieve full potential

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

RELATED JOB REQUIREMENTS/ QUALIFICATIONS:
Minimum 3 to 4 years of experience
Accounting experience is a strong plus

EDUCATIONAL REQUIREMENTS:
Min Education: University/Bachelor’s degree
Preferred: Postgraduate/Master’s degree

PREFERRED QUALIFICATIONS:
CPA/ACCA/CIMA

CULTURAL DIVERSITY:
This position requires working in diverse environments and with multicultural teams.

TRAVEL REQUIREMENTS:
Minimal travel is required through BU locations.
.
ADDITIONAL INFORMATION:

The key success-criteria is:
Provides accurate analyses and reports
Meets deadlines
Because of the necessary interaction with other departments, good interpersonal relationships are essential.

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.

How to Apply


Submit your CV and Application online : Click Here