Data Analyst, Information Services, Business Intelligence (ITC) – Temporary Full-Time (1.0) (until March 2028)

Socket.dev; Ottawa; On-site; CAD 48,000 - 59,000; Full time

Job summary

CHEO in Ottawa seeks a Data Analyst to support data collection, extraction, analysis, and reporting for the Integrated Treatment Centre (ITC) approach. You will build reports, dashboards, and visualizations from CHEO information systems while ensuring data quality and regulatory compliance.

You will collaborate with clinicians, operational leaders, and researchers to translate data into actionable insights, develop KPIs, and support decision-making for program evaluation and continuous

Qualifications

• University degree in epidemiology, science, statistics, or a related field (Essential)
• Experience working with relational databases and SQL (Essential)
• Minimum 3 years experience in an analysis position (Essential)
• Experience with calculation of basic epidemiologic measures (i.e., rates, risks, rate/risk ratios, 95% confidence intervals) (Essential)
• Proficient in data management software and statistical analysis languages such as R (Essential)
• Excellent computer skills (Excel) (Essential)
• Knowledge of ethics, privacy and regulatory requirements of research involving human subjects (Essential)
• Ability to prioritize with good time management skills (Essential)
• Excellent communication skills in English (Essential)
• Experience with BI reporting software (PowerBI, Tableau) (Preferred)
• Experience with health system integrations (HL7, FHIR, APIs) (Preferred)
• Criminal Record Check (Level 1) (Essential)
• Bilingualism (French/English) (Preferred)

Responsibilities

• Collaborate with team to identify information needs and define reporting requirements
• Write analysis queries and programs for data processing and transformation
• Develop, maintain, and enhance reports, dashboards, and visualizations
• Test analytical queries and outputs for accuracy and reliability
• Ensure data is complete, accurate, and compliant with privacy and regulatory requirements
• Support development of systems and methodologies for organizing and analyzing data trends
• Support KPIs, outcome measures, and operational metrics related to care delivery
• Prepare data outputs in various formats including reports and dashboards
• Maintain records of analysis activities and recurring reports for governance
• Link and validate data from multiple sources
• Conduct statistical and trend analyses
• Execute data validation and resolve data discrepancies
• Support continuous quality improvement and benefits realization through analytics
• Document data definitions, business rules, and methodologies
• Improve reporting processes and analytics capabilities
• Adhere to CHEO safety policies
• Perform other duties as assigned by supervisor
• CHEO location-based requirements and pre-screening notices

Skills

Relational databases

SQL

R

PowerBI

Tableau

Data management software

English communication

Education

University degree in epidemiology, science, statistics, or related field

Tools

PowerBI

Tableau

R

Job description

Compensation Pay Range:

$35.04-$43.00

Job Description:

Ottawa is built on un-ceded Algonquin Anishinaabe territory. The peoples of the Algonquin Anishinabek Nation have lived on this territory for millennia and we honour them and this land. Their culture and presence have nurtured and continue to nurture this land. CHEO also honours all First Nations, Inuit and Métis peoples and their valuable past and present contributions to this land. CHEO is one of the few stand‑alone, global leaders in pediatric health and is home to more than 6,500 staff, clinicians, scientists and researchers, as well as volunteers – all of whom work together to help children and youth achieve their best lives. Within its own walls and through partnerships with community providers, CHEO has transformed from a 20th century acute care hospital into a 21st century integrated child and youth health system. Ranked in the top 1% of Canadian hospitals for the digitization of its clinical infrastructure, CHEO combines excellence in clinical care, research, and education to advance seamless care that’s provided where, when, and how it is needed. CHEO’s Research Institute is dedicated to world‑class clinical, translational, and basic science research covering a wide range of children’s health concerns. CHEO has been named Canada’s best health‑care employer by Forbes in 2024, 2025 and 2026 and is ranked second among Canadian hospitals on its list of Canada’s Best Employers for multiple consecutive years. For the 14th consecutive year in a row, the editors of Canada’s Top 100 Employers has recognized CHEO as a top employer in the National Capital Region. Every year CHEO helps more than 500,000 children and youth from Eastern Ontario, western Quebec, Nunavut and Northern Ontario.

POSITION SUMMARY

The Data Analyst is responsible for supporting the collection, extraction, analysis, interpretation, and reporting of data related to the Integrated Treatment Centre (ITC) Approach to Care. Working within the Business Intelligence team, the analyst provides analytical expertise to support operational planning, implementation, performance measurement, quality improvement, and evaluation activities across multiple ITC workstreams.

The analyst develops and maintains reports, dashboards, and data visualizations using data from CHEO information systems and other relevant sources, ensuring data quality, consistency, and usability. The role collaborates closely with operational leaders, clinicians, project teams, digital health teams, and other partners to identify information needs, define reporting requirements, establish performance indicators, and translate data into actionable insights that support evidence‑informed decision‑making.

The analyst contributes to the development of sustainable reporting and measurement solutions that support performance measurement, program oversight, continuous quality improvement, operational decision‑making, and evaluation activities across the ITC project and future‑state ITC program. These solutions enable the monitoring of patient access, care delivery, outcomes, operational performance, and system transformation objectives, informing planning, implementation, benefits realization, and ongoing system improvement. This includes maintaining project and analysis documentation, supporting reporting governance and processes, and participating in continuous improvement and professional development activities.

MAIN RESPONSIBILITIES

• Collaborate with team members, data requestors, researchers, clinical, operational, project, digital health and analytics partners to identify information needs, define reporting requirements, and clarify data elements required to support planning, implementation, operational readiness, performance measurement, and evaluation activities.
• Write analysis queries and programs to perform data processing, data extraction, data transformation, and analytical tasks.
• Develop, maintain, and enhance reports, dashboards, scorecards, and data visualizations using data from CHEO information systems and other relevant sources.
• Test analytical queries, reporting solutions, and data outputs to ensure accuracy, completeness, consistency, and reliability.
• Work with project teams, operational leaders, and subject matter experts to ensure data is complete, accurate, and compliant with applicable privacy, regulatory, and organizational requirements.
• Assist in the development and maintenance of systems, processes, and methodologies for organizing, analyzing, monitoring, and reporting data trends and performance indicators.
• Support the development, implementation, and monitoring of key performance indicators (KPIs), outcome measures, and operational metrics related to access, care delivery, patient outcomes, and system transformation objectives.
• Prepare data outputs and analytical products in a variety of formats, including reports, dashboards, presentations, visualizations, and ad hoc analyses.
• Maintain records of analysis activities and prepare recurring and ad hoc reports to support project governance, operational decision‑making, quality improvement, and evaluation activities.
• Match, link, aggregate, and validate data from multiple internal and external sources, as required.
• Conduct statistical analyses and trend analyses, applying appropriate analytical methodologies and techniques.
• Execute data validation activities, identify data quality issues, and support the resolution of data discrepancies.
• Support continuous quality improvement, program evaluation, operational monitoring, and benefits realization activities through the provision of timely and actionable analytics and reporting.
• Ensure accurate and detailed documentation concerning data definitions, business rules, analytical methodologies, assumptions, and reporting decisions throughout the course of project and program activities.
• Participate in the ongoing improvement of reporting processes, data quality practices, performance measurement approaches, and analytics capabilities.
• Perform work in accordance with the provisions of the Occupational Health and Safety Act and Regulations and all CHEO corporate and departmental policies and procedures related to Occupational Health and Safety.
• Perform other related duties as assigned by the supervisor.

QUALIFICATIONS

• University Degree in epidemiology, science, statistics, epidemiology, or a related field (Essential)
• Experience working with relational databases and SQL (Essential)
• Minimum 3 years experience working in an analysis position (Essential)
• Experience with calculation of basic epidemiologic measures (i.e., rates, risks, rate/risk ratios, 95% confidence intervals) (Essential)
• Clinical health research experience (Preferred)
• Proficient in using data management software and statistical analysis languages such as R, as well as other relevant statistical and programming tools (Essential)
• Excellent computer skills (Microsoft Office, especially Excel) (Essential)
• Excellent attention to detail (Essential)
• Knowledge of ethics, privacy and regulatory requirements of research involving human subjects. (Essential)
• Ability to prioritize with good time management skills (Essential)
• Excellent communication skills, both written and spoken. Ability to read, write, speak and understand English required. (Essential)
• Experience with business intelligence reporting software (e.g. PowerBI, Tableau) (Preferred)
• Experience with health system integrations and associated messages standards (e.g. HL7, FHIR, API’s) (Preferred)
• Criminal Record Check (Level 1) (Essential)
• Bilingualism (French/English) (Preferred)

*Timeline may be extended or shortened based on operational needs.

*Please note you will be represented by the Ontario Public Service Employees Union (OPSEU). Please note that this position will be based out of Ottawa. Please note that location may be subject to change at any time at the discretion of the employer. All OPSEU members shall be granted an interview upon passing the pre‑screening. Pre-screening might include testing.

Effective March 29, 2021, CHEO will conduct a more comprehensive pre‑screening and evaluation process. This process may include more varied and multidimensional testing such as a written test, practical exam, or other assessment. All candidates who meet the essential and preferred qualifications may be tested.

Bilingualism (French/English) will be validated by a language proficiency assessment conducted by a third party provider. Candidates will be required to meet the minimum linguistic profile prior to the date of hire.

Should you require accommodation during any phase in the recruitment process, please contact Human Resources at [e-mail]. All information received in relation to accommodation will be kept confidential and will be handled in compliance with the Accessibility for Ontarians with Disabilities Act.

CHEO values diversity and is an equal opportunity employer. We are committed to providing an inclusive and barrier-free work environment, starting with the hiring process and welcome interest from all qualified applicants.

Should you require accommodation during any phase in the recruitment process, please contact Human Resources at [e-mail]. All information received in relation to accommodation will be kept confidential and will be handled in compliance with the Accessibility for Ontarians with Disabilities Act.

We thank all those who apply, however, only those to be interviewed will be contacted.