Divisional Performance Analyst at Diageo

Purpose of Role:

The Commercial Performance Analyst will be responsible for collecting, compiling and analysing sales & related data and providing valuable feedback and actionable insights to assist in the governance of commercial planning process

Top Accountabilities

Data management

• 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
• 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)

Vendor Management and internal Communications

• Manages the relationship vendors delivering non-Shopper and Channel activities – Branding and licences 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

• 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