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;
Profile
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.