Business Analyst - FMCG

SUMMARY:
Are you looking for an opportunity to relocate to Cape Town with your Business Analyst expertise?

Our International Client with their luxury brand of products in FMCG requires the expertise of a specialist Business Analyst for this critical role to manage commercial actual results and variance reports.

Join this high profile company with your minimum 8 years' experience at their Head Office in the CBD.
We require a driven, hardworking attitude combined with  analytical, mathematical and creative problem-solving skills for process reports, shipments, depletions & stock tracking.

Excel (macro, programming), PowerPoint, multi-dimensional tools (ESSBASE, EOS, & Microsoft database type) for developing tools to monitor commercial performance essential.

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.