Country Commercial Reporting and Visualisation (Kenya) at Coca-Cola Beverages Africa (Group Office)

The role will contribute to CCBA vision by collecting, analyzing, interpreting and reporting all information related to Local Market sales in an on-going effort to optimize and increase sales productivity and support Commercial Director and sales teams.

Key Duties & Responsibilities    

1. Support Sales teams collecting sales records, evaluating performance based on key indicators and identifying possible watch outs, derailers or opportunities . 
2. Develop dashboards / scorecard to track sales performance and enhance understanding of the business to improve decision-making. 
3. Analyze Sales Trends (Brand wise / SKU wise at State / Distributor level) and prepare sales forecast and rolling estimates in collaboration with Demand Planning
4. Monthly sales reporting analysis by product and category, highlighting variances for the month and the year to date. Distributor Sales & Variance Analysis.
5. Monitor the performance of Sales Force through calculation / Distributor rewards and incentive programs. 
6. Preparing Analysis reports for Sales Promotional Campaigns and newly-launched brands and packs, enabling review and action by marketing team.
7. Maintain frequent routines with Sales teams for reporting and opportunity identification 
8. Create both standard and custom reports for Sales teams and Country GMs. 
9. Ensure sales data integrity and quality in the platforms and reports. 
10. Identify opportunities and recommend best practices for applying data mining to increase sales.

Skills, Experience & Education    

Qualifications:

1. Bachelor's Degree: Finance, Economics or Business Administration
2. Post Graduate Qualification advantageous

Experience:

1. 10+ of professional experience in building dashboards, scorecards and delivering reports
2. At least 3+ years of experience working Power BI / Tableau / QlikView / PowerPivot / Web based applications and other results-oriented products
3. Proven experience of approaching problem solving with curiosity and imagination
4. Demonstrated ability to lead and be creative/flexible in managing simultaneous projects, requirements and reporting schedules
5. Strong programming skills – Microsoft SQL, R, Python, DAX etc. and experience in implementing end to end BI technologies
6. Demonstrated track record of continued advancement of learning in new technologies and evolving skills sets
7. Data modelling and strong data analysis and critical problem-solving skills
8. Strong communication and interpersonal skills with the ability to convey technical concepts to other functional areas in simple language with a customer-oriented approach for understanding
9. Proven track record of simplifying large information inputs from multiple sources and consumable outputs that provide valuable insights

General    

The advert has minimum requirements listed.
Management reserves the right to use additional or relevant information as criteria for short-listing.