BI Report Developer

Grand River Hospital; Kitchener; Hybrid; CAD 61,000 - 76,000; Full time

Job summary

Waterloo Regional Health Network in Ontario is seeking a BI Report Developer to design and maintain reports and data pipelines within Cerner Millennium to support patient care, operational efficiency, and decision-making across the Waterloo Regional Health Network.

Applicants should have a Master’s degree in health informatics, computer science, data engineering or related field, 5+ years in healthcare data analysis, 3+ years with Power BI or Microsoft Fabric, and proficiency in SQL, Python, and

Qualifications

• Master’s degree in health informatics, computer science, data engineering or related field.
• Minimum 5 years of experience with data analysis in a healthcare setting
• Minimum 3 years of experience with Power BI or Microsoft Fabric
• Experience using Cerner reporting tools (DA2, CCL, SAP BO)
• Proficient in SQL and Python
• Solid understanding of relational database structure and design
• Proficient in analyzing large, complex healthcare datasets to identify trends, patterns, and insights that support organizational objectives and improve patient care.
• Proven ability in collaborating with cross-functional teams including healthcare providers, IT, and stakeholders to understand data needs and deliver actionable insights.
• Excellent written and oral communication skills with ability to clearly define projects, objectives, goals, assignments, etc.

Responsibilities

• Design, develop, test, and maintain reports using Cerner Command Language (CCL) to support clinical, operational, and administrative decision-making.
• Build and optimize data extracts and pipelines that move data from Cerner Millennium into downstream reporting and analytics platforms.
• Troubleshoot and resolve issues with existing CCL reports, including performance tuning and data accuracy problems.
• Collaborate with clinical, operational, and analytics stakeholders to gather reporting requirements and translate them into technical specifications.
• Ensure reports and extracts comply with data governance standards, including data quality, security, and privacy requirements (e.g., PHIPA).
• Maintain documentation of report logic, data sources, and dependencies to support long-term maintainability.
• Support integration between Cerner data and other systems or platforms (e.g., Power BI, Microsoft Fabric) as needed.
• Participate in testing and validation of reports following Cerner upgrades, patches, or configuration changes.
• Provide technical guidance and knowledge transfer to team members and stakeholders on CCL-based reporting.
• Monitor and support production reporting jobs, addressing failures or discrepancies in a timely manner.

Skills

SQL

Python

Cerner reporting tools

Power BI

Microsoft Fabric

Education

Master’s degree in health informatics, Computer Science, Data Engineering, or related field

Tools

Cerner DA2

Cerner CCL

SAP BO

Power BI

Microsoft Fabric

Job description

Welcome to health care that soars above. Welcome to WRHN.

BI Report Developer (Job ID: 6889)

Work Type: Temporary Full Time (until December 10, 2027)

Location: WRHN @ Queen's Blvd; Hybrid (Primarily remote with occasional in-person presence as required)

Position Summary :

Reporting to the Manager of Business Intelligence & Data Integration, the CCL Report Developer will design and maintain reports and data infrastructure within Oracle Health (Cerner) to support patient care, operational efficiency, and decision-making across Waterloo Regional Health Network. This role is responsible for developing and optimizing CCL-based reports and data extracts, building reliable data pipelines, and ensuring the accuracy, availability, and structure of clinical and operational data drawn from Cerner Millennium.

Key Responsibilities

• Design, develop, test, and maintain reports using Cerner Command Language (CCL) to support clinical, operational, and administrative decision-making.
• Build and optimize data extracts and pipelines that move data from Cerner Millennium into downstream reporting and analytics platforms.
• Troubleshoot and resolve issues with existing CCL reports, including performance tuning and data accuracy problems.
• Collaborate with clinical, operational, and analytics stakeholders to gather reporting requirements and translate them into technical specifications.
• Ensure reports and extracts comply with data governance standards, including data quality, security, and privacy requirements (e.g., PHIPA).
• Maintain documentation of report logic, data sources, and dependencies to support long-term maintainability.
• Support integration between Cerner data and other systems or platforms (e.g., Power BI, Microsoft Fabric) as needed.
• Participate in testing and validation of reports following Cerner upgrades, patches, or configuration changes.
• Provide technical guidance and knowledge transfer to team members and stakeholders on CCL-based reporting.
• Monitor and support production reporting jobs, addressing failures or discrepancies in a timely manner.

Position Requirements

• Candidate must reside in Ontario
• Master’s degree in health informatics, Computer Science, Data Engineering, or related field
• Minimum 5 years of experience with data analysis in a healthcare setting
• Minimum 3 years of experience with Power BI or Microsoft Fabric
• Experience using Cerner reporting tools (DA2, CCL, SAP BO)
• Proficient in SQL and Python
• Solid understanding of relational database structure and design
• Proficient in analyzing large, complex healthcare datasets to identify trends, patterns, and insights that support organizational objectives and improve patient care.
• Proven ability in collaborating with cross-functional teams including healthcare providers, IT, and stakeholders to understand data needs and deliver actionable insights.
• Excellent written and oral communication skills with ability to clearly define projects, objectives, goals, assignments, etc.

Preferred Requirements

• Experience with Oracle GoldenGate
• Practical knowledge of Tableau
• Experience with Cloud platforms

Waterloo Regional Health Centre is committed to fair and equitable employment and in our recruitment and selection practices. We strongly believe in inclusion and diversity within our organization, and welcome all applicants including, but not limited to racialized communities, all religions and ethnicities, persons with disabilities, LGBTQ2S+ persons, Indigenous people, and all others who may contribute to the further diversification of our Hospital community. We are committed to providing and fostering a respectful workplace for all employees, free from violence and harassment.

Accommodations are available during all stages of the recruitment process in accordance with the Human Rights Code. WRHN is committed to complying with the Accessibility for Ontarians with Disabilities Act (AODA) to provide an inclusive, barrier free workplace. We will accommodate the accessibility needs of individuals with disabilities to support participation in all aspects of the recruitment process. Should you require this accommodation, please contact Human Resources.

If you are seeking employment on a temporary work or study permit, we recommend reviewing work permit restrictions as it applies to healthcare organizations in Canada. Individuals holding a work or study permit seeking employment in the healthcare sector may be required to complete additional steps in the process. This may also apply to current employees seeking renewal of their work permits. It is the accountability of the applicant and/or employee to ensure they are adhering to their specific work permit restrictions.

We would like to thank all candidates in advance for their interest and only those candidates selected for an interview will be contacted. Due to the volume of applications, we receive, we are unable to confirm the receipt of individual applications or resumes.

WRHN does not use artificial intelligence (AI) to screen, assess, or make hiring decisions regarding applicants during our recruitment and selection process.

Salary: CAD 44.60-55.34

Post Date: 09/16/2026

Location: Hybrid on-site and remote

Address: 40 Green St, Kitchener, ON, N2G 1G3, CA