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 co ****mmunication 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.