PowerBI Engineer

ProArch; Kentucky; On-site; USD 90,000 - 120,000; Full time

Job summary

ProArch is building and maintaining LENS California dashboards and delivering required weekly and monthly reporting.

Responsibilities include combining Atrezzo activity and outcomes with claims, eligibility, provider, PRISM and WP2 data, and reporting on outreach attempts, appointments, and follow-ups.

Maintain data validation, security, documentation, and KPI definitions; refine dashboards as DHCS and Gainwell finalize requirements; scale allocations as volume stabilizes.

Qualifications

• Advanced SQL proficiency for data modeling and reporting.
• ETL and data integration experience to consolidate sources.
• Healthcare data analytics focused on outcomes and program reporting.
• Data validation processes to ensure accuracy and integrity.
• Quality assurance of dashboards and datasets before release.
• Reporting and KPI development to meet program goals.
• Dashboard maintenance and optimization over time.
• Data security practices and documentation to support governance.
• Stakeholder management to align reports with business needs.

Responsibilities

• Build and maintain LENS California dashboards and weekly/monthly reporting.
• Combine Atrezzo activity with claims, eligibility, provider, PRISM and WP2 data.
• Report on outreach attempts, member contact, and follow-up appointments.
• Refine dashboards as DHCS and Gainwell finalize requirements and definitions.
• Maintain refreshes, validation, security, usability, and documentation during stabilization.
• Scale contractor’s allocation if reporting volume and changes stabilize.

Skills

Advanced SQL

ETL & data integration

Healthcare data analytics

Data validation

Quality assurance

Reporting & KPI development

Dashboard maintenance

Data security

Documentation

Stakeholder management

Tools

Atrezzo

PRISM

WP2

Job description

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