In Home Insights Analyst

Key roles and responsibilities:

Data Analysis

• Out of till data – Drive insight driven decision making from the data available.
• Prepare, analyze and report on a monthly/quarterly basis the Top end retail chains National/Regional/District volume and value share insights reports (including LADs, Beer, Cider and RTDs). This would include brand pack analysis. Highlighting trends and possible opportunities available.
• Share monthly Top end retail chains Regional/District volume & value shares to sales teams including outlet share reports.

SAP (SI) reporting

• Utilize SI reports to update on a monthly basis the Customer National/Regional and Total Key Accounts reviews
• Quarterly to update the regional presentations and attend Regional Key Account Trimester workshops
• Determine Annual volume targets by Key Account and Total
• Determine Monthly volume forecast for Total Key Accounts and track on a daily/weekly/monthly basis
• Determine and track Brand targets per Key Account

Other/General

• Deliver and upgrade current reporting to ensure we are meeting needs of key stakeholders.
• Attend meetings with the KAMs to present insights and analysis on a quarterly basis.
• Establish monthly targets by Key Account and Key Account Manager, set out by brand, pack and category.

Key Account reporting

• Work with the Revenue team, to track performance of Key Accounts business probability and aligned to business asks.
• Set Net Revenue per HL targets by Key Account and Total Key Accounts with Finance and track on a monthly basis

Trading Terms

• Key Operating Process (KOP)
• Coordinate and assist the Director Key accounts to draw up timetable for key deliverables of KOP process
• Create and update current templates for KAM’s to review
• Set up sessions with the GAMs and team to complete these templates
• Prepare, update and complete the Trading Terms Finance budgets by Key Account together with the KAMs, GM and Finance.
• Prepare and complete the Trading Terms Finance Budget presentation with the GM
• Work with GM to complete Trading Terms Finance Budget/MD presentation which include Market overview, Key account performance, Finance Budgets, Category and Push & pull integrated calendars review, which is presented to the Managing Director, Sales Director, General Managers, National Trade Marketing managers

Joint Business Planning (JBP)

• Assist the Key Account Manager in Joint Business planning process for select Retailers.
• Assist with the documentation and attend the Final JBP presentation.
• Drive JBP integration with business use through BEES Link.

Minimum requirement:

• 3-year Business Degree
• 5 years+ relevant commercial experience, including experience of best practice
• Minimum 3 years Off premise SAB or FMCG Trade Marketing experience with analytical capability at a high level
• MS Office – advanced Excel, PowerPoint, Word Ability to convert data into insights in the Key Account environment.
• Must have dealt with Nielsen and or IRI Aztec at senior level
• Ability to deal with senior key stakeholders within the organization
• Finance and analytical background are key for this individual to succeed in this challenging role
• Strong analytical ability to generate insights and recommendations out of data.