Epic BI Reporting and Analytics Developer/Analyst for Custody

Duration: 11-12 monthsLocation: Fully Remote - Must work PST hoursSummaryThis consultant will provide end-to-end delivery of reporting and analytics solutions in the Epic Cogito Clarity Custody Health space, with a focus on Ambulatory, Inpatient, Regulatory/State-required filings, Quality, and related metrics.The role requires consultant-level communication skills, the ability to coalesce related requests and provide solutions that satisfy multiple requirements, and adherence to Software Development Life Cycle (SDLC) standards including requirements gathering, solution design, SME signoff, coding, testing/validation, UAT, and documentation.What You Will DoDevelop and deploy Custody-focused reports and dashboardsValidate, modify, and document Radar automatic and custom SQL metricsWrite stored procedures for clinical reporting requests for use in Cogito SQL templatesCreate Radar components from Cogito SQL reports and metric frameworksUpdate code and dashboard metrics based on new regulatory and operational requestsLead projects and facilitate meetings with operational leadership to gather requirements for new requests and enhancementsEstimate timelines needed to complete projects and communicate updates to stakeholdersProvide status updates, manage expectations, and communicate risks/issues to stakeholders inside and outside of analyticsDirect regulatory agency monitors to reporting outputs and provide guidance on how to use themFollow SDLC standards for unit testing, peer reviews, SME validation, production migration, and publishingSupport knowledge transfer, mentorship, SQL code reviews, and peer review of deliverablesYou Will Be Successful IfYou have strong experience developing analytics solutions within the Epic Clarity Data Model environmentYou are comfortable working directly with operational clinical leaders, project teams, clinic staff, and other stakeholdersYou can adapt to changing workflows and communicate impacts to leadership effectivelyYou have experience creating Epic Radar Dashboards using Cogito SQL, Reporting Workbench, SlicerDicer, or Metric FrameworkYou are able to independently gather requirements, design solutions, and drive projects through completionYou have strong communication skills and can clearly document status updates, risks, issues, and technical solutionsYou thrive in collaborative environments and can efficiently work with application builders and technical teamsWhat You Will BringMinimum 3 years of Epic Clarity Data Model analytics development experience, including EpicCare Ambulatory and Inpatient (IP)5+ years of SQL query and stored procedure development experienceStrong experience creating stored procedures with Clarity data in a clinical settingWorking knowledge of Epic tools including SlicerDicer, Cogito SQL, and RadarExperience with Epic Inpatient workflows including Admissions, Flowsheets, Discharge Medication Reconciliation, and Quality metricsExperience with Epic Ambulatory workflows including Visits, Consults, Orders, and GroupersExperience creating Business Intelligence outputs in a Custody/Jail settingAbility to mentor junior developers, perform SQL code reviews, and support peer review processesStrong understanding of SDLC processes including testing, validation, and production migrationsCertification in Epic Clarity Data Model/Clinical or Financial (or legacy equivalents) preferredAbout Impresiv Health:Impresiv Health is a healthcare consulting partner specializing in clinical & operations management, enterprise project management, professional services, and software consulting services. We help our clients increase operational efficiency by delivering innovative solutions to solve their most complex business challenges.Our approach is and has always been simple. First, think and act like the customers who need us, and most importantly, deliver what larger organizations cannot do provide tangible results that add immediate value, at a rate that cannot be beaten. Your success matters, and we know it.That's Impresiv!