Power BI Analyst (CMH Health)

Milliman’s CMH Health Practice is looking for a Power BI Analyst to join their vibrant, dynamic, and growing practice. Power BI Analysts will have the opportunity to work in an emerging area that supports a wide variety of markets within the healthcare industry, while working alongside some of the leading experts in the field. 

Who We Are

Independent for over 75 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the world’s most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics and business transformation.

Job responsibilities

• Develop, maintain, and manage advanced reporting, analytics, dashboards, and other BI solutions.
• Perform data analysis, and data validation.
• Work with stakeholders to identify business requirements and deliver comprehensive BI solutions.
• Ensure compliance with all Milliman required Quality Risk Management requirements.

Minimum Requirements

• Bachelor’s degree in Computer Science, Information Technology, Data Visualization or related fields.
• 2 to 4 years of related work experience.
• Proven experience with Power BI and other BI technologies. Proficiency in DAX, SQL, and Power Query is preferred, but not required.
• Strong analytical skills with the ability to organize and analyze significant amounts of information with attention to detail and accuracy.

Competencies and Behaviors that Support Success in this Role

• Adept at queries, presenting findings in interesting and convincing visuals.
• Knowledge of healthcare analytics platforms, and processing environments including Graphical User Interfaces, Batch, and APIs.
• Experience with SAS, SQL, and other programming languages a plus.
• Proven expertise using Microsoft office applications, Excel and pivot tables.
• Experience using Power Query and writing DAX.
• Familiarity with dimensional data modeling and data warehouse concepts.
• Knowledge of Microsoft Fabric, lake house architecture, ETL processes and capacity management.

The Team  

Milliman is one of the leading experts in healthcare financing and delivery. We advise clients on a wide range of issues—from assessing the impact of healthcare reform on organizations or populations to streamlining operations while advancing the quality of patient care. Our consulting work is supported by a powerful toolkit of data analytics solutions and informed by the most trusted, comprehensive set of cost guidelines in the industry.  

Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance and financial services, and property and casualty insurance. 

Location:  This role is based out of the Milliman office in our Brookfield, WI, Chicago, IL, or Hartford, CT office, but candidates hired into this role may work remotely anywhere in the US.

The expected application deadline for this job is July 30, 2025.

Salary: The salary range is $67,000 - $161,000, depending on a combination of factors, including, but not limited to, education, relevant work experience, qualifications, skills, certifications, location, etc. 

If overall experience is less than 4 years the range would be $67,000 - $131,000; for experience of greater than 4 years, the range would be $79,000 - $161,000.

Benefits

We offer a comprehensive benefits package designed to support employees’ health, financial security, and well-being. Benefits include:

• Medical, Dental and Vision – Coverage for employees, dependents, and domestic partners.
• Employee Assistance Program (EAP) – Confidential support for personal and work-related challenges.
• 401(k) Plan – Includes a company matching program and profit-sharing contributions.
• Discretionary Bonus Program – Recognizing employee contributions.
• Flexible Spending Accounts (FSA) – Pre-tax savings for dependent care, transportation, and eligible medical expenses.
• Paid Time Off (PTO) – Begins accruing on the first day of work.
• Full-time employees accrue 15 days per year.
• Employees working less than full-time accrue PTO on a prorated basis.
• Holidays – A minimum of 10 observed holidays per year.
• Family Building Benefits – Includes adoption and fertility assistance.
• Paid Parental Leave – Up to 12 weeks of paid leave for employees who meet eligibility criteria.
• Life Insurance & AD&D – 100% of premiums covered by Milliman.
• Short-Term and Long-Term Disability – Fully paid by Milliman.

#LI-CS1 #L1-REMOTE

Equal Opportunity:

All qualified applicants will receive consideration for employment, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.