Business Analyst
Confidential
Posted: April 2, 2026
Interested in this position?
Create a free account to apply with AI-powered matching
Quick Summary
Business Analyst is responsible for supporting the Sales and Trade Marketing team with sales information and business insights, providing accurate daily forecasting and optimization modeling to achieve sales volumes.
Required Skills
Job Description
Overall Responsibility:
Support the Sales and Trade Marketing team with sales information and business insights.
Focus Area 1
Sales Forecasting
Sales volume forecasted by region/brand/district/account by day
Provide an accurate daily playboom on how the business will achieve its sales volumes
Regular updates
Ad-hoc forecasting for specific campaigns
Focus Area 2
Optimisation modelling
Create, test and roll-out a set of optimisation models across the sales spectrum
Focus Area 3
Sales Reporting
Daily sales reporting: Sales by business unit, sales vs playbook, sales vs customer retention target, sales by FSM, Daily sales handshakes reporting
FSM level push reporting
Month-end reporting (S+M accruals, draught throughput, sales incentives
Growth hurdle reporting
Monthly Market share analysis and reporting through the true data portal
Qlik reporting refreshed, always current
Repforce reporting weekly
Focus Area 4
Reporting on sales drivers (sales force inputs)
Refresh sales force automation survey's
Refresh sales force automation reports
Weekly National Sales Meeting report
Compile monthly commercial review
Compile weekly Regional Account and National Group account reports
Compile Monthly commercial review with international Brand Partners
Focus Area 5
Data Management
Retailer and Distributor data harvested and uploaded
Retailer & Distributor mapping in Qlik
Reconcile Qlik and Acumatica
Qlik Access & Rules
CMD Lock
True data Access & Rules
Focus Area 6
Develop, maintain and publish sales performance scorecards
Scorecards are developed annually and refreshed monthly
Sales force understanding developed through training and "noddy Guides"
Top performers identified on a Quarterly basis
Input provided into the annual awards process
Focus Area 7
Conduct Annual Market potential study
Conduct annual market potential study resulting and a set of strategic recommendations on volume growth as well as sales force market penetration
Use MPS Study information to provide recommendations for market positioning of NPDs
Use M&B study information to recommend switching on new sales areas
Focus Area 8
Key set of insights and strategic recommendations provided
Based on in-depth analysis, produce an ongoing set of strategic recommendations to senior leadership in the business
Based on in-depth analysis, produce an ongoing set of operational recommendations to sales leadership
Focus Area 9
Key Account Data analysis, administration and reporting
Customer Master Data Management in terms of segmentation, classifications and prioritisation
Administration of new listings, ranging and availability matrix
ML on sales data
Sales, price and inventory analysis across multiple group accounts
Design, analyse and populate end to end customer margin analysis
Predictive analytics on campaign alternatives
Provide Group Account Managers with weekly insight-packs which unpacks the SHP sales drivers
Support Group Account Managers with weekly site cover reports
Administration of the handheld-tool tasks and surveys and implementation tracking
Administration of the discounting Calendars and coordinate discounting processes
Budget administration with regards to DOTS reporting
Vendor administration with regards to Purchase Orders
Communicate monthly sales packs to S+M partners
Support Group Account Manager with day-to-day portal administration such as loading new listings, deals and price changes
Focus Area 10
Trade Surveys
Monthly in-trade and online price surveys on SHP and competitor offerings
Identify and analyse new product, consumer and market sales trends
Record, monitor and evaluate competitor activations in trade and Online
Evaluate in store stock rotation and S+M efficiency
Reporting to Group Account Managers on in-trade impressions
Identify new consumer mediums for Group Account Managers to explore
Focus Area 11
Team leadership: Business analytics centre of excellence
Lead a team of 3 analysts
Plan, execute and review team activities
Provide appropriate performance management capability
Manage for high performance
Focus Area 12
Trade Surveys
Monthly in-trade and online price surveys on SHP and Competitor offerings
Identify and Analyse new product, consumer and market sales trends
Record, Monitor and evaluate competitor activations in trade and Online
Evaluate in store stock rotation and S+M efficiency
Reporting to Group Account Managers on in-trade impressions
Identify new consumer mediums for Group Account Managers to explore
Requirements of the Role:
Qualification(s) in Business Science
Capable coder
Superior Office 365 skills, especially in Excel
Relevant years of work experience in the industry
Keen interest in the beer and liquor industry
Passion for the fast-moving consumer goods (FMCG) trade
Strong analytical proficiency
Strong administrative proficiency
This position is Cape Town-based
Preferred Skills/Competencies:
An individual that can work under pressure and consistently meeting deadlines
Sharp analytical capability
Solution Driven
Excellent planning and time prioritization management kills
Good communication skills
Positive attitude and optimistic
Manage duties with professionalism and energy
Strong desire and determination to succeed
Willingness to learn
NB: Specific duties/responsibilities will vary from time to time: the above list is intended to indicate the general nature of the post and is not exhaustive. The post holder will be expected to be flexible in supporting the business by undertaking any other responsibilities which are aligned with this job level.