Commercial Performance Analyst at Diageo

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.