This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.

Role Description

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.
• Work closely with other data team members to ensure you benefit from all the great work happening around you!

Qualifications

• 3+ years of experience working directly with Epic’s Clarity data model.
• Highly proficient coding in SQL; experience with Git is a plus.
• 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.
• 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.

Requirements

• Familiarity with Epic Workflows and Clarity reporting tools, like Slicer Dicer, Reporting Workbench, and Cogito SQL.
• Experience developing in a modern data stack using Databricks, Python, and/or Airflow.
• Experience working in early-stage or rapidly scaling healthcare organizations.
• Experience with Medicare Advantage, PACE, and/or dual eligible populations.

Compensation

We take into account an individual’s qualifications, skillset, and experience in determining final salary. This role is eligible for medical/dental/vision insurance, short and long-term disability, life insurance, flexible spending accounts, 401(k) savings, paid time off, and company-paid holidays. The expected salary range for this position is $90,000- $105,000 and is bonus-eligible. The actual offer will be at the company’s sole discretion and determined by relevant business considerations, including the final candidate’s qualifications, years of experience, skillset, and geographic location.

Vaccination Policy, including COVID-19

At Habitat Health, we aim to provide safe and high-quality care to our participants. To achieve this, please note that we have vaccination policies to keep both our team members and participants safe. For covid and flu, we require either proof of vaccination or declination form and required masking while in participant locations as a safe as an essential requirement of this role. Requests for reasonable accommodations due to an applicant’s disability or sincerely held religious beliefs will be considered and may be granted based upon review. We also require that team members adhere to all infection control, PPE standards and vaccination requirements related to specific roles and locations as a condition of employment.

Our Commitment to Diversity, Equity, and Inclusion

Habitat Health is an Equal Opportunity employer and is committed to creating a diverse and inclusive workplace. Habitat Health applicants are considered solely based on their qualifications, without regard to race, color, religion, creed, sex, gender (including pregnancy, childbirth, breastfeeding or related medical conditions), gender identity, gender expression, sexual orientation, marital status, military or veteran status, age, national origin, ancestry, citizenship, physical or mental disability, medical condition, genetic information or characteristics (or those of a family member), or other status protected by applicable law.

Habitat Health is committed to the full inclusion of all qualified individuals. In keeping with our commitment, Habitat Health will take steps to provide people with disabilities and sincerely held religious beliefs with reasonable accommodations in accordance with applicable law. Accordingly, if you require a reasonable accommodation to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please contact us at careers@habitathealth.com.

Beware of Scams and Fraud

Please ensure your application is being submitted through a Habitat Health sponsored site only. Our emails will come from @habitathealth.com email addresses. If you feel that you have been the victim of a scam such as this, please report the incident to the Federal Trade Commission by selecting the ‘Rip-offs and Imposter Scams’ option: https://reportfraud.ftc.gov/#/ .