PowerBI Engineer

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.

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