Epic BI Reporting and Analytics Developer/Analyst for Custody
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.
What You Will Do
Solution Development: Develop and deploy Custody-focused reports and dashboards; validate, modify, and document Radar automatic and custom SQL metrics. Technical Execution: Write complex stored procedures for clinical reporting requests for use in Cogito SQL templates; create Radar components from Cogito SQL reports and metric frameworks. Project Leadership: Lead projects and facilitate meetings with operational leadership to gather requirements; estimate timelines and provide consistent status updates to stakeholders. Regulatory Support: Update code based on new regulatory/operational requests and direct regulatory agency monitors to reporting outputs, providing guidance on usage. Governance & Quality: Follow SDLC standards for unit testing, peer reviews, and production migration. Support knowledge transfer and mentorship through SQL code reviews. What You Will Bring Epic Expertise: Minimum 3 years of Epic Clarity Data Model development experience (specifically EpicCare Ambulatory and Inpatient). SQL Mastery: At least 5 years of SQL query and stored procedure development experience, particularly within a clinical setting. Specialized Experience: Proven track record creating BI outputs in a Correctional Health, Custody, Jail, or Detention environment is required. Tool Proficiency: Working knowledge of SlicerDicer, Cogito SQL, and Radar Dashboards. Workflow Knowledge: Deep understanding of Inpatient (Admissions, Flowsheets, Discharge Med Rec) and Ambulatory (Visits, Consults, Orders, Groupers) workflows. Certification: Epic Clarity Certification (Clinical, Financial, Cogito, or legacy equivalent) is required. You Will Be Successful If You are comfortable working directly with clinical leaders, project teams, and clinic staff to translate needs into technical solutions. You can adapt quickly to changing workflows and communicate those impacts effectively to leadership. You are a self-starter who can independently drive projects through the entire lifecycle to completion. You thrive in collaborative environments and enjoy mentoring junior developers and performing peer reviews. Additional Details Schedule: This position is 100% remote, but candidates must be available to work standard PST hours. Compliance: Experience in public sector healthcare or detention facilities is a critical component of this role. Note to Applicants: Please ensure your Epic Certifications are clearly listed on your resume. Apply To This Job