Sales & Reporting Analyst at Coca-Cola

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