Data Analyst

College of Physicians and Surgeons of Ontario; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

The College of Physicians and Surgeons of Ontario seeks a Data Analyst to enhance data management and reporting processes. Key responsibilities include creating automated reports in Power BI, conducting detailed data analysis, and ensuring data accuracy. Ideal candidates will have a degree in a relevant field, strong programming skills, and a passion for problem-solving in a dynamic environment.

Qualifications

• 3+ years of relevant work experience.
• Proficient in SQL and Python.
• Exceptional organizational and time management skills.

Responsibilities

• Manage data systems, analysis, and reporting.
• Develop automated operational reports and dashboards.
• Evaluate and verify data accuracy and completeness.

Skills

Database management

SQL

Python

Data analysis

Power BI

Microsoft Office

Organization

Communication

Education

University degree in engineering, statistics or related field

Master’s degree considered an asset

Tools

Power BI

Visio

SharePoint

Job description

Job Category : Business Support and Administration

Requisition Number : DATAA001376

Apply now

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

Locations

Showing 1 location

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.