Build and maintain LENS California dashboards and required weekly/monthly reporting.
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.
Retain flexibility to scale the contractor's allocation after the initial dashboard build if reporting volume and change requests stabilize.
Requirements
Advanced SQL
LENS California dashboard development
Experience with Atrezzo, PRISM & WP2
ETL & data integration
Healthcare data analytics
Claims, eligibility & provider data
Data validation & quality assurance
Reporting & KPI development
Dashboard maintenance & optimization
Data security & documentation
Requirements gathering & stakeholder management
