Epic BI Reporting and Analytics Developer/Analyst for Custody

OBJECTIVE: This consultant will provide end-to-end delivery of reporting and analytics solutions in the Epic Cogito Clarity Custody Health space, especially on Ambulatory, Inpatient, Regulatory / State required fillings, Quality and related metrics. 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 & documenting and confirming requirements gathering, designing solution, obtaining Subject Matter Experts (SMEs) signoff, coding, testing/validation, UAT, & documentation. TYPICAL DELIVERABLES: Develop and deploy Custody-focused reports and dashboards Validate, modify, and document Radar automatic & custom SQL metrics Write stored procedures for clinical reporting requests for use in Cogito SQL templates Create Radar components from Cogito-SQL reports and metric-framework Update Code and Dashboard metrics based on new regulatory and operational requests Lead projects Facilitate meetings with Custody operations and leadership to gather requirements for new requests and enhancements Estimate time needed to complete project Communicate to stakeholders inside and outside of analytics, providing updates and setting expectations Direct regulatory agency monitors to reporting outputs and provide guidance on how to use them REQUIRED SKILLS & ABILITIES: Minimum 3 years of Epic Clarity Data Model (EpicCare Ambulatory, Inpatient (IP)) analytics development. 5+ years of SQL query and stored procedure development experience. Working knowledge of Epic tools such as Slicer Dicer, Cogito SQL, Radar Strong ability to work directly with TSS managers and operational clinical leaders, project office, clinic staff and other stakeholders Strong ability to work collaboratively with Epic, and County Epic application builders to capture official workflow documentation efficiently and accurately Strong communication skills to document and communicate with analytics and other TSS management on status, risks and issues Ability to transition work, train, and provide mentorship to junior developers on best practices, perform SQL code reviews, and peer reviews of deliverables. Ability to follow Enterprise Software Development Life Cycle standards for Unit Test, Peer Test/Review, SME Validation and production migration and publishing. Strong experience creating Stored Procedures with Clarity data in a clinical setting Consultant level ability to adapt to changing workflows, and communicate to leadership changes in data based on workflow adherence Epic Radar Dashboards created from Cogito SQL, Reporting Workbench, SlicerDicer or Metric Framework Epic Inpatient experience: Admissions, Flowsheets, Discharge Medication Reconciliation, Quality metrics Epic Ambulatory experience: Visits, Consults, Orders, Groupers Experience creating Business Intelligence outputs in a Custody/Jail setting ADDITIONAL QUALIFICATIONS Certification in Epic Clarity Data Model/Clinical or Financial (or legacy equivalents) Benefits at IntelliBee Long-Term Stability: Join us on a multi-year opportunities with room to grow. Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well. Future Planning: Enroll in our 401(k) program and invest in your financial security. GC Assistance: We support immediate Green Card processing, if required.