Apply now

Posted 5 months ago

CCL Report Writer - Temporary Full-Time - Project REACH - 2026-17233

@ Sunnybrook Health Sciences Centre

Toronto, Ontario

Full-timeTemporary3+ years experience
Apply now
SIGNALS

Overview

Sunnybrook Health Sciences Centre is hiring a temporary full-time CCL Report Writer for Project REACH, its Oracle Health Hospital Information System implementation. The role develops and optimizes Cerner CCL scripts for clinical, operational and regulatory reporting, with a hybrid arrangement of 3 days on site and 2 days remote.

Responsibilities:

  • Design, develop and maintain CCL scripts for Cerner Millennium reporting
  • Validate, reconcile and migrate data for Project REACH
  • Optimize slow-running CCL scripts and queries
  • Document report logic and data mappings
  • Support clinical and operational stakeholders with ad hoc reporting

Requirements summary:

  • 3 to 5+ years of hands-on Cerner CCL development
  • Strong SQL and Oracle database experience
  • Understanding of the Cerner Millennium data model
  • Experience with Linux or Unix environments
  • Degree or diploma in health informatics, computer science or related field

Tools & skills

Source and dates

Source type not verified · talcura

Employer posting date
2026-06-30
First seen by our source
2026-10-11
Source record updated
2026-10-18

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SeniorityMid level
DepartmentIT
Experience3+ years
Hours per week40 (estimated)
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish
EducationCollege diploma (required), Bachelor’s degree (required)
Fields of studyHealth Informatics, Computer Science, Information Systems

Summary and details written by AI from the posting; the employer’s posting is the authority.

Sunnybrook Health Sciences Centre

FieldValue
Open jobs on Jobsy451
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

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

Similar jobs

  • People Lead, Inside Sales

    Toronto, ON
    HybridFull Time

    Global Payments Canada GP

    5+ years of business-to-business (B2B) sales experience with a demonstrated track record of exceeding revenue and performance targets; 2-3 years of people leadership, coaching, or team management experience within a…

  • Bilingual Customer Care Specialist

    Toronto, ON
    Contract

    Reports To: Lead, Customer Experience; Success in this role requires strong bilingual communication, empathy, problem-solving, sound judgment, adaptability and the ability to effectively manage multiple priorities and…

  • Growth Manager, Brokers & Advisors

    Toronto, ON
    $130k–$160k/yrRemoteFull Time

    Medcan Health Management Inc.

    5+ YOECandidates need 5+ years of B2B sales or business development in group benefits, insurance or health and wellness, with proven success working with advisors or brokerages. They also need a strong knowledge of the Canadian group benefits market, CRM skills, and willingness to travel within Ontario.

    Salesforce, Microsoft Office, PowerPoint

  • Senior Business Analyst

    Toronto, ON
    On-siteFull Time

    The Toronto-Dominion Bank (Canada)

    5+ YOECandidates need an undergraduate degree and 5 to 7+ years of business analysis experience, including delivery work. Business Analysis accreditation and Agile experience are assets.

    Customer experience, Business processes, Change management, Communication skills, Critical thinking, Communicate with stakeholders

    Sr. Business Systems Analyst

    Toronto, ON
    On-siteFull Time

    The Toronto-Dominion Bank (Canada)

    5+ YOECandidates need 5+ years of business systems analysis experience, hands-on hedge accounting experience, and experience leading a team of analysts. Strong SQL, Agile, JIRA and Confluence skills, AI tool use, and stakeholder communication are required.

    SQL, JIRA, Confluence, Microsoft Copilot, GitHub Copilot

    Customer Experience Associate - Inviting Applicants who identify as First Nation (Status and Non-Status) Inuit, and Métis

    Toronto, ON
    On-sitePart Time

    The Toronto-Dominion Bank (Canada)

    The Toronto-Dominion Bank asks candidates who identify as First Nation, Inuit, or Métis to apply.

    Customer experience

  • Senior Full Stack Engineer - ClickStack

    Toronto, ON
    RemoteFull Time

    ClickHouse

    5+ YOECandidates need 5+ years of software engineering experience, ideally building developer tools. They need strong TypeScript, Node.js, React and SQL skills, plus experience with Docker and Kubernetes.

    ClickHouse, Docker, Kubernetes, Next.js, Express, React

  • Principal, Mobile Product Designer

    Toronto, ON +1
    Full Time

    Company 1 - The Manufacturers Life Insurance Company

    5+ YOECandidates need 5+ years as a product designer focused on native iOS and Android experiences, strong Figma skills, and a portfolio showing end-to-end product design. Experience with mobile design systems, accessibility, native platform patterns and AI-assisted design tools is required, and financial services experience is an asset.

    Figma, Figma Make, GitHub Copilot, iOS SDK, Android SDK

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.