Data Analyst

The College of Physicians and Surgeons of Ontario; Toronto; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

The College of Physicians and Surgeons of Ontario is seeking a Data Analyst to enhance data management processes. This hybrid role involves data systems management, analysis, and reporting, focusing on operational improvements. Ideal candidates will have experience in SQL and Python, along with strong organizational skills.

Qualifications

• 3+ years of relevant work experience required.
• Knowledge of database management.
• Flexibility necessary as the position is constantly changing.

Responsibilities

• Creation of automated operational reports related to KPIs.
• Design tools for data extraction and querying in Python.
• Audit data for consistency and accuracy.

Skills

Data Management

SQL

Python

Microsoft Office

Power BI

SharePoint

Organizational Skills

Communication

Education

University degree in engineering, statistics or related field

Master's degree

Tools

Power BI

Visio

Job description

Job Category: Business Support and Administration

Requisition Number: DATAA001376

Apply now

• Posted : May 23, 2025
• Full-Time
• Hybrid

Locations

Showing 1 location

Toronto, ON M5G2E2, CAN

Description

The College of Physicians and Surgeons of Ontario (CPSO) is seeking a dynamic and professional Data Analyst. This role is ideal for an independent thinker with a problem solving mindset focused on enhancing data management processes with accuracy, efficiency, timeliness and professionalism.

This position focuses on data systems management, analysis and reporting to identify issues and trends in support of operational improvement of the CPSO.

Responsibilities

Data Management, Reporting and Analysis

• Creation of automated operational reports related to key performance indicators and operational benchmarks.
• Building and maintenance of a user-friendly interface for the extraction and querying of operational data
• Develop strategies to generate and automate better reports
• Evaluates and verifies the accuracy, consistency and completeness of the data via a standardized auditing program
• Carries out detailed analysis of College-wide data to evaluate operational performance
• Use operational data to generate ideas related to improving the efficiency of processes
• Presents results of analyses to internal and external stakeholders, such as management, Medical Advisors, Council and Committees
• Respond to ad-hoc data queries from internal and external sources
• Design and develop expansions and modifications to data querying tools developed in Python, as necessary
• Develops and maintains standard operating procedures and detailed manuals outlining reporting requirements
• Audit the College’s Enterprise System to ensure consistency, accuracy and completeness of data
• Creation and maintenance of Power BI reports for operational data and key performance indicators

Qualifications

• University degree in engineering, statistics or related field
• Master’s degree considered an asset
• 3+ years of relevant work experience
• Knowledge of database management is required
• Proficient computer programming skills in SQL, Python
• Advanced proficiency in Microsoft Office applications and Visio, Power BI, SharePoint
• Demonstrated ability to be self-directed and contribute to a team environment
• Exceptional organizational and time management skills with meticulous attention to detail, ability to handle multiple tasks and responsibilities, and adherence to deadlines
• Ability to effectively communicate, both verbally and in writing, with the public and the profession
• Flexibility is necessary as this position is constantly changing and growing
• Knowledge of Lean Principles
• An understanding of equity, diversity and inclusion principles and their applications

Application Procedure:Qualified candidates please submit a cover letter and resume by June 6 , 2025.

Note:It is a fundamental requirement of employment at CPSO that employees reside in Ontario and can attend the College office as required. Must be able to provide proof of double vaccination.

Work environment: Hybrid, remote work with in-office attendance one day per week and/or more as needed.

The College is committed to hiring practices that support accessibility for people with disabilities, employment equity and diversity in the workplace. The College actively seeks to increase their diversity by welcoming applications from women, visible minorities, aboriginal people, persons with disabilities and persons of any sexual orientation or gender identity. Applicants with a disability may request accommodation at any stage of the recruitment process by contacting the Human Resources Department.