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

Servier; Suresnes; On-site; EUR 10,000 - 15,000; Full time

Benefits offered by this job

On-site restaurant

Housing assistance

Access to CE

Job summary

Servier invites an aspiring data professional to join a live data migration and governance project in Suresnes (Île-de-France). You will design the target data model, map legacy data, and help implement governance rules for the new ePALMS platform used for artwork and labelling management.

You will learn how full migrations run in a regulated environment, build practical governance, and collaborate with SMEs, IT and programme leadership in a global context.

Qualifications

• Final-year Bac+5 student in data management, information systems, supply chain, or pharma engineering.
• Comfortable with data modelling basics: entities, attributes, keys, reference data.
• Rigorous and detail-oriented in a regulated environment.
• Clear communicator able to explain data issues to a business audience.
• Fluent French and English.

Responsibilities

• Map data and attributes from legacy tools to the target ePALMS data model.
• Profile, clean and consolidate legacy data, finding duplicates and gaps.
• Build and maintain data loading templates, transformation rules, and mappings.
• Define naming conventions, data ownership, and data quality rules.
• Track migration progress and data quality KPIs in dashboards (Excel/Power BI).
• Participate in manual migration waves and quality checks.
• Prepare workshop materials and record decisions in logs and registers.
• Assess how ePALMS connects to MDM, RIMS, and SAP.

Skills

Data modelling basics

Clear communicator

French and English

Education

Final-year Bac+5 student from engineering/business/university

Tools

Power BI

SQL

Python

Job description

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
• 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
• Knowledge of pharma, GxP or data integrity
• An earlier internship in an ERP/PLM/MDM project or a data migration

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:

• On-site restaurant
• Access to CE
• Housing assistance

Practical information:

• Duration: 6 months
• Start date: January 27
• Accessibility: Site accessible to individuals with disabilities