FMCG Business Analyst

SUMMARY:
Do you 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.