Business Intelligence (BI) Consultant

WELL Health Diagnostic Centres•Toronto, ON

4d•Hybrid

About The Position

WELL Health Diagnostic Centres is the largest operator of independent diagnostic health facilities in Ontario, with over 50 accredited locations offering cardiology, radiology, respirology, and sleep diagnostic services. They are committed to delivering shorter wait times, faster report turnaround, and the highest standard of patient care. WELL Health Diagnostic Centres is recognized as a top employer of choice, known for attracting, developing, and retaining top healthcare professionals. They have received distinctions such as Canada’s Best Managed Companies, Great Place to Work®, Canada’s Top Growing Companies, and the Consumer Choice Award. The company offers a compassionate and connected healthcare environment with over 1,000 healthcare professionals across Canada. They prioritize employee wellness with full access to group medical benefits and external wellness platforms to support work-life balance. Employees benefit from competitive compensation, extended health and dental benefits, paid time off, and exclusive perks through Perkopolis. With over 50 clinics and rapid expansion plans, there are opportunities for skill advancement and career building. The culture is collaborative and supportive, with strong leadership, mentorship, continuing education, training and development support, internal mobility, and clear career growth pathways.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Healthcare Informatics, or related field.
5+ years of experience in Business Intelligence, Data Analytics, or Reporting roles.
Experience working in the healthcare industry or healthcare technology environment.
Strong proficiency in: SQL, Power BI / Tableau / QlikView, Excel and data analysis tools, ETL processes and data integration.
Experience with healthcare databases and reporting structures.
Strong analytical, problem-solving, and communication skills.

Nice To Haves

Experience with healthcare EMR/EHR platforms.
Knowledge of healthcare data standards and reporting frameworks.
Experience with Azure Data Factory, SSIS / SSRS / SSAS, Snowflake / Redshift / BigQuery, Python or R for analytics.
Familiarity with healthcare KPIs, billing, claims, and patient outcome reporting.
Certification in Power BI, Tableau, Azure, or healthcare analytics is an asset.

Responsibilities

Design, develop, and maintain BI dashboards, scorecards, and operational reports.
Analyze healthcare data to identify trends, performance gaps, and improvement opportunities.
Develop KPIs and metrics for clinical, operational, and financial reporting.
Translate business requirements into scalable BI and analytics solutions.
Support data-driven decision-making across healthcare operations.
Extract, transform, and load (ETL) data from multiple healthcare systems and databases.
Build and optimize SQL queries, data models, and reporting datasets.
Ensure data accuracy, integrity, and consistency across reports and dashboards.
Develop automated reporting processes and data validation procedures.
Support ad-hoc reporting requests from business and clinical teams.
Work with EMR/EHR systems such as Epic, Cerner, Meditech, OSCAR, PS Suite, Accuro, or equivalent.
Analyze clinical, patient, operational, and financial healthcare data.
Ensure compliance with healthcare privacy and security regulations (HIPAA/PHIPA/PIPEDA).
Support regulatory and compliance reporting requirements.
Collaborate with clinical leadership, finance, operations, and IT teams to gather reporting requirements.
Present insights and recommendations to stakeholders and executive leadership.
Conduct training sessions and provide user support for BI tools and dashboards.
Participate in data governance and analytics strategy initiatives.