Vacancy title:
Commercial Performance Analyst – BTL Insights & Analytics
Jobs at:
DiageoDeadline of this Job:
Saturday, April 08 2023
Summary
Date Posted:Saturday, April 08 2023, Base Salary: Not Disclosed
JOB DETAILS:
About the 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.
Reports To: Business Governance & Performance Manager
Role Responsibilities
Data management and Analysis
1. Create and updates the SFA system with all the approved activities for execution by the sales team.
2. Reviews the data changes processes to ensure compliance with business process and highlight any deviation for actions by the Commercial Performance Manager – BTL
3. Defines the structure of any additional data sets required to complete analysis of a given business problem, collects and cleanses the data for analysis.
4. Support with data quality assurance and data cleansing of existing data sets for analysis
Performance Reporting & Management
1. Engages with the divisional Commercial Performance Managers to identify issues affecting execution of BTL plan and updates for actioning by the Commercial Performance Manager – BTL
2. On an ongoing and ad hoc bases reports on and verifies daily, Weekly and monthly Key performance Indicators (KPI) are updated based on the customer marketing team needs
3. Identifying and understanding performance trends, assessing performance against targets and highlights opportunities
4. Process and analyze large datasets, producing clear findings and recommendations
5. Manage and book the calendar of the various stakeholders to execute the customer marketing routines.
Dashboard Automation and Change Management
1. Gathering and refining of requirements to build dashboards that address customer marketing team business needs, working with reporting tools including Power BI, Qlik sense.
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, SDP).
5. Develops monthly greenbook for commercial team that focuses on insights to direct business outcomes (NSV, volume and ROI).
Vendor Management and internal Communications
1. Manages the relationship vendors delivering non-Shopper and Channel activities – Branding and licenses for vehicles and outlets.
2. Tracks and follows through the approvals of NACADA and BCLB approval for activities.
3. Publication of the bi-weekly sales magazines.
Qualifications and Experience Required
1. A business-related degree or equivalent.
2. Advanced MS Excel and MS SQL skills
3. 2 years’ experience in analytics or sales role
4. Strong attention to detail.
5. Ability to follow defined business processes.
6. Ability to manage and monitor data quality.
7. Excellent interpersonal skills including the ability to influence
Work Hours: 8
Experience in Months: 24
Level of Education: Bachelor Degree
Job application procedure
Interested and Qualified, Click here to Apply
All Jobs
Join a Focused Community on job search to uncover both advertised and non-advertised jobs that you may not be aware of. A jobs WhatsApp Group Community can ensure that you know the opportunities happening around you and a jobs Facebook Group Community provides an opportunity to discuss with employers who need to fill urgent position. Click the links to join. You can view previously sent Email Alerts here incase you missed them and Subscribe so that you never miss out.