Business Intelligence Consultant – ETL & Data Integration - Temporary Full-Time - Project REACH - 2026-19098 (2026-19098)

Sunnybrook

Toronto

On-site

CAD 90,000 - 120,000

Full time

45 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Sunnybrook is seeking an experienced Business Intelligence Consultant – ETL & Data Integration to design, build, and maintain data pipelines and BI solutions that enable evidence-based decision-making across the hospital.

The role combines strong technical expertise with healthcare data knowledge to transform complex information into actionable insights that improve patient care, operational efficiency, and strategic planning.

Qualifications

  • Bachelor's degree in CS/Health Informatics/Engineering/Applied Math/Statistics or related field.
  • Minimum 3 years of experience in data integration or BI development, preferably in healthcare.
  • Strong understanding of data warehousing principles, ETL design patterns, and relational database concepts.
  • Advanced proficiency in SQL (T‑SQL or PL/SQL) and experience with ETL tools such as SSIS, ODI, or ADF.
  • Experience with BI tools (Power BI, Tableau) and familiarity with SharePoint an asset.
  • Knowledge of healthcare administrative data (e.g., DAD, NACRS, OMHRS, CCRS, NRS).
  • Experience supporting Cerner EHR implementations or upgrades is a strong asset.
  • Strong analytical, problem-solving, and communication skills.

Responsibilities

  • Design, develop, and maintain ETL processes using SSIS/TSQL for MSSQL to support the enterprise data warehouse and BI reporting needs.
  • Design, build, and optimize ETL data extraction workflows and staging pipelines from Oracle Cerner Millennium source systems for warehousing and reporting.
  • Create and maintain database structures, stored procedures, indexes, and business rules.
  • Build and maintain data models, data maps, and data quality frameworks; conduct testing to ensure accuracy and integrity.
  • Collaborate with Decision Support analysts and data scientists to integrate analytical models into dashboards.
  • Develop and automate recurring reports and dashboards for clinical, operational, and administrative stakeholders.
  • Troubleshoot and resolve data quality or integration issues with IT and business partners.
  • Support modernization of hospital data and analytics infrastructure, including cloud and advanced analytics evaluation.
  • Contribute to innovation with predictive modeling, machine learning, and data-driven clinical improvement.

Skills

Data integration experience (3+ years)
Analytical and problem solving
Communication skills
Project management
Healthcare data knowledge
Cerner EHR migrations
Data modeling

Education

Bachelor's degree in Computer Science / Health Informatics / Engineering / Applied Mathematics / Statistics or related field

Tools

SSIS
ODI
Azure Data Factory
Oracle
SQL Server

Job description

Position Summary

We are seeking an experienced and motivated Business Intelligence Consultant – ETL & Data Integration to join Project REACH. In this role, you will design, build, and maintain data pipelines and Business Intelligence (BI) solutions that enable evidence-based decision‑making across the hospital. The successful candidate will combine strong technical expertise with an understanding of healthcare data to transform complex information into actionable insights that improve patient care, operational efficiency, and strategic planning.

Key Responsibilities
  • Design, develop, and maintain efficient and reliable ETL processes using SSIS/TSQL for MSSQL to support the enterprise data warehouse and BI reporting needs.
  • Design, build, and optimize ETL data extraction workflows and staging pipelines from Oracle Cerner Millennium source systems to support hospital data warehousing and reporting.
  • Create and maintain database structures, stored procedures, indexes, and business rules.
  • Build and maintain data models, data maps, and data quality frameworks; conduct testing and validation to ensure accuracy and integrity.
  • Work closely with Decision Support analysts and data scientists to integrate analytical models and metrics into operational and strategic dashboards.
  • Develop and automate recurring reports and dashboards for clinical, operational, and administrative stakeholders.
  • Troubleshoot and resolve data quality or integration issues in collaboration with IT and business partners.
  • Support the modernization of the hospital’s data and analytics infrastructure, including evaluation of cloud and advanced analytics technologies.
  • Contribute to innovation by supporting initiatives in predictive modeling, machine learning, and data-driven clinical improvement.
Qualifications/Skills
  • Bachelor’s degree in computer science, Health Informatics, Engineering, Applied Mathematics, Statistics, or related field.
  • Minimum 3 years of experience in data integration or BI development, preferably in a healthcare environment.
  • Strong understanding of data warehousing principles, ETL design patterns, and relational database concepts.
  • Advanced proficiency in SQL (T-SQL or PL/SQL) and solid experience with ETL tools and frameworks such as SSIS, Oracle Data Integrator (ODI), or Azure Data Factory. Experience with Business Intelligence tools (e.g., Power BI, Tableau) and familiarity with SharePoint an asset.
  • Knowledge of healthcare administrative data (e.g., DAD, NACRS, OMHRS, CCRS, NRS) and related methodologies preferred.
  • Experience supporting data migration, staging, or integration pipelines during Cerner EHR implementations or system upgrades is considered a strong asset.
  • Strong analytical, problem‑solving, and communication skills.
  • Proven ability to manage multiple priorities, work independently, and collaborate effectively with multidisciplinary teams.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Developer, Enterprise Analytics
Business Intelligence Developer, Enterprise Analytics

Scarborough Health Network • Toronto

On-site
CAD 73,000 - 85,000
Data Engineer (Healthcare)
Data Engineer (Healthcare)

Government Entity • Canada

On-site
CAD 90,000 - 120,000
Sr. BI & Data Analyst | Remote | Canada
Sr. BI & Data Analyst | Remote | Canada

Sutherland • Canada

Remote
CAD 90,000 - 130,000
Sr. BI & Data Analyst | Remote | Canada
Sr. BI & Data Analyst | Remote | Canada

Sutherland Company • Windsor

Remote
CAD 90,000 - 120,000
Dir of Data Integrations - Canada
Dir of Data Integrations - Canada

TechStarsGroup • Toronto

Remote
CAD 150,000 - 190,000
Business Analyst – Business Intelligence (BI)
Business Analyst – Business Intelligence (BI)

emergiTEL Inc. • Fredericton

Remote
CAD 100,000 - 130,000
HIS Specialist - Project REACH - Temporary Full-Time - 2026-19226
HIS Specialist - Project REACH - Temporary Full-Time - 2026-19226

Sunnybrook Health Sciences Centre • Toronto

Hybrid
CAD 90,000 - 110,000
RQ00381 -Remote I Business Analyst: Business Intelligence I SNB
RQ00381 -Remote I Business Analyst: Business Intelligence I SNB

Analyst Technical Solutions • Toronto

Remote
CAD 90,000 - 120,000
Sr. BI & Data Analyst
Sr. BI & Data Analyst

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
RQ00380 I 4 Years I Remote I Clinical Business Analyst – Business Intelligence
RQ00380 I 4 Years I Remote I Clinical Business Analyst – Business Intelligence

Analyst Technical Solutions • Toronto

Remote
CAD 90,000 - 130,000