CSP Senior Planner

Coty SA; Barcelona; Hybrid; EUR 70,000 - 90,000; Full time

Benefits offered by this job

Remote work up to 50%

Job summary

Coty is seeking a Senior Planner CSP Reporting to join the Barcelona Planning HUB. You will develop, automate and maintain data solutions and reporting tools supporting critical planning processes across the Barcelona Planning HUB.

From inventory reporting to material call-offs and process automation, you will help ensure that planning teams have reliable data and tools to make decisions and run their operations efficiently.

Qualifications

• Around 7 years of experience with SQL, databases, data automation, reporting, BI or similar technical environments.
• Strong practical experience with SQL and Python for data extraction, transformation and process automation.
• Good understanding of databases, relational data structures, data modelling and ETL processes.
• Experience developing or maintaining reporting and automation solutions.
• Experience with Power BI, Power Query, DAX and/or Power Automate is highly valued.
• Experience with SAP and Supply Chain / Planning processes is a strong advantage.
• Fluent English is required; Spanish is a plus.

Responsibilities

• Build and automate data solutions for planning using Python, SQL, databases and Power BI.
• Create tools and reports transforming complex data into actionable information for planning teams.
• Automate recurring activities to reduce manual work and increase process efficiency.
• Support ETL processes integrating data from sources like SAP S/4HANA, SAP BW/4HANA, Oracle, SQL databases, local files, SharePoint and Power BI dataflows.
• Develop and enhance data models, queries and reporting solutions.

Skills

SQL

Python

Data automation

Data analysis

Power BI

Power Query

DAX

Power Automate

Data modeling

Communication skills

Tools

SAP S/4HANA

SAP BW/4HANA

Oracle

SQL databases

SharePoint

Power BI dataflows

Job description

CSP Senior Planner

CSP SENIOR PLANNER

SUPPLY CHAIN

Barcelona Planning HUB is recruiting a SENIOR PLANNER CSP REPORTING

In this role, you will be the technical expert connecting data, automation and Supply Chain Planning. You will develop, automate and maintain data solutions and reporting tools supporting critical planning processes across the Barcelona Planning HUB.

From inventory reporting to material call-offs and process automation, you will help ensure that planning teams have reliable data and tools to make decisions and run their operations efficiently.

THE ROLE

OPTIMIZE, ENABLE, INNOVATE!

As our Senior Planner CSP Reporting , you will play a critical role in transforming data into reliable tools and insights for the Planning organization.

You will combine strong technical expertise in SQL, Python and databases with an automation mindset to improve existing solutions, build new tools and ensure that critical reporting and processes continue to run effectively.

Your work will directly contribute to process efficiency, data reliability and business continuity , supporting teams across MPS, DRP, Materials, CSP and other functions within the Planning HUB.

You will be part of the CSP organization and will manage:

BUILD & AUTOMATE DATA SOLUTIONS

• Develop and automate reporting and planning solutions using Python, SQL, databases and Power BI .

• Build new tools and reports that transform complex data into actionable information for Planning teams.

• Automate recurring activities to reduce manual work, increase process efficiency and improve data accuracy.

• Support ETL processes integrating data from sources such as SAP S/4HANA, SAP BW/4HANA, Oracle, SQL databases, local files, SharePoint and Power BI dataflows .

• Develop and enhance data models, queries and reporting solutions supporting business needs.

ENSURE RELIABLE PLANNING TOOLS & DATA

• Maintain and improve existing reporting, automation and data solutions, including tools leveraging Coty's data lake environment.

• Ensure business-critical tools continue to operate reliably and troubleshoot issues when they arise.

• Support processes such as inventory reporting, material call-offs, cash, VAR, destructions and discontinuation.

• Identify data or system issues, develop solutions and implement improvements to prevent recurring problems.

• Ensure data accuracy and integrity across reporting and planning tools.

DRIVE DIGITAL & PROCESS EFFICIENCY

• Identify opportunities to automate and simplify existing Supply Chain processes.

• Translate business requirements into fit-for-purpose technical solutions.

• Partner closely with MPS, DRP, CSP, Materials, Finance, Quality and IT to understand needs and improve ways of working.

• Create solutions that improve both process and team efficiency.

• Contribute to the continuous development of reporting and digital capabilities within the Planning HUB.

YOU ARE A COTY FIT

As a technical and data-driven professional, you enjoy understanding how processes work and translating business needs into smart, reliable technical solutions. You are analytical, structured and hands-on, and you are equally comfortable building something new and ensuring existing solutions continue to perform reliably .

You will be the key technical specialist within the team , so you are comfortable working autonomously while collaborating closely with Planning teams and other technical stakeholders.

• Around 7 years of experience working with SQL, databases, data automation, reporting, BI or similar technical environments.

• Strong practical experience with SQL and Python for data extraction, transformation and process automation.

• Good understanding of databases, relational data structures, data modelling and ETL processes .

• Experience developing or maintaining reporting and automation solutions.

• Experience with Power BI, Power Query, DAX and/or Power Automate is highly valued.

• Experience with SAP and Supply Chain / Planning processes is considered a strong advantage.

• Strong analytical mindset with high attention to data accuracy and process reliability.

• Ability to troubleshoot technical issues and translate business requirements into effective solutions.

• Strong communication skills, with the ability to explain technical topics clearly to business users.

• Organized, structured and comfortable managing different priorities in a fast-moving environment.

• Strong collaboration skills across technical and business teams.

• Fluent English is required; Spanish is a plus .

At Coty, we value data savvy people. As part of the Coty curated strategic program, we are transforming into a data centric organization powered by AI. If you have data engineering skills or experience developing dashboards in Power BI, this is considered a strong advantage.

If you're ready to support and shape the future of beauty, we want you on our team!

WHAT WE OFFER

This is a unique role with a genuine opportunity to make an impact. As a key technical expert within the team, you will have the opportunity to build and improve solutions used across our Planning organization, combining technology, data and Supply Chain in a highly cross-functional environment.

You'll get to work in a diverse environment with a team of professionals who are passionate about the work they do and know how to have some fun along the way.

Coty's global omni-working policy provides the option to work up to 50% of your month remotely. We believe that a more flexible philosophy of remote working will give everyone the freedom to choose what works for their individual circumstances and empower them to always perform at their best.

ABOUT US

Our people make us who we are. They are the brightest minds bringing the boldest ideas to life every day. If you're the kind of person who refuses to settle, if you want to think bigger, learn faster and go further than you ever thought possible – we'd love to hear from you.

Coty is deeply committed to Changing the Conversation around Diversity, Equity & Inclusion to create a more open, inclusive, and diverse workplace where all employees can be their authentic self.

Country/Region: ES

City: Barcelona Hub