Bi Report Developer

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

Location: Hybrid (Primarily remote with occasional in-person presence as required)

This role is being advertised to fill an existing vacancy

Home to seven regional programs and comprehensive health-care services, Waterloo Regional Health Network (WRHN, pronounced wren) is committed to meeting the current and emerging needs in Waterloo-Wellington and beyond.

WRHN is redefining the health-care experience through collaboration and innovation, addressing barriers to access, advancing care delivery, and setting new standards in compassionate, empowered community-driven health care.

At WRHN, every patient is at the centre of everything we do as we strive to improve lives, inspire healing, and build healthier, stronger communities. By listening to patients and partners, we strive to connect communities to the right care, at the right place, and at the right time.

Please Note: New employees must provide documentation/proof of COVID-19 vaccination status, a 2-step TB test, as well as proof of immunity to measles, mumps, rubella, and varicella (chickenpox) prior to their start date at Waterloo Regional Health Network (WRHN). New Employees will require clearance from Employee Health, Safety and Wellness before they are able to begin any position within WRHN.

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 is a must (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

Application Instructions:

EMPLOYEES OF LEGACY ST. MARY’S GENERAL HOSPITAL ARE REQUIRED TO SUBMIT THEIR APPLICATION ELECTRONICALLY USING INFOR.

Where applicable, as per the collective agreement, the internal recruitment process will be completed prior to the consideration of external applications.

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.