Data Architect, Data Migration - Temporary Full-Time - Project REACH 2025-15342

Back to Job List

Date Posted: 10/30/2025

Location: Toronto, ON, Canada

Reference No.: 2025-15342

Position Type: Temporary full-time

Department: Health Information System

FTE Status: 1.00

Hours of Work: 8 hrs

Campus Site: Bayview

Shifts Weekday Required: Other

Shifts Weekend Required: No Weekends

Statutory Holiday(s) Required: Yes

Salary Range: $57.212-$73.417/hr

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.
If you are looking for an exciting opportunity and to build a career in an innovative and dynamic organization, submit your resume by clicking on Apply Now below. 

Sunnybrook Health Sciences Centre is committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation for disability during any stage of the recruitment process, please indicate this in your cover letter.


Sunnybrook Health Sciences Centre is strongly committed to inclusion and diversity within its community and welcomes all applicants including but not limited to: visible minorities, all religions and ethnicities, persons with disabilities, LGBTQ persons, and all others who may contribute to the further diversification of ideas.

We thank all applicants for their interest. However, only candidates selected for an interview will be contacted. Sunnybrook Health Sciences Centre is an equal opportunity employer.

Review Sunnybrook Health Sciences Centre's Privacy Statement.