Data Analyst (Data Migration) - Project REACH - Temporary Full-Time - 2025-15496

Classification: Temporary Full-Time (approx. 24 months)

Sunnybrook Health Sciences Centre is undertaking Project REACH, a multi-year initiative to implement Oracle Health’s Hospital Information System (HIS) across all campuses. This major transformation will consolidate clinical, operational, and administrative data to enhance patient care, improve data quality, and enable integrated reporting and analytics.

The Data Analyst – Data Migration will work in close collaboration with the Data Architect – Data Migration to support all phases of the data migration process. This includes data extraction, transformation, validation, and reconciliation from multiple legacy systems (Telus OACIS, Harris QCPR, GE/Philips) into Oracle Health Millennium.

This role is critical to ensuring that data migrated to Oracle Health is accurate, complete, and compliant with PHIPA and Sunnybrook’s data governance standards.

Key Responsibilities

Data Extraction, Mapping & Transformation

• Support the Data Architect – Data Migration in the design and execution of the data migration strategy.
• Assist with the extraction, mapping, and transformation of data from legacy systems to Oracle Health data structures.
• Prepare datasets for staging and validation, ensuring data alignment with approved data models.
• Perform data profiling and cleansing activities to identify data quality issues prior to migration.

Data Validation & Reconciliation

• Conduct detailed validation and reconciliation between source, staging, and target systems to ensure data completeness and accuracy.
• Execute SQL queries and validation scripts to identify discrepancies and ensure data consistency across environments.
• Document and escalate data quality issues for resolution and participate in error remediation cycles.
• Support multiple mock conversions and migration test cycles, including go-live readiness activities.

Documentation & Governance

• Maintain documentation of data mappings, transformation logic, validation scripts, and reconciliation results.
• Ensure all migration activities adhere to Sunnybrook’s data governance, privacy, and security requirements.
• Contribute to the creation of data quality dashboards and audit logs to support transparency and oversight.

Collaboration & Stakeholder Engagement

• Collaborate with the Data Architect – Data Migration, Integration, and Technical teams to ensure successful execution of migration tasks.
• Partner with business and clinical stakeholders to verify data migration requirements and validation results.
• Participate in migration workgroup sessions and readiness checkpoints to support testing and issue resolution.

Testing & Quality Assurance

• Participate in system, integration, and user acceptance testing (UAT) for data migration validation.
• Support test planning, execution, and documentation for migrated data elements.
• Assist in post-migration verification to ensure data integrity and readiness for operational use.

Qualifications / Skills

• Bachelor’s degree in Data Analytics, Health Informatics, Computer Science, or a related discipline.
• 3+ years of experience in data analysis, data migration, or ETL/ELT processes in a healthcare or enterprise environment.
• Proficiency in SQL for data querying, transformation, and validation.
• Experience with data mapping, profiling, cleansing, and reconciliation between legacy and target systems.
• Familiarity with HIS/EHR systems such as Oracle Health Millennium, Telus OACIS is an asset.
• Strong analytical skills with exceptional attention to data quality and accuracy.
• Excellent documentation, communication, and stakeholder collaboration abilities.
• Knowledge of PHIPA, data retention, and healthcare privacy regulations.