Sr. Data Analyst, Reporting

Job Description

Job Description

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

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 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 View email address on ziprecruiter.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:

Vaccination Policy, including COVID-19

To help maintain a safe environment for our participants and team members, Habitat Health maintains vaccination and infection control policies applicable to certain roles and work locations. For COVID-19 and influenza, team members who are working in a participant care setting are required to provide either proof of vaccination or a signed declination form and comply with applicable masking requirements while in a care setting to the extent permitted by law in the applicable jurisdiction.

Habitat Health will consider requests for reasonable accommodation based on an applicant's disability, medical condition, or sincerely held religious belief, practice, or observance in accordance with applicable law.

As a condition of employment, team members are expected to comply with all applicable infection control protocols, personal protective equipment (PPE) requirements, and vaccination requirements associated with their role and work location, and to the extent required by law and as permitted in the applicable jurisdiction.

Our Commitment to Equal Opportunity and Inclusion

Habitat Health is an Equal Opportunity Employer committed to the principles of equal opportunity and inclusion. Employment decisions at Habitat Health are based on qualifications, merit, and business needs. We do not discriminate on the basis of race, color, religion, creed, sex, gender (including pregnancy, childbirth, breastfeeding, and related medical conditions), gender identity, gender expression, sexual orientation, marital status, registered domestic partner status, age, national origin, ancestry, citizenship, military or veteran status, physical or mental disability, medical condition, genetic information, reproductive health decision-making, or any other characteristic protected by applicable federal, state, or local law.

Habitat Health is committed to the full inclusion of all qualified individuals. Consistent with applicable law, we provide reasonable accommodations to qualified individuals with disabilities and to individuals with religious beliefs, practices, or observances that require accommodation.

If you require a reasonable accommodation to participate in the application or interview process, perform the essential functions of a position, or receive other employment benefits and privileges, please contact us at View email address on ziprecruiter.com.

We encourage individuals from all backgrounds to apply, even if their experience does not align perfectly with every qualification listed.

E-Verify Participation Notice

Habitat Health participates in E-Verify and will provide the federal government with information from your Form I-9 to confirm your authorization to work in the United States.

If E-Verify cannot confirm your authorization to work, Habitat Health will provide you with written instructions and an opportunity to contact the Department of Homeland Security (DHS) and/or the Social Security Administration (SSA) to resolve the issue before any adverse employment action is taken, including termination of employment.

E-Verify is used only after an applicant has accepted an offer of employment and completed the Form I-9 and to the extent permitted by applicable law.

Habitat Health complies with all federal and state employment eligibility verification requirements.

Beware of Scams and Fraud

Habitat Health is committed to protecting job seekers from recruitment scams. Please ensure that you submit applications only through Habitat Health's official careers website or authorized job boards.

Official communications from Habitat Health recruiters and team members will come from email addresses ending in @habitathealth.com. Habitat Health will never ask applicants to pay fees, purchase equipment, or provide sensitive financial information as part of the recruiting or hiring process.

If you receive suspicious communications claiming to represent Habitat Health, we encourage you to exercise caution and independently verify the communication before responding.

If you believe you have been the victim of a recruitment scam or fraudulent job posting, please report the incident to the Federal Trade Commission (FTC) through its fraud reporting website at reportfraud.ftc.gov.