Epic Caboodle System Administrator / Realm Analyst

W3Global; Canada; On-site; CAD 90,000 - 130,000; Full time

Job summary

W3Global in Canada is seeking a skilled Epic Caboodle Administrator to ensure availability, reliability, and performance of the Caboodle data warehouse supporting healthcare analytics and reporting.

You will administer, monitor, and maintain Caboodle, coordinate with Clarity, Cogito, and reporting teams, troubleshoot data loads, and support upgrades and disaster recovery while adhering to healthcare data governance standards.

Qualifications

• Bachelor's degree or equivalent professional experience in a relevant field.
• Experience with Epic Caboodle administration or operations.
• Strong understanding of Epic Caboodle architecture and data warehousing.
• Experience with SQL Server querying, monitoring, and performance troubleshooting.
• Familiarity with Windows Server environments and enterprise app support.

Responsibilities

• Administer, configure, monitor, and maintain the Epic Caboodle data warehouse environment.
• Monitor ETL processes, data loads, refresh schedules, and warehouse performance.
• Investigate and resolve data load failures and production issues.
• Support Caboodle upgrades, patches, and environment changes.
• Coordinate with Epic Clarity, Cogito, and analytics teams to resolve issues.
• Maintain system documentation, runbooks, and incident records.
• Participate in incident, problem, and change management activities.

Skills

Analytical skills

Troubleshooting

Documentation

Communication skills

Education

Bachelor's degree in Computer Science/Information Technology/Data Engineering or equivalent

Tools

Epic Caboodle

SQL Server

SSIS

Windows Server

Job description

The candidate will work closely with Epic application teams, reporting and analytics teams, database administrators, and infrastructure teams to ensure the availability, reliability, and performance of the Caboodle environment supporting healthcare analytics and reporting.

Key Responsibilities

• Administer, configure, monitor, and maintain the Epic Caboodle data warehouse environment.
• Support Caboodle system administration activities, including environment maintenance, system monitoring, and troubleshooting.
• Monitor ETL processes, data loads, refresh schedules, and data warehouse performance.
• Investigate and resolve data load failures, processing errors, system issues, and performance bottlenecks.
• Support Caboodle upgrades, patches, maintenance activities, and environment changes.
• Coordinate with Epic Clarity, Cogito, reporting, analytics, and database teams to resolve data warehouse issues.
• Support data warehouse availability, capacity planning, backup and recovery coordination, and disaster recovery procedures as applicable to the environment.
• Maintain system documentation, operational procedures, incident records, and technical runbooks.
• Participate in incident management, problem management, change management, and release management activities.
• Collaborate with technical and functional teams to ensure reliable data availability for healthcare reporting and analytics.
• Follow organizational security, access management, data governance, and healthcare compliance standards.

Required Qualifications

• Relevant experience in healthcare IT, data warehouse administration, or enterprise database support.
• Hands-on experience with Epic Caboodle administration or operational support.
• Understanding of Epic's data warehousing and analytics architecture.
• Knowledge of SQL Server, SQL querying, database monitoring, and performance troubleshooting.
• Experience monitoring data loads, investigating failures, and resolving production issues.
• Familiarity with Windows Server environments and enterprise application support.
• Strong analytical, troubleshooting, documentation, and communication skills.

Preferred Qualifications

• Epic Caboodle certification - MUST
• Experience with Epic Clarity, Cogito, and Epic reporting and analytics environments.
• Experience with SQL Server Integration Services (SSIS), ETL processes, and data warehouse operations.
• Knowledge of healthcare data models and reporting workflows.
• Experience supporting high-availability, disaster recovery, and production environments.
• Familiarity with ITIL-based incident, problem, and change management processes.
• Experience working with hospital systems or healthcare organizations.

Education

Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field, or equivalent professional experience.