Data analyst and digitalization intern

Coty; Barcelona; On-site; EUR 8,900 - 12,000; Full time

Job summary

Coty SA in Barcelona is seeking a motivated Data Analyst and Digitalization intern to support Quality Operations digital transformation. The role emphasizes moving from manual Excel processes to automated, data-driven solutions.

You will work with the Quality team to improve data visibility, reporting efficiency, KPI monitoring, and decision-making. The internship offers hands-on experience across data analytics, BI, and process automation.

Qualifications

• Currently pursuing studies in Business Analytics, Information Systems, Data Science, or related field.
• Strong analytical and problem-solving abilities.
• Proficiency in Excel and data handling.
• Experience with Power BI or similar visualization tools.
• Familiarity with SharePoint Lists and Microsoft 365.

Responsibilities

• Support digitalization of Quality Operations processes.
• Consolidate and analyze data from SAP, Power BI, SharePoint Lists, Power Apps and Excel.
• Help automate reporting and workflows to reduce manual effort.
• Develop and maintain dashboards and reports in Power BI.
• Monitor Quality KPIs and assist data cleansing and harmonization.
• Collaborate with teams to document processes and improvements.

Skills

Analytical skills

Problem solving

Excel proficiency

Power BI experience

SharePoint Lists

Power Automate

Education

Business Analytics

Information Systems

Data Science

Tools

Power BI

Excel

Power Apps

SharePoint

Microsoft 365

Job description

Data analyst and digitalization intern

Data analyst and digitalization intern - QC

6 months

Immediate starting

Barcelona

We are looking for a motivated intern to support the digital transformation of Quality Operations processes, helping the team move from manual Excel-based reporting and data manipulation towards automated, scalable, and data-driven solutions.

The intern will work closely with Quality team to improve data visibility, reporting efficiency, KPI monitoring, and decision-making processes. The role combines data analysis, process improvement, business intelligence, and digitalization initiatives.

This is an excellent opportunity for someone interested in Data Analytics, Business Intelligence, Process Automation, and Quality Operations within a global and multifunctional environment.

Key Responsibilities

• Support the digitalization of Quality Operations processes.
• Consolidate and analyze data from multiple sources (SAP, Power BI, SharePoint Lists, Power Apps, Excel files, and other business systems).
• Help transform manual reporting processes into automated and sustainable solutions.
• Assist in develop and maintain dashboards and reports using Power BI.
• Support the monitoring of key Quality KPIs such as:
• Quality Release Lead Time
• Pending Quality Stock
• Non Quality Events
• Inspections Performance
• Service Level Compliance
• Assist in data cleansing, validation, and harmonization activities.
• Support in identification of opportunities to reduce manual effort through automation and workflow optimization.
• Support the creation of data models and reporting structures to facilitate business decision-making.
• Collaborate with different teams to understand operational needs
• Document processes and digital solutions.
• Participate in continuous improvement projects related to Quality and Supply Chain operations.

Desired Skills & Qualifications

• Currently pursuing studies in:
• Business Analytics
• Information Systems
• Data Science
• or a related field
• Strong analytical and problem-solving skills
• Good knowledge of Excel and data handling
• Good knowledge of Power BI or similar visualization tools
• knowledge of Power Automate for workflow automation and process optimization
• Experience working with SharePoint Lists and Microsoft 365 collaboration tools
• Interest in digital transformation and process optimization
• Basic understanding of databases, automation tools, or data analysis is a plus
• Proactive attitude and willingness to learn
• Good communication skills and ability to work independently

What We Offer

• Hands-on experience in digital transformation projects
• Exposure to real business operations and decision-making
• Opportunity to develop technical and analytical skills
• Collaborative and dynamic work environment
• Possibility to contribute directly to efficiency improvements
• Understanding of Quality Control (QC) and Quality Assurance (QA) processes
• End-to-end quality workflows, including inspections, quality release, documentation management, deviation tracking, and KPI monitoring.
• How quality data is used to support operational performance, compliance, risk management, and continuous improvement initiatives

Country/Region: ES

City: Barcelona