Habitat Health is looking to redefine aging in place by providing personalized, coordinated clinical and social care. The company needs to analyze clinical, operational, financial, and administrative data to enable leadership to make evidence-based decisions, design scalable solutions, and meet the healthcare needs and costs of aging populations.
Requirements
- 3+ years of experience working directly with Epic’s Clarity data model
- Expert level understanding of Clarity, Slicer Dicer, and Workbench (this is a MUST!)
- Highly proficient in SQL and at least 1 dashboard development tool
- Strong understanding of healthcare data ontologies including CPT, HCPCS, HCC, ICD-10, NDC, Revenue Codes, Type of Bill, LOINC, UB/HCFA claims, etc.
- Experience developing longitudinal patient analyses using complex clinical logic
- Demonstrated experience building dashboards and reports in Power BI or similar platforms
- Experience developing in a modern data stack using Databricks, Python, and/or Airflow
Responsibilities
- Use SQL to analyze clinical, operational, financial, and administrative data generated in Epic’s electronic health record (EHR) and practice management (PM) systems and stored in Epic’s back-end Clarity data model.
- Leverage Epic’s in-app reporting tools including Slicer Dicer, Reporting Workbench (RWB), and Radar to answer data questions from internal Habitat customers in the simplest / easiest / most scalable way possible.
- Enable leadership to make evidence-based decisions by designing, building, and maintaining business intelligence dashboards and data pipelines using tools such as Power BI, SQL, and Git
- Work with engineering to design and develop ETL processes that support consistent KPI reporting via Data Marts with clear documentation that codifies our standard “business rules” layer
- Develop rigorous data quality tests, QC best practices, code reviews / Git pull requests, dashboard release processes, and proper documentation to ensure your work is accurate and clearly communicated
- Develop detailed clinical logic and code sets for patient cohorts and quality measures including diagnosis groupers, hospital admissions, readmissions, ED visits, SNF visits etc. across a wide range of clinical facts and dimensions
- Build externally facing reports including PACE-specific measures and CMS / Medicaid regulatory and audit reporting in a scalable manner
Other
- Excellent communication skills; able to explain technical concepts to non-technical stakeholders
- Track record of working in cross-functional teams, ideally in a value-based care, PACE, or managed care environment
- Strong attention to detail and data quality, with a mindset toward reproducibility and documentation
- Experience working in early-stage or rapidly scaling healthcare organizations
- Experience with Medicare Advantage, PACE, and / or dual eligible populations
