datatrota
Signup Login
Home Jobs Blog

Sales & Reporting Analyst at Coca-Cola

Coca-ColaRivers, Nigeria Data and Artificial Intelligence
Full Time
Coca-Cola is the most popular and biggest-selling soft drink in history. An icon of all times, Coca-Cola is the best-known product in the world. Created in Atlanta, Georgia, by Dr. John S. Pemberton, Coca-Cola was first offered as a fountain beverage by mixing Coca-Cola syrup with carbonated water. Coca-Cola was introduced in 1886, patented in 1887, registered as a trademark in 1893 and by 1895 it was being sold in every state and territory in the United States. In 1899, The Coca-Cola Company began franchised bottling operations in and outside the United States taking Coca-Cola to consumers in other parts of North America and Europe and in subsequent years to other parts of the world. In 1951, the refreshing wave of Coca-Cola arrived in Nigeria and has remained a hit with consumers across the country. Packages Coca-Cola is available in: 35cl and 50cl classic glass contour bottle; 33cl on-the-go Can, 50cl and 1.5L PET bottle. Ingredients Carbonated water, sugar, Carbon-dioxide, caffeine, Phosphoric acid, caramel color and flavouring.

ABOUT THE ROLE

  • Responsible for creating and providing sales reporting and insights to support the decision-making and strategic planning of NBC's Sales Team. 
  • Primary goal is to drive business growth by delivering actionable insights, performance reports, and strategic recommendations that empower the sales team to excel.

KEY RESPONSIBILITIES

Sales Performance Analysis & Reporting:

  • Generate daily, weekly, and monthly sales reports, including Order Generated Reports, Dealer Performance Reports, Weekly Volume-Outlook Reports, and Daily HGMM Reports, ensuring timely and accurate delivery to regional sales leadership. Develop and maintain KPIs, benchmarks, and targets for sales performance tracking, incorporating granular details for Key Accounts (LKA/NKA) and salesforce (FTE & NFTE).

Dashboard Development & Process Optimization:

  • Design and update dynamic dashboards and visualizations for Key Accounts, LKA KBI Dashboard, Performance Ranking Reports, and other key performance indicators. Collaborate with stakeholders to streamline and automate reporting processes, enhancing data accuracy, efficiency, and improving existing processes.

Sales Forecasting, Strategic Planning & Target Setting:

  • Create accurate sales forecasts and provide actionable insights to the sales management team, supporting data-driven strategic plans and resource allocation. Set monthly targets for the sales team based on released RE, ensuring alignment with variable pay targets across different product categories (SSD-RGB, SSD-PET, Juice, Energy, Water) for eligible salespersons (FTE and non-FTE) in all Sales regions.

Sales Incentive Program (SIP) Reporting & Variable Pay Calculation:

  • Track performance against targets, calculate mechanism payouts, and support the sales team with SIP reporting. Calculate variable pay performance at the end of each month and for quarterly, mid-year, and full-year performance review decks.

Ad-hoc Reporting & Special Projects:

  • Support sales leadership and other stakeholders with ad-hoc investigative reports, tracking region focus KBIs, and building decks for official market visits. Assist in preparing files for the Leadership Team meeting and providing insights from regional performance, when necessary.

ARE THESE YOUR SECRET INGREDIENTS?

  • Strong analytical skills, identifying business trends/patterns and communicating effectively.
  • Results-driven, able to work autonomously and collaboratively to achieve business goals.
  • Demonstrated leadership, using available business tools to deliver results within set timeframes.
  • Proficient in Microsoft Office Suite, particularly Excel and PowerPoint. Experience with complex datasets is a plus.
  • Collaborative approach to process improvement.

EDUCATION & EXPERIENCE:

  • B.Sc. or HND, preferably in an analytical subject area (e.g., Statistics, Mathematics, Economics).
  • Minimum 3-5 years’ experience, preferably in the FMCG space

Method of Application

Signup to view application details. Signup Now
X

Send this job to a friend