Data Architect - CCL Developer

Niagara Health; Golden Horseshoe; On-site; CAD 70,000 - 99,000; Full time

Job summary

Niagara Health is seeking a Data Architect - CCL Developer for a full-time, on-site role in the Information Technology department. You will design, develop, and implement Cerner CCL extracts, reports, and data architecture solutions to support patient care delivery.

The ideal candidate has 5+ years Oracle Cerner programming experience, advanced CCL, Discern Explorer/Rules, and PowerInsight/DA2, with a healthcare background in Canada.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Formal training in Oracle Cerner CCL development and reporting.
• Minimum 5 years of Oracle Cerner programming experience.
• Minimum 5 years of healthcare experience, preferably in a Canadian healthcare environment.
• 2-3 years of experience in BI, Data Architecture/Engineering, or Database Administration.
• Strong understanding of clinical and operational healthcare data structures and workflows.
• Advanced expertise in Oracle databases, SQL, CCL, Discern Explorer, Discern Rules, and PowerInsight/DA2.
• Experience with cloud platforms such as Azure, AWS, or GCP.

Responsibilities

• Analyze data structures, including tables and fields, to support data migration, modeling, and architecture using SQL, Oracle Cerner (CCL), and Business Objects.
• Profile data and analyze Millennium data structures to support reporting, analytics, and decision-making.
• Design, develop, and optimize Cerner CCL extracts, scripts, reports, and high-performance SQL queries.
• Identify data quality issues and opportunities for improvement, recommending scalable solutions.
• Ensure data quality, privacy, security, and compliance through monitoring, testing, and validation.
• Collaborate with stakeholders to gather requirements and deliver reporting, analytics, and BI solutions.
• Work with Data Engineers, DBAs, and other teams to enable data integration and accessibility.
• Support and enforce data governance standards and best practices.

Skills

SQL

Cerner CCL

Discern Explorer

Discern Rules

PowerInsight/DA2

Data architecture

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle Cerner

SQL

Job description

JOB TITLE: DATA ARCHITECT - CCL DEVELOPER, FT

STATUS: FULL TIME

DEPARTMENT: INFORMATION TECHNOLOGY

LOCATION: NIAGARA HEALTH

HOURS OF WORK: 75 HOURS PER PAY PERIOD; MONDAY TO FRIDAY

POSTING DATE: 12 AUGUST 2026

CLOSING DATE: 04 SEPTEMBER 2026

UNION: NON UNION

WAGE RANGE: 61.298 PER HOUR

THE POSITION IS COMPENSATED ACCORDING TO AN ESTABLISHED WAGE GRID, WITH PROGRESSION THROUGH THE STEPS OCCURRING IN ACCORDANCE WITH APPLICABLE POLICIES UNTIL REACHING THE MAXIMUM OF THE SALARY RANGE.

POSITION OBJECTIVE:

Niagara Health is entering a time of great opportunity and transformation. We are looking for exceptional individuals to be part of our extraordinary team and future that includes a focus on leveraging information and technology to transform how we plan and deliver patient care at Niagara Health and across the Niagara region.

We are searching for a qualified experienced Data Architect / CCL Developer with experience in healthcare, expert knowledge of CCL/Discern Explorer, Power InSight/DA2, and Discern Rules. As a valued member of the Enterprise Analytics team, you will play a crucial hands‑on role in designing, coding and implementing several report solutions and meeting data-related needs. We are looking for a strong hands‑on candidate who possesses advanced capability in Cerner Command Language (CCL), Oracle Cerner's reporting coding language. This role combines hands‑on Cerner CCL development with enterprise data architecture responsibilities.

KEY RESPONSIBILITIES:

• Analyze healthcare system data structures, including tables and fields, to support data migration, modeling, and architecture using SQL, Oracle Cerner (CCL), and Business Objects
• Perform data profiling and analysis of Millennium data structures to support reporting, analytics, and operational decision-making
• Design, develop, and optimize Cerner CCL extracts, scripts, reports, and high‑performance SQL queries
• Identify data quality issues, gaps, and opportunities for improvement, recommending scalable and sustainable solutions
• Ensure data quality, integrity, privacy, security, and compliance through ongoing monitoring, testing, and validation
• Partner with internal and external parties to gather requirements and deliver reporting, analytics, and business intelligence solutions
• Collaborate with Data Engineers, Database Administrators, Decision Support Advisors, and other technical teams to enable seamless data integration and accessibility
• Support and enforce data governance standards, policies, and best practices to ensure data consistency, accuracy, and reliability
• Enhance system performance and data infrastructure through testing, troubleshooting, audits, and implementation of new technologies and processes

QUALIFICATIONS:

• Bachelor's degree in Computer Science, Information Systems, or a related field, or an equivalent combination of education and experience
• Formal training and/or demonstrated experience in Oracle Cerner CCL development and reporting
• Minimum 5 years of Oracle Cerner programming experience, including developing custom reports, data extracts, MPages, and other database solutions
• Minimum 5 years of healthcare experience, preferably within a Canadian healthcare environment
• 2-3 years of experience in Business Intelligence, Data Architecture/Engineering, or Database Administration
• Strong understanding of clinical and operational healthcare data structures and workflows
• Advanced expertise in Oracle databases, SQL, CCL, Discern Explorer, Discern Rules, and PowerInsight/DA2
• Experience designing, executing, and validating testing scenarios
• Strong analytical, problem-solving, and internal and external partner engagement skills, including requirements gathering and validation
• Experience with cloud platforms such as Azure, AWS, or GCP
• Working knowledge of Microsoft data and analytics technologies and infrastructure
• Understanding of data warehousing principles, data governance, and industry best practices
• Relevant certifications or training in Oracle/Cerner technologies, healthcare analytics, or data warehousing are considered assets
• Proven ability to collaborate across multidisciplinary teams and facilitate knowledge transfer related to digital health standards and technologies

Questions, quoting the job posting number, may be directed to [e-mail]

This position is an existing vacancy at Niagara Health. No artificial intelligence is used in the screening, assessment, or selection of applicants. If you believe you have encountered or applied for a fraudulent job posting claiming to represent Niagara Health, please contact [e-mail]

At Niagara Health, we value diversity, equity and inclusion, and welcome applications from all people. We are especially interested in hearing from you if you are excited about being part of a respectful and hard‑working team in the beautiful Niagara Region, have a passion for service and excellence in healthcare, have a background or related expertise in the healthcare environment, supporting patient care and providing extraordinary customer‑service.

In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, Niagara Health will provide accommodations through the recruitment process to applicants with disabilities. If selected to participate in the recruitment and selection process, please inform Human Resources of the nature of any accommodation(s) that you may require in respect of any materials or processes used to ensure your equal participation.

At Niagara Health, we are committed to advancing diversity, equity and inclusion. As a part of this work, we collect information on Ontario Human Rights Code grounds and non‑Code grounds in order to: hire and retain diverse talent, prevent and/or address systemic barriers to access and opportunity, improve service delivery and programs and advance diversity and inclusion overall. All identification questions are optional and include a "prefer not to answer" option.