Skip to content

RevOps

Sales analyst intern

Coty logoCotyBarcelona, B, SpainInternshipListed 3w ago

Tools for this application (partners): GotResumeBuilder (opens in new tab) (resume) · Careerflow (opens in new tab) (tracking) · Frontline Coach (opens in new tab) (interview practice) · Findymail (opens in new tab) (hiring manager's email) · Secta Labs (opens in new tab) (headshot) · micro1 (opens in new tab) (side work) what each does

The posting

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

  • 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.
  • 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).
  • 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.

Taken from Coty's own posting, last seen live on 17 Nov 2026.

Coty sales openings in your inbox

We look at Coty's careers page every 6 hours. Once a week you get its newest sales openings, plus close matches at other companies. Free, and one click stops it.

Sponsored

Sponsored jobs from job networks, which pay SalesJobs.Now when you click one.

About Coty

Prestige fragrance and makeup under brands such as Gucci, Burberry, Hugo Boss, Calvin Klein, Chloé, Marc Jacobs and Kylie Cosmetics, and mass beauty such as CoverGirl, Sally Hansen, Rimmel and Max Factor, sold to department stores, beauty chains, mass retailers and online marketplaces.

Pay schedule: Salaried employment with base pay stated in the US and Canada, up to half of each month remote for office roles under its omni-working policy, and fixed-term contracts on some German seats.

Running the systems behind a sales team?

Hiring managers ask us for sellers with a certain segment, territory or track record. Fill in one profile, and when a seat matches it we make the introduction, never without your yes. It costs you nothing.

Build my profile