Internship - Data Migration & Data Governance M - F H/F

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

Benefits offered by this job

Remote work

On-site restaurant

CE access

On-site gym facilities

Housing assistance

Job summary

Servier in Suresnes, France, is offering an internship with the Data Migration & Governance Lead to design the target data model and perform the migration in a regulated pharma environment.

You will map legacy data from SharePoint and drives, profile and clean data, build loading templates, define governance rules, and track data quality KPIs using Excel and Power BI while collaborating with SMEs, IT and leadership.

Qualifications

• Final-year Bac +5 student from an engineering school, business school or university.
• Strong Excel skills: Power Query, pivot tables, lookups.
• 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)

Responsibilities

• Map data and attributes from the legacy tool to the target ePALMS data model.
• Profile, clean and consolidate legacy data: find duplicates, inconsistencies, obsolete items, correct links and gaps.
• Build and maintain data loading templates, transformation rules and the mapping documentation.
• 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 (reconciliation, sampling, SME validation).
• Prepare workshop materials and record decisions in logs and registers.
• Explore how ePALMS connects to MDM, RIMS, SAP.

Skills

Excel advanced

Data modelling

Communication

French & English

Detail-oriented

Regulatory awareness

Education

Final-year Bac +5 student (engineering/business/university)

Tools

Power BI

SQL

Python

Job description

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

Nous sommes engagés pour l'égalité des chances et le développement des talents dans toute leur diversité. Nous accordons autant de valeur à l'expérience qu'à l'envie de s'engager au quotidien pour être utile au progrès thérapeutique au bénéfice des patients. Si vous vous reconnaissez dans cette offre et ces quelques lignes, saisissez cette opportunité de nous rencontrer.