Power BI & Insights Lead

4062 Aetna Resources, LLC

Illinois

On-site

USD 66,000 - 146,000

Full time

14 days+

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, dental, vision coverage

Retirement savings options

Paid time off

Job summary

CVS Health is seeking an experienced Contact Center Reporting and Insights Analyst to ensure reliable performance reporting, monitor data quality, investigate variances, and provide timely, actionable insights to leaders. You will develop and optimize Power BI dashboards and data models, coordinate with Workforce Management and Technology/DBA, and lead data reconciliation across multiple sources.

This role requires strong SQL/ETL skills, data storytelling, and clear communication with both

Qualifications

Advanced Power BI expertise, including dashboard and report development, data modeling, DAX calculations, visualization best practices, report performance optimization, and translating business requirements into actionable reporting solutions.
Experience with ETL and reporting infrastructure, including SQL Agent jobs and SSIS, along with hands-on experience working in Google Cloud Platform (GCP) data environments.
Strong SQL skills with SQL Server Management Studio (SSMS) and Microsoft Analysis Services experience, including ad hoc queries for investigation and support and the ability to validate data and reconcile across sources.
Demonstrated experience in reporting, analytics, business operations, or production data support in a high-volume environment.
Proven ability to perform reconciliation, troubleshoot data issues, and maintain high standards for data integrity.
Ability to communicate clearly with both technical and non-technical partners, with strong follow-through in a support workflow.
Comfort supporting occasional off-hours or weekend work for scheduled releases and upgrades.

Responsibilities

Produce and maintain recurring contact center performance reporting (daily, weekly, and monthly) with strong data quality and clear storytelling.
Develop, maintain, and optimize Power BI dashboards, reports, and data models that provide operational leaders with timely, actionable insights and consistent performance measurement across the contact center.
Perform frequent data integrity testing and reconciliation; investigate variances and drive root-cause troubleshooting to resolution.
Monitor trends and anomalies, such as volume shifts, service-level risk, and handle-time movement, and translate them into concise insights and recommended actions.
Support performance routines, including scorecards and operating cadences, by ensuring metrics are consistent, definitions are documented, and reporting is reliable.
Ensure reporting accuracy and stability for metrics that feed incentive programs by executing frequent validation and reconciliation checks.
Execute and/or coordinate recovery steps for data-load failures and other reporting disruptions to restore accurate reporting quickly.
Partner with Technology/DBA teams on reporting infrastructure and pipeline support, including job monitoring and issue triage.
Provide end-user support and training for reporting access and usage; resolve support cases through closure.
Support strategic initiatives, including gamification, using game‑like mechanics to motivate and reinforce goal performance, progress tracking, and recognition.