Systems Analyst, Clinical Solutions, PDHIS
2 weeks agoPHSA - Provincial Health Services Authority
Burnaby, BC
Canadian Digital Health & Health Informatics Opportunities
1,271 jobs
🔒 You're missing out on 336 recent eHealth careers postings matching your search!
⭐ Unlock recent jobsSite Lead (OceanMD Implementation)
2 weeks agoPHSA - Provincial Health Services Authority
Vancouver, BC
Systems Analyst, Clinical Solutions, IMITS
2 weeks agoPHSA - Provincial Health Services Authority
Burnaby, BC
Bilingual Senior Project Manager
2 weeks agoTELUS Health
Calgary, AB
Bilingual Senior Project Manager
2 weeks agoTELUS Health
Winnipeg, MB
Bilingual Senior Project Manager
2 weeks agoTELUS Health
Ottawa, ON
Bilingual Senior Project Manager
2 weeks agoTELUS Health
Regina, SK
Bilingual Senior Project Manager
2 weeks agoTELUS Health
Vancouver, BC
Senior Systems Analyst - Information Management & Technology
2 weeks agoNova Scotia Health
Bedford, NS
Bilingual Senior Project Manager
2 weeks agoTELUS Health
Moncton, NB
Sr. Project Manager
2 weeks agoAgfa
Remote, AB
Conseiller(ère) principal(e) et statisticien(ne), recherche centrée sur le patient -- Senior Consultant and Statistician, Patient Centered Solutions
2 weeks agoIQVIA
Mississauga, ON
Director of Hardware Engineering
2 weeks agoMyant Corp
Mississauga, ON
Data Analyst - Transplant Quality Program
2 weeks agoLondon Health Sciences Centre
University Hospital, ON
Lead Program Manager - Strategy Enablement
2 weeks agoMcKesson
Mississauga, ON
Delivery Manager
2 weeks agoLeague Inc
ON
Delivery Manager
2 weeks agoLeague Inc
ON
Head of Design
2 weeks agoFullscript
Toronto, ON
Pharmacy Data Specialist-1
2 weeks agoShoppers Drug Mart
Mississauga, ON
Associate Product Manager - Advanced Insights
2 weeks agoPointClickCare
Remote or Mississauga, ON
$87,500 – $97,200/year
CCL Report Writer - Temporary Full-Time - Project REACH - 2026-17233
Sunnybrook Health Sciences Centre
🔒 Application Instructions
Application instructions are available to Premium subscribers.
LocationSunnybrook Health Sciences Centre, Bayview, Toronto, ON, CAOpen
eHealth role summary
Role is directly focused on EHR/HIS implementation and reporting (Cerner Millennium CCL development), data extraction, validation, migration, and integrations (HL7/FHIR) for a hospital system.
About this role
Position Summary
Sunnybrook Health Sciences Centre is undertaking Project REACH, a multi-year initiative to implement Oracle Health’s Hospital Information System (HIS).
We are seeking a CCL Report Writer to support data extraction, reporting, and analytics within the Cerner Millennium environment. This role will focus on developing and optimizing Cerner Command Language (CCL) scripts to enable clinical, operational, and regulatory reporting needs throughout implementation and post go-live.
This role bridges clinical workflows and technical data structures—ensuring accurate, performant, and meaningful reporting to support decision-making, data migration, and system validation.
Key Responsibilities
CCL Development & Reporting
- Design, develop, test, and maintain complex CCL scripts to extract data from Cerner Millennium (Oracle) databases.
- Translate clinical and operational requirements into technical report specifications.
- Develop reports supporting patient care, operational metrics, quality improvement, and regulatory reporting.
- Utilize advanced SQL constructs within CCL.
Data Analysis & Validation
- Analyze healthcare data across domains such as patient demographics, encounters, orders, and clinical events.
- Support data validation, reconciliation, and migration activities for Project REACH.
- Partner with Data & BI teams to ensure data accuracy and consistency across reporting outputs.
Performance Optimization
- Troubleshoot and optimize slow-running CCL scripts and queries.
- Improve report efficiency to minimize system resource utilization.
- Apply indexing strategies and query tuning best practices within Oracle environments.
Integration & Data Support
- Support reporting requirements tied to system integrations (HL7, FHIR, interfaces).
- Assist in validating inbound/outbound data flows and downstream reporting impacts.
- Collaborate with Integration and Application teams to ensure end-to-end data integrity.
Documentation & Support
- Document report logic, technical specifications, and data mappings.
- Provide ad hoc and user-defined reporting support to clinical and operational stakeholders.
- Develop error handling, logging, and validation checks within scripts.
Collaboration & Stakeholder Engagement
- Work closely with clinicians, analysts, and project teams to define reporting needs.
- Participate in design sessions, testing cycles, and go-live readiness activities.
- Support end-user understanding of reports and underlying data structures.
Qualifications & Experience
- Degree or diploma in Health Informatics, Computer Science, Information Systems, or related field.
- 3–5+ years of hands-on experience with Cerner CCL development.
- Strong experience with SQL and Oracle databases.
- Proven understanding of Cerner Millennium data model (e.g., person, encounter, clinical_event, orders).
- Experience working in Linux/Unix environments for script execution and troubleshooting.
- Familiarity with healthcare workflows (inpatient, outpatient, ancillary services).
- Experience supporting EHR implementations, data migration, or reporting modernization initiatives is preferred.