DATA ANALYST TRAINEE

Why doing an intership at Eurofragance? In Eurofragance you will be part of the exciting world of smells and fragrances with our  Passion,  Performance  &  Entrepreneurship  values.
You will grow and learn in a company in constant growth and expansion.
You will have the opportunity to develop with top professionals in the sector.
You will be part of a Global Company with Headquarters in Barcelona and subsidiaries in Dubai, Singapore, Mexico, Turkey and India among others.
You will practice your language skills in a global and multicultural environment.
You will feel you play a role in society thanks to our Corporate Social Responsibility policy and our commitment to the Environment, which we demonstrate on a day-to-day basis with actions such as the Volunteer Day.
Enjoy a great work environment in Eurofragance! At our company, we're committed to creating an inclusive work environment where everyone feels welcome, regardless of their gender, age, sexual orientation, or any other factor.
We encourage candidates from all walks of life to apply for this job vacancy, and we extend a particularly warm welcome to those with disabilities.
MISSION.
Do you like “playing” with data to discover patterns that help business to take the best decisions? Are you looking always for continuous improvement and finding ways to automatize processes? Do you enjoy using excel or other analysis software? If you feel identified with the previous questions, you will delight to give support to our Business Strategic Analysis Team, focusing on calculating & analyzing Business drivers (KPI = Key performance indicators) and extracting & transforming data to provide insights for different functional areas.
FUNCTIONS.
Give support to the Business Strategic Analysis Team.
Gain a deep understanding of the main business drivers across all the areas of the company.
Sales, Operations, Product Development, Controlling, Finances, etc.
Bring new ideas to increase the automation of the current business reports in order to gain efficiency.
Generate recurrent reports for management and functional departments.
Create dashboard and analytical tools for different departments.
Extract and transform data from different sources.
SQL Server, Qliksense, Excels, SAP.
Resolution of incidents and queries related to the analysis of the information.
YOU WILL LEARN How to use Qliksense / Power BI tools to extract, transform and load data.
Advanced Excel / VBA Operational insights on how different departments work.
Basics of financial statements.
Basic understanding of SAP ERP.
Requirements Experience Required.
No experience required, this could be your first internship related to your studies, but it will be a plus if you had any other work experience before.
Passionate about data analysis Advanced user in Excel Advanced office tools knowledge Programming experience.
Python, SQL, VBA, etc.
We value.
Experience working with Qlik, Power BI or other visualization software Experience working with SAP or another ERP Experience in dashboards Education.
Currently Studying a technical university degree in Business Administration, Mathematics, Information technology.
Languages and level.
Spanish.
Native/Advanced English.
Advanced (fluent level will be strongly valuated) Personal Competencies.
Positive Energy Process oriented and organized Analytic mindset, Problem and result Oriented Team Work  Proactive Digital mindset What do we offer? A stable company with constant evolution and exciting environment;  Be part of a multidisciplinary team;  Stay healthy and active with free gym and paddle courts at the office; 720 €/month; Monday to Friday from 8AM to 14PM or from 9AM to 15pm; Casual and cool dress code; Perfume Boutique.
low-priced perfumes exclusively for our employees;  Brand new offices in Sant Cugat (just 20 minutes driving from Barcelona city) with free outdoor parking.
️Very Close to "Sant Joan" FGC Train Station.