The Canadian Memorial Chiropractic College (CMCC), established in 1945, is recognised internationally for excellence in chiropractic education, research and patient care.
Vision: An academic institution recognised for creating leaders in spinal health.
Mission: Deliver world class chiropractic education, research and patient care.
Our employees have a commitment and dedication to the advancement of health care. We continue to seek talented individuals who make a positive difference in living our vision and mission.
Position: Business Intelligence Analyst
(Full-time; 35 hours per week)
Reports to: Dean, Clinics
Salary: $60,683.00 to $64,297.00 per year
Start Date: ASAP
Job Posting Date: June 11, 2025
Application Deadline: June 25, 2025
Application Requirement: Interested internal applicants to apply via MyAvanti by uploading a CV and covering letter.
Interested external applicants to upload a covering letter stating salary expectations and CV via Career Connector at https://myavanti.ca/workatcmcc
Are you a creative and innovative thinker, skilled in analyzing data and in developing data mining and business intelligence applications? Are you able to review complex data, leveraging multiple sources of internal data into comprehensive and meaningful decision support? Do you have experience presenting business data for non-technical individuals, bridging communication gaps between users and the IT department?
CMCC is looking for a Business Intelligence Analyst to provide critical insights for data obtained through various data collection processes through the Division of Clinical Education. The successful candidate will provide assistance in forecasting results for clinical site planning and academic program development, as well as in extraction and interpretation of research data, and act as backup support for various academic processes within the Division of Clinical Education. Key to this role is insightful and critical review of what the data “means”.

-SKILLS & KNOWLEDGE

· Minimum of 3 years’ experience in SQL, including database creation and maintenance.
· Familiarity with SQL (SSMS), Python for data extraction, manipulation, and analysis.
· Proficient in advanced Microsoft 365 products including Excel, Power Automate, SharePoint and Teams integration.
· Prior experience in creating Power BI reports and dashboards.
· Demonstrates a clear and reasoned understanding of how artificial intelligence and machine learning intersect with healthcare delivery, with attention to how data-driven systems support decision-making, patient care, and workflow design - anchored in practical or academic exposure.
· Strong critical thinking, structured reasoning, and communication skills across multidisciplinary teams are essential.
· Ability to manage several projects simultaneously and adapt to shifting priorities
· Possesses integrity, initiative with strong critical and analytical thinking skills.
· Team leader who is also a problem solver and decision maker along with strong customer focus and experience with development and mentoring others
· Models professional attributes and the core values of CMCC, Communication, Accountability, Respect & Excellence
Internal applicants are required to inform their Division Director of their intentions to apply, prior to doing so.
We thank all candidates in advance, but only those candidates who meet the minimum requirements of the job posting will be contacted.
The successful applicant will be required to undergo credit and criminal checks. Any offer of employment is contingent upon successful completion of references, credit and criminal checks.
Successful applicants shall be required to provide original transcripts to validate their academic qualifications as a condition of employment at CMCC.
Compliance with the CMCC Communicable Diseases Policy is a requirement for employment with CMCC. Please see https://www.cmcc.ca/about-cmcc/policies for more information.
In accordance with the Ontario Human Rights Code, Accessibility for Ontarians with Disabilities Act, 2005, and CMCC Accessibility Policy, accessible formats and communication supports are available upon request for all parts of the hiring process. Applicants are required to make their needs known in advance. Please contact Human Resources at hradmin@cmcc.ca.
In our commitment to promote fair and equitable treatment of all employees and applicants, CMCC provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status or any other ground as described in the Ontario Human Rights Code. CMCC’s implementation and support of employment initiatives encourage diversified labour force participation and equal access to opportunities based on merit and performance.
Job Types: Full-time, Permanent
Pay: $60,683.00-$64,297.00 per year

Schedule:

• 8 hour shift
• Monday to Friday

Ability to commute/relocate:

• North York, ON M2H 3J1: reliably commute or plan to relocate before starting work (required)

Application question(s):

• How many years of experience with Python (data extraction, manipulation, and analysis) do you have?
• How many years of experience with PowerBI do you have?
• How many years of experience with Power Automate do you have?
• How many years of experience with SharePoint do you have?
• What are your minimum salary expectations?
• Are you willing to travel to our GTA clinics (including Bowmanville and Oakville) - maximum 5% of the time?

Education:

• Bachelor’s Degree (required)

Experience:

• SQL, including database creation and maintenance: 3 years (required)

Language:

• English (required)

Willingness to travel:

• 25% (preferred)

Work Location: Hybrid remote in North York, ON M2H 3J1
Application deadline: 2025-06-2

· Collaborates with business users to determine appropriate standard, ad hoc and customized reporting for Clinic Management (CMT). Building reports in Power BI based on the business requirements.
· Performs analysis and develops reports on patient data, student academic performance, clinic performance, and clinic finances.
· Creates necessary flows using Power Automate to ensure data is captured for reporting.
· Develops databases and uses output to provide analysis for CMT in support of operations and planning, while communicating complex technical topics with clarity and precision, adapting language to suit interdisciplinary and leadership audiences.
· Delivering the end product to users and training users in the interpretation of results.
· Confirms recency of OSCAR data warehouse. Troubleshoots data related issues, resolves issues when possible, or refers to CMCC IT (Information Technology).
· Confirms recency of student competency data and troubleshoots data related issues, referring to IT if required.
· Queries databases on demand to provide research data and analysis in support of research initiatives.
· Develops and maintains databases and reports related to quality assurance mechanisms (File Audits), and patient feedback (PES).
· Design and interpret analytical models in a clinical or operational setting using a strong foundation in applied statistics, including regression, clustering, and multivariate analysis.
· Performs other duties as required, including attending various meetings within and outside the department.
· Some travel to the GTA clinics is required.