Junior Data Analyst (Intern)

  • Company: Moët Hennessy CIS
  • Country / Region : United Kingdom
  • Business group: Wines & Spirits
  • Contract type: Internship
  • Function: Finance
  • Experience required: Beginner
  • Reference No.: MHE01190
  • Date of publication: 2021.02.22


The objective of the role of the Junior Data Analyst is to support the Business Controller and Senior Manager in understanding and evaluating financial performance of the business by establishing budgets, reporting of actual results and performing variance analysis. Key to success is to manage big sets of data and bring them into a format that management can base their decisions on the analysis.


There are 3 main areas of responsibilities:


IT / Data


  • Manipulate and visualize big data sets with different tools to empower Management for effective decision taking
  • Develop dynamic ways to present reports to the management and other users


Consolidation of data and development of internal reports


  • Improve the ways of working existing internal reports to gain efficiency
  • Be creative and work on finding new ways of presenting data for Management review
  • Preparation of presentations for business reviews


Actual Financial Reporting & Forecasting:


  • Responsible for timely preparation of the mid-month forecast and monthly report for the region, highlighting the main variances and preparing draft comments on these variances;
  • Contribution to Budget, LE and R&O processes by collection and consolidation of information from distributor for further analysis by Business Controller;
  • Analyze distributors' Depletions, Shipments and Stock levels;
  • Ad hoc analysis on general business performance, per country, brand or product level;
  • Support the Business Controller in the monthly and quarterly A&P tracking;


Education: Bachelor and/or Academic degree in Business Analytics or Data Science; Finance/Business acumen is an advantage


Languages: Fluent in English


Professional experience & know how:

Two successful accomplished internships (min. 6 months) or one successful accomplished internship (min. 12 months) or a minimum of 6 months working experience in a comparable role;


Technical & management skills:

Data visualization tools such as QlikSense/PowerBI/Looker/Tableau

Data manipulation: experience with ETL (extract, transform, load) processes

Knowledge of SQL (optional)

Knowledge of programming such as VBA, R or Python

Good communicator with all levels and functions of the business.


Personal & interpersonal skills:

Integrity and rigor are a must, as well as proactivity and team spirit. Able to deal with ambiguity and priority setting. Representative, responsible and customer oriented. Curious and result oriented.

Additional information

Internship - 1 year