Position Summary:
- Gather data from diverse sources and report to the organization and in various TCCC systems.
- Lead and perform analyses and performance reviews to support operations and decision making across various levels of the organization.
- Lead monthly and weekly RE and assist in volume forecasting in the business planning process.
- Continuously seek to improve how the organization receives and uses data by finding efficient and innovative ways to collect, analyse and disseminate data and information.
Key Duties/Responsibilities:
1. Franchise Operations & Planning:
- Monthly Franchise Performance review and analysis by consolidating volume performance, forecasts, market shares and competitive intelligence and Operations KPIs. Circulate to Franchise Director and Market and Operations managers.
- Support Monthly RE process, aligning with Ops Managers, Franchise Director and Region GM and communication to stakeholders. Use statistical methods and qualitative input from stakeholders for by bottler Month x SKU RE calculation and submission to company systems. Update volume forecasts weekly according to market situation and communicate to Franchise Team and GM.
- Regular tracking of operations KPIs and communicating by bottler performance to operations teams and Franchise director.
- Custom performance analyses to support operations teams and management decision making process. Consolidating various data sources and preparing presentations for business needs.
2. Daily, Weekly & Month Volume Reporting:
- Prepare Morocco daily sales report: daily data collection from bottlers; updating formulas, data and descriptions; preparing narratives; preparing next month’s daily sales report.
- Prepare the weekly performance report: update weekly actual volume, prior forecasts and formulas; review and distribute the performance report to the market managers; consolidate information from the markets; review the region performance report and prepare communication and narratives for management and BU; prepare next month’s performance report.
- Prepare the monthly volume report, review reports for accuracy and distribute to organization with narratives.
3. Volume Systems:
- Update volume actuals in CPM for all bottlers on a regular weekly basis. Review for accuracy vs. bottler submission, maintain submission tracking sheets.
- Upload volumes, review volume accuracy across systems & bottler files and communicate volume closing to stakeholders.
Required Qualification:
- Intermediate level Project Management with 4+ years’ experience.
- Ability to understand business problems and support decision making process these through analysis of existing information.
- Ability to analyse the factual information to derive insights and business opportunities.
- Ability to reconcile between different sources of information to come to an informed decision.
- Strong analytical, quantitative and numerical skills and application of various techniques to derive insights, statistical modelling.
- Expertise in MS Excel, MS Access, SAS Spotfire; ability to quickly adopt new systems, tools and software to perform the job quickly and efficiently.