Commercial Planning Intern

MISSION

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 OF THE ROLE

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.

CANDIDATE’S 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