About the role
structured by ORIBuild and maintain LENS California dashboards and required weekly/monthly reporting. Combine Atrezzo activity and outcomes with claims, eligibility, provider, PRISM, and WP2 data.
What you will do
- 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.
What they are looking for
- 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
Full posting text
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