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

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:

• Remote work
• On-site restaurant
• Access to CE
• On-site gym facilities
• Housing assistance

Practical information:

• Location: Suresnes (92)
• Duration: 6 months
• Start date: January 27
• Accessibility : Site accessible to individuals with disabilities