Commercial Performance Analyst – BTL Insights & Analytics at Diageo

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

• Create and updates the SFA system with all the approved activities for execution by the sales team.
• Reviews the data changes processes to ensure compliance with business process and highlight any deviation for actions by the Commercial Performance Manager – BTL
• 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 & Management

• 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
• 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
• Identifying and understanding performance trends, assessing performance against targets and highlights opportunities
• Process and analyze large datasets, producing clear findings and recommendations
• Manage and book the calendar of the various stakeholders to execute 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 greenbook for commercial team that focuses on insights to direct business outcomes (NSV, volume and ROI).

Vendor Management and internal Communications

• Manages the relationship vendors delivering non-Shopper and Channel activities – Branding and licenses for vehicles and outlets.
• Tracks and follows through the approvals of NACADA and BCLB approval for activities.
• Publication of the bi-weekly sales magazines.

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.
• Excellent interpersonal skills including the ability to influence