Job Description

Job Title: Power BI Developer

Location: Oak Brook, IL

Contract

Position Summary:

We are seeking a skilled Power BI Developer to join our healthcare analytics team, focusing on health insurance payer operations and utilization management reporting. This role combines technical expertise in business intelligence development with healthcare industry knowledge to deliver actionable insights that drive operational efficiency and member outcomes.

Key Responsibilities

• Scope, design, develop, and maintain Power BI dashboards, reports, and data models for Innovista Health’s payer operations
• Create interactive visualizations for utilization management metrics, claims analytics, and operational KPIs
• Build and optimize calculations, measures, and calculated columns for healthcare and operational metrics
• Develop automated ETL processes using T-SQL stored procedures
• Optimize report performance and ensure scalability across large datasets
• Collaborate with business and application teams to modify, enhance, and optimize existing PBI assets
• Maintain version control and documentation for all PBI assets
• Document PBI assets, owners, data sources
• Create and maintain wikis documenting the purpose, audience, and companion information for PBI asset

Qualifications

Required Qualifications

• Power BI Development: 2-4 years building dashboards, reports (stand alone and paginated), and data models.
• SQL Server: Advanced proficiency in T-SQL, stored procedures, views, joins, temp tables, and query optimization
• Power Query: Data transformation and ETL development
• SQL Server Agent: Job scheduling, maintenance plans, and automated workflows
• ETL: Experience with ETL and reporting tools like SSIS, SQL Server Import and Export Wizard, or similar technologies
• Experience in Python, Ruby, or PowerShell for scripting and automation tasks.

Preferred Qualifications

• Payer Operations: Knowledge of claims processing and claim concepts, provider and vendor data, staff productivity metrics
• Utilization Management: Familiarity with authorizations concepts
• Healthcare Data: General familiarity with healthcare claim concepts such as claims, enrollment, utilization, provider network data

Technical Competencies

• Extensive Microsoft PowerBI experience, including deployment, access management, and health monitoring
• Knowledge of star schema design and dimensional modeling
• Performance optimization for healthcare datasets
• Data governance and HIPAA-compliant user access best practice
• Version control and publication / deployment processes in PowerBI
• Integration between multiple analytical and application SQL Server databases and Power BI ecosystem

Additional Information

All your information will be kept confidential according to EEO guidelines.