The English-language job board for Spain

Sales Analyst Intern

On-site in Barcelona·Added 3 days ago (last checked 27 Oct)

Coty

26 open roles

Apply

Our summary

Work mode: On-site, Barcelona
Education: University degree

Visa options

The ad doesn’t mention sponsorship
Not a refusal, but not a yes. Worth asking in your first message.

Find jobs with visa support

Skills

Nice to have

Requirements

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.

The role

Job description

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.

About Coty

Coty is a global beauty company that develops, manufactures, and markets fragrances, cosmetics, and skin care products. With a portfolio that includes iconic brands such as CoverGirl, Rimmel, Max Factor, and a wide range of licensed fragrances from fashion houses like Gucci, Burberry, and Calvin Klein, Coty operates in over 150 countries and is one of the largest beauty companies in the world. The company is headquartered in New York City and has a significant global footprint, including manufacturing and commercial operations across Europe.

In Spain, Coty has a notable presence with offices in Barcelona, which serves as a key hub for its European operations, particularly in areas like supply chain, finance, and IT. The company's Spanish operations are part of its broader EMEA structure, and it employs a diverse workforce that often includes international professionals. Coty's work culture emphasizes innovation, diversity, and sustainability, making it an attractive employer for those looking to build a career in the beauty industry in Spain.

Industry: Cosmetics
Founded: 1904
Employees: 10,000–15,000
Headquarters: New York City, USA
In Spain: Barcelona

Good to know if you are moving

Coty's Barcelona office is a major European hub, offering opportunities in supply chain, marketing, and finance for international professionals.
The company operates in over 150 countries, providing a global career network and potential for international mobility.
Coty is committed to sustainability and has set ambitious goals for reducing its environmental impact, which may appeal to professionals interested in corporate responsibility.
The company's diverse brand portfolio offers exposure to both mass-market and prestige beauty segments, providing a broad industry experience.
Coty has a strong focus on innovation and digital transformation, creating opportunities for professionals with skills in e-commerce and data analytics.

All open roles at Coty