Description de l'entreprise :

We are a human-scale, international and independent pharmaceutical group governed by a Foundation. Our unique model is a source of pride and, above all, enables us to fully deliver on our purpose: “Committed to therapeutic progress for the benefit of patients.”

Today a global leader in cardiology, we have chosen to become a focused and innovative player in oncology by 2030, targeting cancers that are difficult to treat and dedicating more than 70% of our R&D budget to this ambition. We pursue this challenge while continuing to develop our generics business, helping to provide access to high-quality, affordable healthcare for all.

Who are we? 22,000 passionate people representing more than 50 nationalities, driven by an entrepreneurial spirit. Every day, we move forward with and for patients, with and for our teams, inspired by the desire to care, to dare, to grow and to make a meaningful difference for those who need it most.

Join us and help bring our commitment to life. #MovedByYou

Description du poste :

Servier is a leading French pharmaceutical group is replacing its packaging item management system with a new global platform for artwork and labelling management (ePALMS). Its medicines go to more than 150 countries.

We're looking for an intern to work directly with the Data Migration & Governance Lead. You'll help design the target data model, prepare and run the migration, and build the governance rules the new system will run on. This is hands-on work on a live, regulated programme.

What you'll do

Map data and attributes from the legacy tool, SharePoint and shared drives to the target ePALMS data model
Profile, clean and consolidate legacy data: find duplicates, inconsistencies, obsolete items, correct links and find gaps
Build and maintain data loading templates, transformation rules and the mapping documentation
Help define naming conventions, data ownership (owners and stewards) and data quality rules
Track migration progress and data quality KPIs in dashboards (Excel / Power BI)
Take part in manual migration waves and the quality checks (reconciliation, sampling, SME validation)
Prepare workshop materials and record decisions in the decision log and the risk and gap register
Look at how ePALMS connects to the group's other systems: MDM,RIMS,SAP

What you'll learn

How a full migration runs in a GxP environment, from scoping to cut-over
How to set up data governance in practice, not just in theory
Pharma packaging and artwork processes, which few young professionals get to see
Working with business SMEs, IT and programme leadership in a global organisation

Description du profil :

Your profile:

Required skills:

Final-year Bac+5 student from an engineering school, business school or university. Relevant fields: Data Management, Information Systems, Supply Chain, or Industrial/Pharma Engineering
Strong Excel skills: Power Query, pivot tables, lookups. You enjoy structuring messy data
Comfortable with data modelling basics: entities, attributes, keys, reference data
Rigorous and detail-oriented. In a regulated environment, approximations aren't acceptable
Clear communicator, able to explain a data issue to a business audience
French and English (professional level)

Nice to have

Power BI, SQL or Python
Exposure to data governance frameworks
Knowledge of pharma, GxP or data integrity
An earlier internship in an ERP/PLM/MDM project or a data migration

Nous proposons :

Why join us? #HappyTrainees

Our students are our best ambassadors. We are ranked 1st in France's HappyTrainees ranking and 2nd globally in the 2024 HappyTrainees ranking.

Professional fulfilment, a spirit of collaboration, and work-life balance are at the core of our experience offering. By joining our team, you will benefit from:

Exciting and stimulating projects
Committed mentors for personalized guidance
A friendly atmosphere with events and a dynamic working environment (e.g., Campus Welcome Session, seminars, personal development workshops, etc.).

Advantages: