Epic BI Reporting and Analytics Developer/Analyst for Custody

HJ Staffing • San Jose, CA

1d • Remote

About The Position

We are seeking an expert Epic BI Reporting and Analytics Developer/Analyst for Custody to provide end-to-end delivery of reporting solutions within the Custody Health space. This role focuses on Ambulatory, Inpatient, Regulatory/State-required filings, and Quality metrics. As a consultant, you will be expected to possess top-tier communication skills, the ability to coalesce complex, related requests into unified solutions, and a strict adherence to SDLC standards. You will guide projects from initial requirements gathering and solution design through to SME sign-off, coding, UAT, and final documentation.

Requirements

• Minimum 3 years of Epic Clarity Data Model development experience (specifically EpicCare Ambulatory and Inpatient).
• At least 5 years of SQL query and stored procedure development experience, particularly within a clinical setting.
• Proven track record creating BI outputs in a Correctional Health, Custody, Jail, or Detention environment is required.
• Working knowledge of SlicerDicer, Cogito SQL, and Radar Dashboards.
• Deep understanding of Inpatient (Admissions, Flowsheets, Discharge Med Rec) and Ambulatory (Visits, Consults, Orders, Groupers) workflows.
• Epic Clarity Certification (Clinical, Financial, Cogito, or legacy equivalent) is required.
• Experience in public sector healthcare or detention facilities is a critical component of this role.

Nice To Haves

• Comfortable working directly with clinical leaders, project teams, and clinic staff to translate needs into technical solutions.
• Ability to adapt quickly to changing workflows and communicate those impacts effectively to leadership.
• Self-starter who can independently drive projects through the entire lifecycle to completion.
• Thrive in collaborative environments and enjoy mentoring junior developers and performing peer reviews.

Responsibilities

• Develop and deploy Custody-focused reports and dashboards; validate, modify, and document Radar automatic and custom SQL metrics.
• Write complex stored procedures for clinical reporting requests for use in Cogito SQL templates; create Radar components from Cogito SQL reports and metric frameworks.
• Lead projects and facilitate meetings with operational leadership to gather requirements; estimate timelines and provide consistent status updates to stakeholders.
• Update code based on new regulatory/operational requests and direct regulatory agency monitors to reporting outputs, providing guidance on usage.
• Follow SDLC standards for unit testing, peer reviews, and production migration. Support knowledge transfer and mentorship through SQL code reviews.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed