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 adecuado 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 advan]]>

📌 Sales analyst intern (Barcelona)
🏢 Coty España
📍 Barcelona