BI Reporting and Analytics Developer/Analyst – Custody

Bickham Services Unlimited, LLC

Consultant providing end-to-end delivery of reporting and analytics solutions. Focus on Ambulatory, Inpatient, and related metrics in the Epic Cogito Clarity Custody Health space.

Posted 5/14/2026full-timeRemote • California • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

SDLCSQL

About the role

Key responsibilities & impact

Develop and deploy Custody-focused reports and dashboards
Validate, modify, and document Radar automatic and 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 frameworks
Update code and dashboard metrics based on new regulatory and operational requests
Lead projects and facilitate meetings with operational leadership to gather requirements for new requests and enhancements
Estimate timelines needed to complete projects and communicate updates to stakeholders
Provide status updates, manage expectations, and communicate risks/issues to stakeholders inside and outside of analytics
Direct regulatory agency monitors to reporting outputs and provide guidance on how to use them
Follow SDLC standards for unit testing, peer reviews, SME validation, production migration, and publishing
Support knowledge transfer, mentorship, SQL code reviews, and peer review of deliverables

Requirements

What you’ll need

Minimum 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 experience
Strong experience creating stored procedures with Clarity data in a clinical setting
Working knowledge of Epic tools including SlicerDicer, Cogito SQL, and Radar
Experience with Epic Inpatient workflows including Admissions, Flowsheets, Discharge Medication Reconciliation, and Quality metrics
Experience with Epic Ambulatory workflows including Visits, Consults, Orders, and Groupers
Experience creating Business Intelligence outputs in a Custody/Jail setting
Ability to mentor junior developers, perform SQL code reviews, and support peer review processes
Strong understanding of SDLC processes including testing, validation, and production migrations
Certification in Epic Clarity Data Model/Clinical or Financial (or legacy equivalents) preferred

Benefits

Comp & perks

Professional development
Mentorship

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLstored proceduresEpic Clarity Data ModelCogito SQLRadarBusiness Intelligencedata validationunit testingpeer reviewsproduction migration

Soft Skills

mentorshipproject leadershipstakeholder communicationrequirement gatheringexpectation managementrisk managementknowledge transferteam collaborationfacilitationstatus reporting

Certifications

Epic Clarity Data Model certificationClinical certificationFinancial certification