Job Description

From Arthur Guinness to Johnnie Walker, our business was founded on people of great character, and in 250 years, nothing has changed. We’re the world’s leading premium alcohol company. Our brands are industry icons. And our success is thanks to the strength of our people, in every role. It’s why we trust them with our legacy and reward them with the career-defining opportunities that they deserve. Our ambition is to create the best performing, most trusted and respected Consumer Products Company in the world. To achieve these, we need the world’s very best people. Feel inspired? Then this may be the opportunity for you.

Serengeti Breweries Limited (SBL) is a fully integrated beverage business in Diageo Africa (supply and demand for beer and spirits) It is a subsidiary of East Africa Breweries Limited (EABL), the largest business unit in Diageo Africa and the largest listed Company on the NSE in Kenya. SBL operates exclusively in Tanzania and is the second largest beer company with a market share of around 25%.

SBL was incorporated in 1988 as Associated Breweries Limited and changed its name to Serengeti Breweries Limited in 2002 and commenced commercial operations in 1996 with one brewery in Dar es Salaam. The company was acquired by EABL in October 2010 and has three breweries located in Dar es Salaam, Mwanza and Moshi.

SBL flagship brand is Serengeti Premium Lager. Other brand portfolios include Guinness and Plisner. Headquartered in Dar es Salaam, SBL is also the distributor of several global Diageo international renowned spirit brands such as Johnnie Walker®, Smirnoff Vodka®, Bailey’s Irish Cream ®, Richot®, Bond 7 Whiskey® and Gilbeys Gin®.

Role purpose

The Commercial Data Analyst will be responsible for collecting, compiling, and analysing sales and related data and providing valuable feedback and useful insights to guide the various business and RTC strategy initiatives within the company.

Top accountabilities

Data management

Reviews the data changes processes to ensure compliance with business process and highlight any deviation for actions by the Commercial Execution Lead.
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
Performance Reporting

On an ongoing and ad hoc bases report and verifies daily, Weekly and monthly Key performance Indicators (KPI) are updated based on the business & RTC team needs
Identifying and understanding performance trends, assessing performance against targets and highlights opportunities
Analytics capability support for the divisional distributor super user network
Process and analyze large datasets, producing clear findings and recommendations
Dashboard Automation and Change Management

Gathering and refining of requirements to build dashboards that address business & RTC teams business needs
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
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 manage and monitor data quality.

Good interpersonal skills including the ability to influence