PowerBI Engineer: Healthcare Analytics Dashboards & ETL

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

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.