Consultant, Claims Analytics

Summary

AArete is a global, innovative management and technology consulting firm known for its culture of care and employee development. The Consultant, Claims Analytics role involves supporting analytic engagements to help health plans understand claims data, identify trends, and enhance operational performance.

Responsibilities

• Support claims analytics projects across payer and provider clients
• Execute SQL queries and analyses on large healthcare datasets
• Work with medical, pharmacy, eligibility, provider, and pricing data
• Assist in identifying utilization patterns, cost drivers, and reimbursement trends
• Validate data accuracy and support quality assurance processes
• Build dashboards and reports using BI tools to support client insights
• Translate analytical findings into clear summaries and presentations
• Collaborate with Senior Consultants and Managers on project execution
• Support documentation of methodologies and analytic approaches
• Participate in client discussions and internal working sessions
• Other duties as assigned

Skills

• 2 to 5+ years of experience in healthcare analytics, claims analytics, actuarial analysis, or payer/provider operations with a Bachelor's degree, or equivalent experience
• Experience working with healthcare claims data or health plan datasets
• Proficiency in SQL and experience analyzing large datasets
• Experience with Snowflake, Python, Excel, or similar analytics tools
• Familiarity with BI tools such as Power BI or Tableau
• Basic understanding of healthcare reimbursement concepts and claims data structures
• Strong analytical and problem-solving skills
• Ability to communicate technical findings in a clear and structured way
• Ability to work collaboratively in a team-based environment
• Must be legally authorized to work in the United States without employer sponsorship
• Exposure to medical management, utilization management, prior authorization, or clinical operations
• Experience working with health plans or consulting firms
• Experience with automated analytic workflows or ETL processes
• Familiarity with healthcare coding systems including CPT, HCPCS, ICD, DRG, and APC
• Experience building dashboards or recurring analytics reports
• Based in Chicago, IL, with flexibility to work from the Chicago office as needed

Qualifications

Must Haves

• 2 to 5+ years of experience in healthcare analytics, claims analytics, actuarial analysis, or payer/provider operations with a Bachelor's degree, or equivalent experience
• Experience working with healthcare claims data or health plan datasets
• Proficiency in SQL and experience analyzing large datasets
• Experience with Snowflake, Python, Excel, or similar analytics tools
• Familiarity with BI tools such as Power BI or Tableau
• Basic understanding of healthcare reimbursement concepts and claims data structures
• Strong analytical and problem-solving skills
• Ability to communicate technical findings in a clear and structured way
• Ability to work collaboratively in a team-based environment
• Must be legally authorized to work in the United States without employer sponsorship

Nice to Haves

• Exposure to medical management, utilization management, prior authorization, or clinical operations
• Experience working with health plans or consulting firms
• Experience with automated analytic workflows or ETL processes
• Familiarity with healthcare coding systems including CPT, HCPCS, ICD, DRG, and APC
• Experience building dashboards or recurring analytics reports
• Based in Chicago, IL, with flexibility to work from the Chicago office as needed

Benefits

• Flexible PTO, monthly half-day refuels, volunteer time off, 10 paid holidays
• Own Your Day flexible work policy
• Competitive majority employer-paid benefits: Medical, Dental, Vision, 401K Match
• Generous paid parental leave options
• Employer-paid Life Insurance, Short Term Disability, Long Term Disability
• Charitable contribution matching program
• New client commission opportunities and referral bonus program
• Bike share discount program