Epic BI Reporting and Analytics Developer

San Jose, CA – Remote

About the role

Develop new and maintain existing 340B accumulation and audit reports, end-to-end delivery of reporting and analytics solutions in the Epic Cogito Clarity/Caboodle Clinical pharmacy domain, and development and maintenance of various pharmacy-related federal and state grant-required reporting. The role requires consultant-level communication skills, the ability to coalesce related requests and offer solutions that satisfy multiple requirements, and Software Development Life Cycle discipline: gathering and documenting requirements, designing solutions, obtaining SME sign-off, coding, testing/validation, UAT, and documentation.

Responsibilities

• Develop custom reports and audit files for the pharmacy 340B program.
• Create and maintain Pharmacy/Willow Inpatient, Ambulatory, and Inventory reporting, metrics, and dashboards.
• Maintain and update Pharmacy/Willow cubes.
• Perform peer review of reporting developed by other team members.

Requirements

• Business Intelligence Systems Architecture experience.
• Strong SQL development using best-practice industry standards.
• Advanced understanding, usage of, and ability to navigate the Clarity data model.
• Clarity Pharmacy analytics development.
• Epic Cogito Certification and strong knowledge of Epic’s Cogito suite of products.
• Knowledge of Epic-Crystal integration (ECI) and Crystal Reports.
• 340B Accumulation and Billing experience.
• Pharmacy-related financial experience.

Qualifications

• Epic Clarity Data Model/Clinical and Caboodle Data Model Fundamentals (or legacy equivalents).