Job Title: Power BI Developer
Location: Oak Brook IL
Type: Contract
Job Description: 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 Healths 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
- Optimise 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
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 authorisation concepts
- Healthcare Data: General familiarity with healthcare claim concepts such as
- claims enrollment utilisation provider network data
Technical Competencies
- Extensive Microsoft Power BI experience including deployment access
- management and health monitoring
- Knowledge of star schema design and dimensional modelling
- Performance optimization for healthcare datasets
- Data governance and HIPAA-compliant user access best practices
- Version control and publication/deployment processes in Power BI
- Integration between multiple analytical and application SQL Server databases and Power BI ecosystems