Commercial Performance Analyst at Diageo

About the role

This role is located within the Demand Sales business. The Commercial Performance Analyst role will be critical to the overall KBL short, medium and long term strategy in developing and driving our spirits and RTC strategy and operational excellence within retail outlets and distributors.

The job holder works closely with the Commercial Performance Manager – RTC & Spirits, Head of Spirits and RTC, Regional Spirits and RTC Development Managers.

Dimensions

Financial

Management of the Sales teams and sales tools to assure return on EABL’s investment through volume and NSV growth.

Market Complexity

KBL demand has 96% volume share of beer market and 52% volume share for Spirits. KBL demand is the No.1 FMCG Company in Kenya and also markets UDV brands. KBL operates in a very competitive environment that has seen the entrant of new players in the total alcohol category. This necessitates the need for pro-active business approach. The national distribution structure within the Kenyan alcohol market is key to KBL delivery of both volume growth and market share.

Market situation is changing rapidly due to the economic situation, declining disposable incomes, County Government legislation on Alcohol and opening up of the economic trading blocks allowing in flow of products from other markets. Consumers are becoming more sophisticated in the choice of drinks offered in the market.  This requires proactive selling to maximise company market share and value share. Trade is evolving and being more sophisticated especially at retail level.  

Purpose of the Role

The Commercial Performance Analyst will be responsible for collecting, compiling and analyzing sales and related data and providing valuable feedback and actionable insights to guide the various spirit and RTC strategy initiatives within the company

Top Accountabilities

1. Data management 
   1. Reviews the data changes processes to ensure compliance with business process and highlight any deviation for actions by the Commercial Performance Manager – RTC & Spirits
   2. Defines the structure of any additional data sets required to complete analysis of a given business problem, collects and cleanses the data for analysis
   3. Support with data quality assurance and data cleansing of existing data sets for analysis 
2. ​Performance Reporting 
   1. On an ongoing and ad hoc bases reports on and verifies daily, Weekly and monthly Key performance Indicators (KPI) are updated based on the spirits & RTC team needs
   2. Identifying and understanding performance trends, assessing performance against targets and highlights opportunities
   3. Analytics capability support for the divisional distributor super user network
   4. Process and analyze large datasets, producing clear findings and recommendations
3. Dashboard Automation and Change Management 
   1. Gathering and refining of requirements to build dashboards that address Spirit & RTC teams business needs
   2. Develops tests and trains the team to navigate and generate insights from the dashboard developed
   3. Develops a business case on any additional enhancements that are not within the current system capabilities.
   4. User Acceptance Testing (UAT) on enhancement build in the existing systems (DMS, Trax, CPM,)

Qualifications and Experience Required

• A business-related degree or equivalent.
• Advanced MS Excle and MS SQL skills
• 2 years’ experience in analytics or sales role
• Strong attention to detail.
• Ability to follow defined business processes.
• Ability to manage and monitor data quality.
• Excellent interpersonal skills including the ability to influence