Heritage Health Network is a mission-driven organization transforming care for high-need populations, and they are seeking a Senior Business Analyst to influence strategy through data-driven decision-making. In this role, you will design and optimize Power BI dashboards, support revenue cycle management reporting, and collaborate with executive leadership to define key performance indicators and insights.
Responsibilities:
- Design, build, and maintain Power BI dashboards across enrollment, revenue cycle, clinical operations, and performance metrics
- Write and optimize SQL queries to extract, validate, and transform data from AWS RDS (PostgreSQL/MySQL)
- Develop reporting for revenue cycle management (RCM) including claims, denials, A/R, and payer performance
- Build enrollment and attribution dashboards, tracking growth, churn, and member trends
- Create and maintain incentive and compensation dashboards tied to KPI performance
- Partner with executive leadership, finance, operations, and clinical teams to define reporting needs and business insights
- Develop data models, DAX measures, and row-level security to ensure accurate and secure reporting
- Identify data gaps and recommend process improvements to enhance reporting quality and reliability
Requirements:
- 4+ years of experience in business analysis, data analytics, or BI reporting (healthcare preferred)
- Advanced expertise in Power BI (data modeling, DAX, Power Query, dashboard design)
- Strong SQL skills and experience working with cloud databases (AWS RDS preferred)
- Knowledge of Revenue Cycle Management (RCM) including claims, billing, denials, and payer data
- Experience building performance or incentive-based reporting models
- Ability to translate complex data into clear, actionable insights for executive audiences
- Strong analytical, problem-solving, and cross-functional collaboration skills
- Experience with eClinicalWorks (eCW) or healthcare EHR systems
- Familiarity with Medi-Cal, CalAIM, or ECM programs
- Experience with AWS services (RDS, S3, Redshift)
- Background in healthcare analytics or population health