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

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.