Welcome to health care that soars above. BI Report Developer (Job ID: 6889) Work Type: Temporary Full Time (until December 10, 2027) Hybrid (Primarily remote with occasional in-person presence as required) 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.

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., 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. 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 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.

Experience with Oracle GoldenGate Practical knowledge of Tableau 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. 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. 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.

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 Location: Hybrid in office and remote

📌 Data Analytics/BI Developer (Waterloo)
🏢 Grand River Hospital
📍 Waterloo