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

Children’s Hospital of Eastern Ontario; Ottawa; On-site; CAD 48,000 - 59,000; Full time

Benefits offered by this job

Relocation reimbursement

Comprehensive benefits

Job summary

CHEO is seeking a Data Analyst to support the collection, extraction, analysis, interpretation, and reporting of data for the Integrated Treatment Centre (ITC) at CHEO. You will build dashboards and visualizations using CHEO information systems, collaborate with clinicians and project teams, and translate data into actionable insights to inform planning and quality improvement.

The role emphasizes data quality, privacy compliance, and generating recurring analytics for program oversight and

Qualifications

• University degree in epidemiology, science, statistics, or a related field.
• Experience with relational databases and SQL.
• Minimum 3 years in an analysis position.
• Experience with calculation of basic epidemiologic measures (rates, risks, etc.).
• Proficient in data management software and statistical tools such as R.
• Excellent Excel skills.

Responsibilities

• Collaborate with team to identify information needs and reporting requirements.
• Write analysis queries and programs for data processing and transformation.
• Develop and maintain reports, dashboards, and data visualizations.
• Test analytical outputs for accuracy and reliability.
• Ensure data completeness and privacy compliance across projects.
• Support KPI and operational metrics development and monitoring.
• Prepare data outputs in reports, dashboards, and ad hoc analyses.
• Maintain documentation for data definitions and methodologies.

Skills

Relational databases

SQL

R

Data analysis

Data visualization

Education

University degree in epidemiology

Tools

PowerBI

Tableau

Job description

Compensation Pay Range: $35.04-$43.00

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 and 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.
• *Effective March 29, 2021, CHEO will conduct a more comprehensive pre-screening and evaluation process.
• *Pre-screening may include testing.
• *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.

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.

CHEO is much more than a hospital. Our commitment to outstanding care and continued development impacts every part of a child and youth's health and well-being. We play a crucial role in building a healthy future for our community. Working at CHEO means a rewarding career. A career at CHEO provides a: competitive salary and comprehensive benefits package unique culture that fosters dedication, communication, respect and teamwork place where your opinions will be respected, contributions valued and your initiatives rewarded family-friendly environment that supports you and your own family, as well as the children, youth and families we serve chance to grow — personally and professionally — through our comprehensive orientation program and on-the-job learning support for continued education and learning potential for a relocation reimbursement benefit truly unique work environment We are redefining what it means to be a hospital. Exceptional and integrated care is what families, children and youth deserve. We are committed to partnering with them and the community to provide this care — where, when and how it’s needed. CHEO continues to be selected by local, national and international competitions showcasing employers who lead their sector in offering exceptional workplaces for their employees. For the eleventh time, CHEO has been recognized as one of the National Capital Region’s Top Employers. We are among a select group of organizations at the forefront of their respective industries who offer exceptional places to work. We were given this honour based on our outstanding: workplace atmosphere benefits employee communications training and skills development community involvement