FMCG Business Analyst

SUMMARY:
Are you wanting to relocate to Cape Town and have experience in managing commercial actual results and variance reports for critical decision making in an FMCG company?
 
Our International client at their Head Office in CPT CBD, requires 8 years’ experience to use your analytical, mathematical and creative problem-solving skills for process reports, shipments, depletions & stock tracking.
 
Essential experience: Excel (macro, programming), PowerPoint, multi-dimensional tools (ESSBASE, EOS, & Microsoft database type) for developing tools to monitor commercial performance.

POSITION INFO:
REQUIREMENTS

• Relevant degree required
• Strong knowledge of Excel (macro, programming), PowerPoint, multi-dimensional tools (ESSBASE, EOS, Microsoft database type) are necessary
• Minimum 8 years’ experience in business controlling and/or finance, preferably in the FMCG industry
• Strong financial planning/analysis skills & exp generating process documents & reports
• Good business understanding, interested in sales and marketing
• Local experience required
• Excellent analytical, mathematical, and creative problem-solving skills
• Integrity and rigor are a must, as well as proactiveness and team spirit.
• Excellent listening, interpersonal, written, and oral communication skills
• Logical, efficient, self-motivated with excellent attention to detail
• Ability to effectively prioritize and execute tasks while under pressure
• Strong customer service orientation & exp working in a collaborative team
• Able to exercise independent judgment and take action on it
• Comfort with ambiguous, ever-changing situations

• Analyse sales process reports - sales activity, sales opportunities, average time to close, win and loss characteristics, to identify areas for improvement in the sales process.
• Assist sales teams with sales reporting.
• Report business performance - monthly shipments/depletions/stock tracking, identifying risks & opportunities vs forecast
• Focus on developing and monitoring compliance with commercial strategy.
• Develop tools to monitor and develop commercial performance (Power BI dashboards).
• Train local team to maximize tools utilisation.
• Partner with GM with Business Reviews, 5-year forward plan update & Brand Planning a
• Lead continuous improvement with team to ensure cross-functional performance.
• Support cluster Market Managers with dedicated analyses.
• Budget forecasting - file creation, export, checks, and review with Market Managers
• Study of alternative pricing solutions.
• Coordinate orders management with supply chain.
• With Demand Planning team reduce the variance vs forecast planning.
• Prepare monthly reporting file to analyse and control invoices received from distributors.
• Coordinate POSM follow-up on budget side as well as supply chain.
• Identify risks & opportunities to optimise spending and forecasting.
• Prepare monthly and end of year accruals in coordination with accounting department
• Anticipate credit limit issues to ensure orders’ on-time delivery
• Monitor sales operating procedures and controls
• Timely reporting of issues, if needed, and implement corrective actions.
• Coordinate internal and external audits / reviews.
• Timely implementation of action plans arising from audits & internal control reviews.