The Coca-Cola Company Job Vacancy in Kenya : Volume Analyst

The Coca-Cola Company Job Vacancy in Kenya : Volume Analyst
February 19, 2015 Job Description

The closing date for this role will be 3rd March 2015.JOB SUMMARY:
To gather and consolidate forecast and actual sales volume data from multiple sources, upload the data into the company’s database systems, and prepare regular high quality analytical reports that are required by the Business Unit Leadership Team (BULT) and other stakeholders, to facilitate timely and effective decision-making that is essential for meeting the Business Unit’s sales volume targets
To engage with country teams to gain a clear understanding of the complexities and internal/external factors driving volume performance (including business initiatives that are underway to enhance volume growth) and to share the relevant insights with multiple stakeholders through (a) a weekly narrative that is required by the Business Unit President, (b) presentations during Business Unit Rolling Estimate meetings, and (c) informal discussions with the Strategy & Business Planning Director, the Finance Director, Franchise General Managers and other managers on an on-going basis throughout the year.
To be the BU’s central point of contact for volume analysis and reporting; as well as Subject Matter Expert on all systems and databases relating to volume data gathering, analysis and reporting

KEY DUTIES/RESPONSIBILITIES :
Sales Volume Forecasting:
Provide relevant volume analysis/charts required for business planning and forecasting purposes
Support the Strategy and Business Planning Manager and the Strategy and Business Planning Director in ensuring full alignment in (a) volume estimates submitted by country teams, (b) volume estimates used in developing the financial rolling estimates for franchise territories in the BU, and (c) the volume rolling estimates approved by the Business unit President for submission to Group and/or Corporate Headquarters
Daily volume tracking and analysis:
Update the Compass/Dashboard system with Bottler unit case sales data
Carry out the necessary reconciliations and quality checks on an on-going basis to ensure that the data in the system is accurate
Weekly volume analysis and reporting to the Business Unit Leadership team and Group:
Prepare the Weekly Sales Volume Report 3 times a week as per stipulated templates and timelines
Prepare weekly and monthly narratives outlining key drivers of volume trends
Monthly volume analysis and reporting to the Business Unit Leadership team and Group:
Prepare and publish volume data in BOFC on or before 12:00 noon on Wednesday of Week 1 every month
Engage with country teams to gain a clear understanding of the complexities and internal/external factors that are driving volume performance (including business initiatives that are underway to enhance volume growth)
Make presentations to multiple stakeholders during Business Unit Rolling Estimate meetings to share the relevant insights on volume performance
Prepare other monthly volume reports that are required for monthly rolling estimates and for presentation to the Business Unit Leadership Team (BULT) during monthly BULT meetings
Quarterly volume analysis and reporting to Corporate and the CAPPRs programs:
Prepare quarterly volume reports that are required for purposes of reporting on the performance of on-going CAPPRs programs, in accordance in the guidelines in the Company’s Standard Practices and Procedures Manual
Volume tracking and reporting for Customer/Bottler incentive programs:
Support the Business Unit President’s Executive Assistant in tracking sales volumes for all incentive programs, including the Annual Bottler Incentives and the Olympic Incentive Program
Other:
Conducting training periodically on the use of the company’s tracking and reporting systems (including the COMPASS system)
Engaging with BU and Corporate IT regarding rollout of upgraded volume tracking and reporting systems
Keep in safe custody (clearly marked “Classified – Confidential” on all pages) all records used in (a) updating the BU’s volume databases, and (b) preparing volume reports submitted to Group and Corporate Headquarters — including the monthly sign-off sheets duly signed by Franchise Business Analysts, to ensure a complete audit trail in accordance with the Company’s internal control guidelines
Attend to other ad hoc requests for volume information from the Corporate, Group and BU leadership.

ORGANIZATION IMPACT/ INFLUENCE:

Interaction with:

External
Bottlers: Gathering actual sales volume data

Internal

Business Analysts: Gathering actual/forecast sales volume data/ Follow-up on explanation of volume trends
Seeking deep insights on factors driving volume performance

Franchise General Managers: Sharing weekly and monthly sales volume reports/analysis
Presentation of monthly volume performance

Financial Planning and Analysis Manager: Sharing weekly and monthly sales volume reports/analysis

Finance Director: Sharing sales volume reports/analysis

Strategy Analyst: Sharing weekly and monthly sales volume reports/analysis

Strategy & Business Planning Manager: Line manager

Strategy & Business Planning Direct: Function head

BUP Executive Assistant: Sharing sales volume reports/analysis
Communicating insights on factors driving actual volume performance
Communicating on-going and planned volume driving business initiatives


Business Unit President: Sharing sales volume reports/analysis
Communicating insights on factors driving actual volume performance
Communicating on-going and planned volume driving business initiatives

RELATED JOB REQUIREMENTS/ QUALIFICATIONS:

Technical Skills:
Forecasting
Analytical skills
Computer skills (advanced MS Excel and PowerPoint)
Basic knowledge of SPSS
Use of COMPASS volume system
Statistical reporting (numerical and written)

Generic Competencies:
Imports and Exports Good Ideas
Delivers Results
Balances Immediate & Long-Term Priorities
Lives the Values

Required Experience
Analytical thinking and effective communication and influencing skills
Knowledge of statistics, data collection, analysis, and data presentation
Attention to detail
Excellent oral and written communication skills
Effective interpersonal and presentation skills
Strong business thinker with experience in analyzing data
Advanced analysis skills
Exposure to MS Excel
Preparation of presentations using PowerPoint
Use of COMPASS and Dashboard systems
Basic understanding of KO business

EDUCATIONAL REQUIREMENTS :
Undergraduate degree

CULTURAL DIVERSITY:

Responsibility and Interaction with:
Multiple ethnic and cultural exposure – internally and externally. Fluency in English essential. Working knowledge of French would be an added advantage

ANALYSIS:
Handling data extracted from different software systems and developing new approaches of feeding the data into the company’s volume databases with minimal effort and without any errors
Dealing with unexpected delays in data submission from different countries and figuring work around solutions for purposes of volume reporting within the strict BU, Group and Corporate reporting deadlines
Working with multiple stakeholders to ensure that volume forecasts at country level are fully aligned with consolidated forecasts at BU and Group level
Investigating vigorously the underlying reasons for significant variances between actual and forecast volume data; and sharing the relevant feedback with all the relevant stakeholders in the Business Unit timely
Testing and working with different statistical volume forecasting models and making recommendations on suitable changes to existing models
Collaborating with IT to resolve any problems with volume database systems

JUDGEMENT AND DECISION MAKING
Making recommendations regarding daily, weekly, monthly and annual sales volume estimates for purposes of periodic volume reporting to management, as well as for the monthly rolling estimate and annual business planning purposes.

WORKING CONDITIONS :
There is no risk of exposure to any hazard.

TRAVEL REQUIREMENTS :
Potential 5% travel within the BU for training purposes

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