Data Migration Specialist

Russell Tobin; Fredericton; Remote; CAD 90,000 - 120,000; Full time

Job summary

A healthcare consultancy seeks a Data Migration Specialist in Fredericton, NB, to lead the migration of historical patient data to new systems. The ideal candidate has over 7 years of experience, a degree in a relevant field, and is skilled in data governance and management. Bilingual candidates and those with healthcare IT experience are preferred. This is a 12-month contract position with potential for extension, offering remote work options.

Qualifications

• 7+ years’ experience in data governance and management.
• Experience in at least one major healthcare CIS transformation.
• Strong background in data lifecycle management.

Responsibilities

• Develop data migration and archiving strategies.
• Establish governance standards for data quality.
• Collaborate with stakeholders for data management.

Skills

Data governance

Data management

Data migration

Data integration

CIS transformation

Stakeholder engagement

Bilingual (English & French)

Education

Bachelor’s degree in Computer Science, Business Administration, or Health Informatics

Job description

Job Title: Data Migration Specialist

Location: Fredericton, NB (Remote)

Duration: 12 Months Contract (Extension Possible)

Background

A large-scale healthcare transformation is underway, moving from multiple standalone hospital information systems to a unified, standardized, and integrated Clinical Information Solution (CIS). A critical part of this initiative involves managing historical patient and operational data from legacy systems.

The role will focus on migrating essential data into the new CIS, securely archiving the remainder, and ensuring clinical continuity, regulatory compliance, technical feasibility, and cost-effectiveness. The aim is to make necessary historical data available in new workflows while ensuring long-term, compliant access to archived records.

Responsibilities:

The Data Migration Specialist will:

• Provide subject matter expertise in developing data migration and data archiving strategies.
• Assist in documenting and prioritizing critical health master datasets and recommending minimum viable datasets for migration.
• Establish standards, processes, and tools for data governance, quality, and accuracy throughout the migration and archiving process.
• Collaborate with stakeholders to manage master data (patients, providers, locations) and ensure consistency for migration, archiving, and integration.
• Develop and implement data mapping rules to transform data from source to target systems accurately.
• Act as liaison between clinical leadership, health information management, compliance teams, IT, and vendors.
• Create and maintain documentation such as data specifications, flow diagrams, and migration plans.
• Develop detailed roadmaps for managing critical datasets throughout the CIS implementation lifecycle.
• Define methodologies for extracting, profiling, and transforming key datasets.
• Work closely with the CIS solution provider and technical teams on data specifications and migration processes.
• Participate in both steady-state and project-based efforts, including some after-hours or weekend work as required (pre-approved).

Mandatory Qualifications:

• Bachelor’s degree in Computer Science, Business Administration, Health Informatics, or equivalent education and experience.
• 7+ years’ experience in data governance, data management, and data migration.
• Experience in at least one major healthcare CIS transformation or replacement project.
• Strong background in data integration between legacy and new systems, information lifecycle management, and implementing data standards.
• Proven ability to develop and implement strategic approaches for managing historical data securely and accessibly.
• Experience working with diverse stakeholders (clinical, health information, technical, and business) to gather requirements and translate them into design strategies.

Scored Qualifications:

• Experience creating comprehensive data migration plans, including mapping, validation, and overseeing accurate data transfer.
• Expertise in managing and controlling master datasets (e.g., Patient IDs, Provider IDs) during CIS implementation.
• Experience cleansing and standardizing large healthcare datasets.
• Knowledge of health records and health information management.
• Data modeling experience (conceptual, logical, and physical).
• Ability to identify critical datasets across multiple legacy CIS environments and standardize them.
• Strong presentation skills, with experience presenting to business owners and executive-level stakeholders.
• Bilingual in English and French is strongly preferred.
• At least 5 years of experience with Canadian health information systems, standards, technology, or software.

Key Deliverables:

• Data Migration Strategy – Approach for migrating critical data and accessing historical data post go-live.
• Data Archive Strategy – Plan for maintaining historical data based on regulatory and clinical needs.
• Legacy Data Assessment – Detailed report of data elements, volumes, quality, and dependencies.
• Data Mapping & Transformation Rules – Formal mapping documentation and transformation logic.
• Data Migration Test Plans – Plans for multiple test cycles, including data quality validation.
• Data Validation Reports – Auditable proof of data accuracy and completeness.
• Final Cutover Plan – Detailed schedule for final data extraction and loading during go-live.
• Historical Data Lifecycle Roadmap – Steps, timelines, and policies for data migration, archiving, and purging.