Job Title: Divisional Performance Analyst
Seniority Level: Associate
Reports To: Business Governance & Performance Manager
About Us
EABL operates within a multi-cultural, multinational, multi-currency environment. EABL comprises four business units: KBL, EAML, CGI and UBL. KBL is further categorized into Demand and Supply.
The Supply business is involved in the production of beer and spirits. The Demand business is involved in marketing and selling the product to consumers.
This role is located within the Demand Sales business. The Commercial Performance Analyst - Sales Force Effectiveness (SFE) and Route to Consumer (RTC) analyst role will be crucial to the overall KBL short-, medium- and long-term strategy in developing and driving our trade strategy and operational excellence within retail outlets and distributors.
Want more jobs like this?
Get jobs in Nairobi, Kenya delivered to your inbox every week.
The job holder works closely with the Business Governance & Performance Manager, Commercial performance manager- BTL, SFE & RTC, Divisional commercial performance managers, Commercial performance analysts.
Purpose of Role
The Commercial Performance Analyst will be responsible for collecting, compiling, and analyzing sales & related data and providing valuable feedback and actionable insights to guide the various commercial planning process.
Role Responsibilities
Data management and Analysis
- Build and update the SFA performance dashboards and input for changes required on automated dashboards - CPD, Power BI.
- Reviews the data changes processes to ensure compliance with business process and highlight any deviation for actions by the Commercial Performance Manager - SFE
- Defines the structure of any additional data sets required to complete analysis of a given business problem, collects and cleanses the data for analysis.
- Support with data quality assurance and data cleansing of existing data sets for analysis. On a continuous basis support customer marketing team on performance for innovation brands performance, listing and development of channel performance dashboards.
Performance Reporting & Management
- Engages with the divisional Commercial Performance Managers to identify issues affecting execution metrics for SFE, Innovation products and updates for actioning by the Commercial Performance Manager - SFE.
- On an ongoing and ad hoc bases report on and verifies daily, Weekly, and monthly Key Performance Indicators (KPI) are updated based on the business needs, makes recommendations, and keeps sales teams (Distribution and sales force) accountable.
- Identifying and understanding performance trends, assessing performance against targets and highlights opportunities
- Process and analyze large datasets, producing clear findings and recommendations.
- Book the calendar of the various stakeholders to implement the customer marketing routines.
Dashboard Automation and Change Management
- Gathering and refining of requirements to build dashboards that address customer marketing team business needs, working with reporting tools including Power BI, Qlik sense.
- Develops tests and trains the team to navigate and generate insights from the dashboard developed.
- Develops a business case on any additional enhancements that are not within the current system capabilities.
- User Acceptance Testing (UAT) on enhancement build in the existing systems (DMS, Trax, CPM, SDP).
- Develops monthly green book for commercial team that focuses on insights to direct business outcomes (NSV, volume and ROI).
Qualifications and Experience Required
- A business-related degree or equivalent.
- Advanced MS Excel and MS SQL skills
- 2 years' experience in analytics or sales role
- Strong attention to detail.
- Ability to follow defined business processes.
- Ability to handle and monitor data quality.
- Excellent social skills including the ability to influence.
Our ambition is to build the best performing, most trusted and respected Consumer Products Company in the world. To achieve these, we need the world's very best people. We're looking for people with creativity, boldness and a sense of purpose to take Diageo and our timeless, pioneering brands to the next level.
Feel inspired? Then this may be the opportunity for you.