Clarity & Caboodle Analytics Architect (Hybrid)

Quoris, LLC; Philadelphia (Philadelphia County); Hybrid; USD 83,000 - 124,000; Part time

Benefits offered by this job

Health benefits

Dental benefits

Vision benefits

401k plan

Job summary

Quoris, LLC seeks a Clarity / Caboodle Analyst to build out the data foundation for an enterprise AI analytics platform anchored in Epic Clarity and Caboodle. You will design, implement, and maintain data models, extracts, and ingestion pipelines for revenue cycle analytics, including denials and prior authorization.

The role requires hands-on Clarity/Caboodle experience, strong SQL and ETL skills, and a deep understanding of PHI governance within a hospital setting.

Qualifications

• Bachelor's degree in Computer Science, Health Informatics, or related field; or equivalent hands-on experience.
• Hands-on production experience with Epic Clarity and Caboodle data models in a hospital or health system environment.
• Strong SQL/T-SQL skills with ETL development using SSIS or comparable tooling.
• Experience building data models or marts supporting revenue cycle, financial, or clinical analytics.
• Working understanding of HIPAA and PHI data-handling requirements in an analytics context.
• Comfortable working directly with health system IT stakeholders across Data Warehouse, Interface Engineering, and Epic application teams.
• Epic Clarity Data Model Certification required.
• Epic Caboodle Certification required.
• Ability to travel up to 20% as required.

Responsibilities

• Design, build, and maintain data extracts, transformations, and marts sourced from Epic Clarity and Caboodle to support enterprise analytics and downstream AI initiatives.
• Develop and maintain the ingestion architecture and data model needed for revenue cycle analytics including claims, denials, prior authorization, and eligibility data.
• Partner with Data Warehouse and Interface Engineering teams to define sizing, capacity, governance, and lineage standards for the platform's data foundation.
• Support pre-bill and post-bill reporting, KPI dashboards, and ad hoc analytics requests drawing on Clarity and Caboodle data.
• Validate data quality and reconcile discrepancies between source Epic systems and downstream data marts.
• Ensure PHI-handling controls including encryption, role-based access, and audit logging are applied consistently across data pipelines and reporting outputs.
• Document data models, extract logic, and lineage for handoff to steady-state operations.

Skills

SQL / T-SQL

ETL development

Epic Clarity

Epic Caboodle

HIPAA / PHI governance

Stakeholder collaboration

Travel readiness

Education

Bachelor's degree in Computer Science or Health Informatics

Equivalent hands-on experience

Tools

SSIS

SQL Server

Job description

Quoris, LLC seeks a Clarity / Caboodle Analyst to build out the data foundation for an enterprise AI analytics platform anchored in Epic Clarity and Caboodle. You will design, implement, and maintain data models, extracts, and ingestion pipelines for revenue cycle analytics, including denials and prior authorization.

The role requires hands-on Clarity/Caboodle experience, strong SQL and ETL skills, and a deep understanding of PHI governance within a hospital setting.