Senior Data Migration Technical Analyst

About the role

Plan A Technologies is looking for a Senior Data Migration Technical Analyst to lead end-to-end data migration activities in regulated environments. The role covers defining migration strategy, analysing and mapping source data, designing transformation and reconciliation processes, and ensuring data integrity through to production cutover. It works closely with business and technical stakeholders to scope and execute migrations, build repeatable data pipelines and implement validation and reconciliation controls. The position is open to remote work.

Key responsibilities

• Lead workshops, inventory and profile source data, and create approved source-to-target mappings with cleansing, transformation, defaulting, load-sequence and exception rules.
• Define extracts, transformation scripts, import files and repeatable migration runs.
• Reconcile source and target data using record counts, control totals, field comparisons, relationship checks, exception reports and risk-based sampling.
• Work with QA, CSV, IT and vendors on validation deliverables, and with SMEs to define migration scope.
• Maintain traceability and develop cutover, rollback, data-freeze and post-migration stabilization plans.

Required profile

• At least 5 years of experience in data migration, data conversion, system implementation, data integration or enterprise content migration.
• Experience completing at least one full migration lifecycle from discovery through cutover and reconciliation.
• Experience in a pharmaceutical or biotechnology GxP environment, with knowledge of GAMP 5, 21 CFR Part 11, CSV or CSA and ALCOA+ principles.
• Experience with LabWare LIMS or LabWare SaaS is strongly preferred; knowledge of QA QC master data is desirable.

Required skills

• Strong SQL and relational database skills, source-to-target mapping, ETL or scripted transformation, data-quality analysis and reconciliation.
• Preferred: LabWare LIMS, Egnyte, Veeva Vault, ZenQMS, Python, PowerShell, SQL Server, Oracle, PostgreSQL, REST APIs, Databricks.
• Experience migrating laboratory data, controlled documents, training records, quality records, metadata, audit trails and electronic signatures.

What we offer

• Remote work option, or coming into one of the global offices.
• A supportive team of engineers and project managers.
• Vacation and a brand new laptop.