The Data Migration Specialist is responsible for planning, executing, and validating the migration of critical pharma data, including lab results, quality records, SOPs, batch logs, equipment data, and historical documents.
This role ensures accuracy, integrity, compliance, and traceability throughout the migration process, enabling clients to transition smoothly from paper-based or legacy systems to modern digital solutions.
Key Responsibilities
- _ Conduct detailed assessments of existing data sources (paper, Excel, legacy LIMS/QMS/MES systems).
- _ Identify data structures, formats, gaps, inconsistencies, and quality issues.
- _ Develop data migration strategies, mapping documents, and timelines.
- _ Collaborate with domain experts to understand regulatory and operational requirements.
- _ Extract data from multiple sources, including scanned documents, spreadsheets, databases, and legacy applications.
- _ Clean, normalize, and transform data to meet Customer requirements.
- _ Build and execute data import templates, scripts, or low-code workflows.
- _ Ensure data integrity, completeness, and traceability throughout the migration process.
- _ Perform data validation checks before, during, and after migration.
- _ Work with QA teams to ensure compliance with GxP, CSV, and audit requirements.
- _ Document validation results and support IQ/OQ/PQ activities related to data migration.
- _ Work closely with implementation specialists, domain experts, and customer success teams.
- _ Participate in client workshops to clarify data requirements and expectations.
- _ Provide technical guidance to clients on preparing and cleaning their data.
- _ Maintain detailed documentation of data mapping, transformation rules, and migration procedures.
- _ Prepare migration reports, audit trails, and compliance documentation.
- _ Track issues, risks, and resolutions throughout the migration lifecycle.
- _ Train client teams on best practices for data preparation.
- _ Provide post-migration support to ensure data accuracy and user confidence.
Required Skills & Qualifications
- _ Bachelor’s degree in Computer Science, Data Science, Life Sciences, Engineering, or related field.
- _ 3+ Years of experience in the same or related field.
- _ Strong experience with ETL (Extract, Transform, Load) processes, data modeling, and data cleansing.
- _ Proficiency in Excel, SQL, or data transformation tools.
- _ Familiarity with low-code/no-code platforms.
- _ Understanding of structured and unstructured data formats (CSV, XML, PDF, etc.).
- _ Experience in pharma, biotech, or regulated industries is highly preferred.
- _ Understanding of GxP, GMP, GAMP 5, and data integrity principles (ALCOA+).
Soft Skills
- _ Strong attention to detail and analytical thinking.
- _ Excellent communication and documentation abilities.
- _ Ability to manage multiple projects and deadlines.
- _ Collaborative mindset with a customer-centric approach.