Sr. Data Analyst, Reporting

Habitat Health empowers older adults to experience more good days in their homes and communities. Through the Program of All-Inclusive Care for the Elderly (PACE), we provide comprehensive medical care along with support for daily needs such as meals, transportation, and in ‑ home assistance. We deliver coordinated clinical and social care in our centers and directly in participants’ homes, creating a fully integrated experience that brings peace of mind and a true sense of belonging. As we expand our scalable, affordable PACE model to meet the growing and complex needs of aging populations, our mission ‑ driven care teams continue to help participants live well on their own terms.   Habitat Health is supported by leading healthcare organizations and investors including New Enterprise Associates, Kaiser Permanente, and Town Hall Ventures. We are entering a period of significant growth and are looking for exceptional teammates to help us scale a better model of care for older adults. To learn more, visit www.habitathealth.com. Role Scope :   Build scalable, fully automated, enterprise-grade reporting across Operations, Growth (Salesforce), Compliance (Epic Clarity), Health Plan (claims), Risk Adjustment (CMS and Medicaid), and Clinical Quality   Use SQL to answer ad-hoc data questions from internal customers, build report prototypes, and refactor prototypes into analytic pipelines with front-end interfaces that delight your end users   Leverage a range of reporting tools including Power BI, Epic's in-app tools (Slicer Dicer, Reporting Workbench, Radar), Salesforce reports, and Excel to support Habitat's reporting needs   Partner with engineering to design and develop ETL processes that establish clean Data Marts on top of our enterprise data warehouse, including standardized "business rules" layers that ensure consistent KPI reporting across downstream use cases   Own the quality bar for your work by designing data quality tests, leading code reviews and Git pull requests, and defining dashboard release processes / documentation standards that the rest of the team can build on   Develop detailed business and clinical logic including patient cohorts, quality measures, diagnosis groupers, utilization events (admissions, readmissions, ED visits, SNF stays), lookback periods, etc. to ensure KPIs are built, documented, and communicated properly    Build externally facing reports including PACE-specific measures, CMS / Medicaid regulatory submissions, and audit reporting in accordance with standard specifications    Set the technical bar for the reporting function by mentoring other analysts, codifying standards for SQL, reinforcing dashboard design / release processes, creating clean documentation, and raising the bar for everyone's work through close collaboration with analysts, engineers, end users, and SMEs   Qualifications:    3+ years of experience working directly with healthcare data   Highly proficient coding in SQL; experience with Git and dbt 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   Nice to have:   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 $110,000 - $132,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