Hybrid Healthcare BI Report Developer | Cerner & Power BI

Grand River Hospital

Kitchener

Hybrid

CAD 61,000 - 76,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

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.