Sales analyst intern
At a glance
Junior Revenue & Sales Operations role at Coty. Barcelona.
Pay not stated Revenue & Sales Operations salary
growthroles summary, based on the employer's posting.
What you'll do
- Automate sales-data consolidation with Power Query, then build efficient Power Pivot models for commercial use
- Create Excel templates for KAMs and managers, combining sales, forecast, targets and coverage data
- Build clear dashboards and automate recurring reports on sell-in, channel mix, past performance and forecast coverage
- Prepare reporting templates for executive presentations and help create Power BI visualizations
- Improve team processes, document procedures, check data quality and equip commercial colleagues with practical tools
What you bring
- A degree in computer engineering, telecommunications, mathematics, statistics, data-focused business administration or a related field
- Advanced Excel ability, with practical experience or strong knowledge of Power Query, Power Pivot and data modeling
- You can handle large datasets while keeping models responsive, and bring strong organization and attention to detail
Who this fits
This junior internship suits someone with a technical or analytical background who wants to support commercial reporting and data workflows. The role is based in Barcelona, starts in November and runs for six months. You’ll work with commercial and management teams.
From the employer
Sales Analyst intern
Coty Barcelona
November starting
6 months
We are looking for a Junior Data Analyst / Intern with a strong technical orientation to join Coty’s analytics team. This role will provide direct support in process optimization, report automation, and the management of large volumes of sales, forecast, customer, and channel data.
The ideal candidate will have a background in IT or engineering and hands-on knowledge of data analysis and modeling tools—especially Power Query, Power Pivot, advanced Excel, and/or Power BI—ensuring that data models are fast, robust, and easy to use for the commercial team.
Key Responsibilities
1. Data Automation & Modeling
-
Design and automate data consolidation processes using Power Query.
-
Build efficient and optimized models with Power Pivot (linked tables, relationships, simple DAX measures).
-
Reduce file size and refresh times through best modeling practices.
-
Design Excel structures and templates for KAMs and managers.
-
Integrate multiple data sources (sales, forecast, targets, coverage).
-
Create clear, lightweight, and user-friendly dashboards.
-
Ensure scalable structures for future enhancements.
2. Reporting & Business Intelligence
-
Automate recurring reports (sell-in, channel mix, historical performance, coverage vs. forecast).
-
Prepare reports and templates for executive presentations.
-
Support the creation of advanced visualizations (Power BI is a plus).
3. Maintenance & Continuous Improvement
-
Identify improvement opportunities within internal team processes.
-
Document procedures and ensure data quality.
-
Support the commercial team with technical tools that facilitate daily work.
Technical Requirements
Must-have:
-
Degree in Computer Engineering, Telecommunications, Mathematics, Statistics, Business Administration with Data focus, or similar.
-
Advanced Excel skills.
-
Practical experience or solid knowledge of:
-
Power Query (M)
-
Power Pivot
-
Data modeling
-
Pivot tables and slicers
-
Ability to work with large datasets without impacting performance.
-
Strong organizational skills and attention to detail.
Nice to have:
-
Knowledge of DAX.
-
Experience with Power BI or SQL.
-
Basic programming skills (Python, VBA, or similar).
Soft Skills
-
Problem-solving mindset, methodical approach, and continuous improvement orientation.
-
Strong analytical skills and logical, structured thinking.
-
High attention to detail and data quality.
-
Clear communication skills and ability to work with commercial and management teams.
-
Proactive attitude to propose technical improvements.
Revenue & Sales Operations work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Revenue & Sales Operations
Find me workBy the team behind growthroles.