Sunnybrook Health Sciences Centre is a nationally and internationally recognized academic health centre with multiple sites across the Greater Toronto Area (GTA). We provide expert, compassionate care to patients across Ontario, deliver broad and specialized education to thousands of learners, and lead cutting-edge research that shapes the future of healthcare.

As part of Project REACH, a multi-year initiative to implement a new Health Information System (HIS) across Sunnybrook, we are seeking a BI Data Architect (Data Migration) to lead the transformation of our clinical and operational data environment during the HIS implementation.

Summary of Duties

• Lead the data migration design and execution from legacy systems (e.g., Telus OACIS, Harris QCPR, GE/Philips) to Oracle Health.
• Define the data extraction scope, including clinical data for a two-year period, and develop a data retention and archival strategy for read-only access post-migration.
• Develop and maintain ETL mappings, staging strategies, and reconciliation processes to ensure data integrity across all environments.
• Collaborate with the Reporting Architect to ensure migrated data is analytics-ready and supports downstream reporting and regulatory needs.
• Validate data quality, completeness, and alignment with regulatory and privacy standards (PHIPA, retention policies, etc.).
• Document and maintain data lineage, mapping, and migration technical specifications.
• Partner with HIS vendors, technical teams, and decision support to ensure consistent data transformation and migration practices.
• Establish and enforce data governance and metadata standards to support reliable data migration and reporting.
• Support proof-of-concept efforts and testing cycles related to data migration and validation.
• Provide technical oversight for data migration-related risks, dependencies, and readiness checkpoints within Project REACH.

Qualifications / Skills

• Bachelor’s degree in Computer Science, Health Informatics, Engineering, or a related field; Master’s degree is an asset.
• Minimum 5 years of experience in data architecture and migration, preferably within healthcare or regulated environments.
• Proven experience leading data migration projects involving HIS or large enterprise platforms (Oracle Health Millennium experience is an asset).
• Strong understanding of data modeling, ETL/ELT development, and healthcare data standards (e.g., HL7, FHIR, PHIPA).
• Hands-on experience with SQL Server, Oracle, or equivalent database platforms and data integration tools.
• Familiarity with data governance, metadata management, and data lineage tracking.
• Excellent analytical, problem-solving, and communication skills with experience collaborating in cross-functional teams.
• Experience working in agile project environments and large-scale transformation programs.