Internship - Data Migration & Data Governance (M/F)

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

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