0000044051 - DATA ARCHITECT - CCL DEVELOPER, FT

Niagara Health; Canada; On-site; CAD 115,000 - 125,000; Full time

Job summary

Niagara Health is seeking a skilled Data Architect/CCL Developer to lead data architecture and reporting efforts across the enterprise. You will design, code, and implement Cerner CCL extracts and high-performance SQL queries while collaborating with Data Engineers and clinicians to meet data needs and ensure data quality and security.

The role demands 5+ years in Oracle Cerner programming within healthcare, strong data warehousing knowledge, and experience with Discern Explorer/Rules and

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Formal training and/or demonstrated experience in Oracle Cerner CCL development and reporting.
• Minimum 5 years of Oracle Cerner programming experience with reports, data extracts, MPages, and DB solutions.
• Minimum 5 years of healthcare experience, preferably in Canada.
• 2-3 years in BI, Data Architecture/Engineering, or Database Administration.
• Strong understanding of clinical/operational healthcare data structures and workflows.
• Advanced expertise in Oracle databases, SQL, CCL, Discern Explorer/Rules, PowerInsight/DA2.
• Experience designing, executing, and validating testing scenarios.
• Strong analytics and stakeholder engagement skills, including requirements gathering.
• Experience with cloud platforms (Azure/AWS/GCP) and Microsoft data/analytics tech.
• Knowledge of data warehousing, governance, and best practices; related certifications are assets.
• Proven ability to collaborate across multidisciplinary teams and share digital health knowledge.

Responsibilities

• Analyze healthcare data structures to support data migration, modeling, and architecture with SQL, CCL, and BI tools.
• Perform data profiling and analysis of Millennium data for reporting and analytics.
• Design, develop, and optimize Cerner CCL extracts, scripts, reports, and high-performance SQL queries.
• Identify data quality gaps and propose scalable, sustainable solutions.
• Ensure data quality, privacy, security, and compliance through testing and validation.
• Collaborate with stakeholders to gather requirements and deliver reporting/BI solutions.
• Partner with Data Engineers, DBAs, and decision-support teams to enable data integration.
• Support data governance standards and best practices across teams.

Skills

Cerner CCL development

SQL

Data modeling

Healthcare analytics

Requirements gathering

Cross-functional collaboration

Problem solving

Education

Bachelor's degree in Computer Science/Information Systems

Tools

Discern Explorer

Discern Rules

PowerInsight/DA2

Oracle database

Business Objects

Job description

INFORMATION AND COMMUNICATION TECHNOLOGY

Job Details

Job Title: DATA ARCHITECT - CCL DEVELOPER, FT
Posted Date: 8/12/2026 Closing Date: 8/25/2026 Functional Discipline: INFORMATION AND COMMUNICATION TECHNOLOGY

Job Description

VACANCY DETAILS

VACANCY NUMBER: 44051PS
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: 25 AUGUST 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.

Help This page displays details of the selected vacancy.