Business Intelligence (BI) Consultant

MyHealth Centre

$80K — $110K *
Healthcare
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 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 in the healthcare industry or healthcare technology environment
  • Strong proficiency in SQL, Power BI, Tableau, or QlikView
  • Experience with healthcare databases and reporting structures
  • Strong analytical, problem-solving, and communication skills

Responsibilities

  • Design, develop, and maintain BI dashboards, scorecards, and operational reports.
  • Analyze healthcare data to identify trends and improvement opportunities.
  • Develop KPIs and metrics for various reporting.
  • Translate business requirements into scalable BI solutions.
  • Support data-driven decision-making across healthcare operations.
  • Extract, transform, and load (ETL) data from multiple healthcare systems.
  • Build and optimize SQL queries and reporting datasets.

Benefits

  • Medical & dental benefits
  • Training and professional development support
  • Corporate discounts and referral bonuses
  • Travel opportunities with mileage and travel premiums
Full Job Description
Position Summary

We are seeking an experienced and analytical Business Intelligence (BI) Consultantwith healthcare industry expertise to design, develop, and support data-driven solutions that improve operational efficiency, clinical outcomes, and business performance.

The ideal candidate will work closely with healthcare stakeholders, clinical teams, operations, and leadership to transform complex healthcare data into actionable insights through dashboards, reports, and analytics solutions. The role requires strong experience in healthcare data systems, reporting tools, and regulatory reporting standards.

Responsibilities:

Business Intelligence & Analytics

  • 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.


Data Management & Reporting

  • 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.


Healthcare Systems & Compliance

  • 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.


Stakeholder Collaboration

  • 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.


Required Qualifications:

  • 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.


Preferred Qualifications

  • 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.


What Sets You Apart

You bring a positive, professional attitude, enjoy working both independently and collaboratively, and treat everyone with respect, dignity, and kindness. You're curious, dependable, and take pride in keeping things running smoothly behind the scenes.

What We Offer
• Competitive compensation
• Medical & dental benefits
• Training and professional development support
• Corporate discounts and referral bonuses
• Travel opportunities with mileage and travel premiums (where applicable)

WELL Health Diagnostic Centres does not use artificial intelligence-assisted tools as part of the recruitment process.

This role is for an existing vacancy.

Final compensation is determined based on market location, job-related knowledge, skills, experience level, and internal equity. Candidates with significantly more experience may be considered at a higher level with adjusted compensation for certain roles.

Follow us on LinkedIn: www.linkedin.com/company/welldiagnostics.ca

More Jobs at MyHealth Centre

More Healthcare Jobs

Find similar Business Intelligence (BI) Consultant jobs: