PowerBI Engineer
Core
Build and maintain LENS California dashboards and weekly/monthly reporting by combining Atrezzo activity/outcomes with claims, eligibility, provider, PRISM, and WP2 data.
Role type
PowerBI Engineer (Healthcare Analytics)
Builds
LENS California dashboards and operational reports for DHCS and Gainwell
Domain
Healthcare data analytics (Claims, eligibility, provider data)
Deliverable
dashboards & analysis
Required skills
Advanced SQL, ETL & data integration, Data validation & quality assurance, Reporting & KPI development, Dashboard maintenance & optimization, Data security & documentation
Preferred skills
Experience with Atrezzo, PRISM & WP2, Healthcare data analytics
Technologies
PowerBI, SQL, Atrezzo, PRISM, WP2
Responsibilities
Combine Atrezzo activity and outcomes with claims, eligibility, provider, PRISM, and WP2 data; Report on outreach attempts, member contact, FFS provider connections, provider availability gaps, scheduled appointments, completed follow-up appointments, and members remaining in the outreach cycle; Refine dashboards as DHCS and Gainwell finalize reporting requirements and operational definitions; Maintain refreshes, validation, security, usability, documentation, and consistent metric definitions through the stabilization period.