Similar Jobs
Information Technology
The role involves developing security solutions, providing consultative guidance, collaborating on sales strategy, and mentoring others as a trusted advisor for Hybrid Infrastructure services.
Top Skills:
ArchitectureHybrid InfrastructureSecurity SolutionsTechnical Pre-Sales
Information Technology
The Senior Project Manager at CDW will oversee cloud consulting projects, manage budgets, timelines, and customer relationships, and ensure successful project delivery.
Top Skills:
AgileAmazon Web Services (Aws)Itil PracticesScrumWaterfall
Information Technology
The Principal Enterprise Solutions Executive leads the sales process, shaping complex service solutions and collaborating with stakeholders to drive technology-enabled transformations for enterprise clients.
Top Skills:
It TransformationManaged ServicesProfessional Services
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
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
All your information will be kept confidential according to EEO guidelines.
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
