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