Commercial Planning Assistant Off-Trade

Moët Hennessy; City Of London; On-site; GBP 40,000 - 60,000; Full time

Job summary

A prominent luxury beverage company in London is seeking a Commercial Planning Assistant to support various teams in commercial operations. The role involves data management and analysis, reporting, and collaboration with stakeholders to enhance efficiency. Candidates should have strong Excel skills and a degree-level education. Experience in the Wines & Spirits industry is a plus. This position offers a dynamic work environment and the opportunity to contribute to key commercial strategies.

Qualifications

• Systems & data management experience in a commercial environment is a plus.
• P&L and value chain understanding.
• Ability to work with multiple stakeholders to improve overall efficiency.

Responsibilities

• Assist the sales team on their planning journey.
• Drive data collection, reporting and analysis.
• Support the commercial planning partner in consolidating data for key reports.

Skills

Strong Excel skills

Data visualization tool experience

Excellent communication skills

Team player

Education

Degree level education or equivalent experience

Tools

Power BI

Tableau

MS Office

Job description

Overview

Position: Working within the Revenue Growth & Planning team, the Commercial Planning Assistant is heavily involved in the day to day of MHUK commercial operations and value creations, working alongside various departments & especially the sales teams, delivering accuracy in volume & revenue forecasting to report the most robust data & optimize commercial strategies & sound decision making.

Responsibilities

• Commercial planning assistant for the following channel within MHUK: Off-Trade (Grocery, FWM, Specialists, C&C, Convenience, E-business)
• Commercial Planning: Assist the sales team on their planning journey
• Be the first point of contact for commercial investment for creation and amendment
• Support sales team to create new customers in SAP.
• Assist the commercial planning partner in challenging the accuracy of the volume, price and FTT forecast (full price waterfall)
• Update on a monthly basis forecast accuracy & variances PBI dashboards & share an update to key stakeholders with commentary on key evolutions
• Stock & Depletion Management: Drive data collection, reporting and analysis
• Process all the weekly data received from mass-retail customers, including communication to key stakeholders and BI tool management with commentary on key evolutions
• Maintain the multiple sources used in Power BI to keep accurate and up to date Off-Trade dashboards
• Support the commercial planning business partner to manage the end-of-year stock landing for key mass retail customers
• Allocation management: Be the key point of contact for the Sales team on the allocation topic
• Inform and follow up on all the topics discussed in allocation meetings
• Articulate monthly meetings with Marketing to help them monitor their allocations
• Tools Management: Assist the Commercial Planning Business Partner in the administration of the planning tool (Anaplan, Aspire & Power BI)
• Reporting: Support the commercial planning partner in consolidating the data for the key commercial reports
• Data Management & Analysis: Develop an expertise on our different BI tools: UK Business Planning, Qliksense, SAM…
• Understand the business concepts behind the data to be able to train different types of stakeholders
• Be able to understand the different roles in the company to adapt the trainings
• Develop analysis for key stakeholders of the Sales and Marketing teams

Profile

Education

• Degree level education or equivalent experience

Professional experience & know how:

• Systems & data management experience in a commercial environment is a plus
• P&L and value chain understanding
• Ability to work with multiple stakeholders to improve overall efficiency
• Interest in the Wines & Spirits industry is a plus

Technical Skills

• Strong Excel skills (Pivot tables, VLOOKUPS, SUMIFS), VBA is a plus
• Data visualization tool is a plus (Power BI, Tableau)
• MS Office (Outlook, Word, Power Point)

Personal & interpersonal skills

• Excellent communication & listening skills, team player
• Good organizational, time management & planning skills
• Rigorous, adaptable, autonomous, proactive
• Like to deal with numbers & data
• Ability to learn on the fly

Languages

• English
• Another international language is a plus