CCL Report Writer - Temporary Full-Time - Project REACH - 2026-17233 (2026-17233)
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Experience
- 3–5+ years of hands-on experience with Cerner CCL development.
- Posting language
- English
- Posted
Original job description
Position Type: Hybrid (3 days on site, 2 days remote)
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
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
More about this job
Responsibilities
Develop, test, maintain, and optimize CCL scripts and reports for clinical, operational, quality, and regulatory needs in Cerner Millennium. Support data validation and migration, integration reporting, documentation, and stakeholder collaboration through implementation, testing, and go-live.
Requirements
A degree or diploma in Health Informatics, Computer Science, Information Systems, or a related field is requested, along with 3–5+ years of hands-on Cerner CCL development and strong SQL and Oracle experience. Candidates should understand the Cerner Millennium data model, have Linux/Unix experience and familiarity with healthcare workflows; EHR implementation, migration, or reporting modernization experience is preferred.
Skills
- Cerner CCL Development
- SQL
- Oracle Databases
- Cerner Millennium Data Model
- Healthcare Data Analysis
- Data Validation
- Data Migration
- Query Optimization
- Linux/Unix
- Healthcare Workflows
- HL7
- FHIR
- Report Development
- Technical Documentation
- Stakeholder Collaboration
Visa sponsorship
Not detected in the job text
Categories
- Healthcare
- Technology
- Data & Analytics
- Software
Keywords
- Cerner Command Language (CCL)
- Cerner Millennium
- Oracle Health
- Oracle Databases
- SQL
- Healthcare Reporting
- Clinical Reporting
- Operational Reporting
- Regulatory Reporting
- Data Extraction
- Data Analysis
- Data Validation
- Data Reconciliation
- Data Migration
- Query Tuning
- Indexing Strategies
- Linux/Unix
- HL7
- FHIR
- System Integrations
- EHR Implementation
- Healthcare Workflows
- Patient Demographics
- Clinical Events
- Orders
- Data Mapping
- Error Handling
- Logging
- Go-Live Readiness