Healthcare Data Analyst (CMH Health)

Milliman's health IT consulting group is looking for a driven, entrepreneurial, and self-learning data analyst to join their team. The ideal candidate will be passionate about providing the best healthcare consulting services to our clients while making meaningful contributions to projects and the firm.  Our analysts are independent problem solvers who care about the quality of the work that is delivered to clients and to each other.

Who We Are 

Independent for 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

• Import and interpret source data
• Scrub, clean and validate data
• Prepare input files for 3rd party data processing
• Analyze the data results and making changes if needed, before presenting the data to project managers and internal consultants
• Perform ad hoc T-SQL programming and analysis
• Build ETL processes for client projects
• Develop custom reports using modern reporting tools
• Review of peers work product to validate quality results
• Responsible for 3-4 projects at a time, spending roughly 60% of day working within SQL/T-SQL and 40% of the day on other information technology related tasks

Minimum requirements

• Bachelor’s degree required (Computer Science, Management Information Systems, Computer Engineering, Data Analytics, Math, or related degree is preferred)
• Basic proficiency in Transact SQL, Python and R or PowerBI
• Able to interpret, scrub, process, and explain data
• Proficiency with Microsoft Office Suite, especially Excel

Competencies and Behaviors that Support Success in this Role

• Proficiency in database architecture, healthcare claims data, and information technology
• Strong IT background
• Analytical thinker, able to assess problems logically
• Strong communication skills and experience working with a team
• Detailed and organized
• Fast learner
• Passionate about providing the best healthcare consulting services to our clients
• Results oriented leader that thrives on delivering high quality products and services to our end users
• Determined to solve challenging technical problems with an eye towards quality results
• Take personal responsibility for their work and are motivated to succeed

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: The person hired for this role will work in a dynamic, hybrid environment, with 3 days per week of on-site work required in our Brookfield, WI office on a weekly basis.

#LI-CS1 #hybrid

 Benefits: 

At Milliman, we focus on creating an environment that recognizes – and meets – the personal and professional needs of the individual and their family. We offer competitive benefits which include the following based on plan eligibility:

• Medical, dental and vision coverage for employees and their dependents, including domestic partners
• A 401(k) plan with matching program, and profit-sharing contribution
• Employee Assistance Program (EAP)
• A discretionary bonus program
• Paid Time Off (PTO) starts accruing on the first day of work and can be used for any reason; full-time employees will accrue 15 days of PTO per year, and employees working less than a full-time schedule will accrue PTO at a prorated amount based on hours worked
• Family building benefits, including adoption and fertility assistance and paid parental leave up to 12 weeks for employees who have worked for Milliman for at least 12 months and have worked at least 1,250 hours in the preceding 12-month period
• A minimum of 8 paid holidays
• Milliman covers 100% of the premiums for life insurance, AD&D, and both short-term and long-term disabilit