Sql Python Excel Power Bi Tableau Jobs in Lisle, IL

Analyst, Claims Analytics

AArete is one-of-a-kind when it comes to consulting firm culture.

We're a global, innovative management and technology consulting firm with offices in the U.S., India, and Europe. Our name comes from the Greek word for excellence: "Arete." And excellence is exactly what we strive for.

We're celebrating our fourth year as one of Forbes' World's Best Management Consulting Firms - and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete's "Culture of Care" takes a holistic approach to the employee experience.

AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment.

The Role

We are seeking an Analyst, Claims Analytics to support analytic engagements that help health plans better understand claims data, identify cost and utilization trends, improve reimbursement accuracy, and enhance operational performance.

This role will support the analytics pod, with a focus on medical management and prior authorization use cases. The Analyst will work closely with Consultants and Senior Consultants to execute analyses, develop data-driven insights, and contribute to client deliverables.

Work You'll Do

• Support claims analytics projects across payer and provider clients
• Execute SQL, python scripts and analyses on large healthcare datasets
• Run Statistical analyses to support data profiling and other related analyes
• 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 Consultants and Senior Consultants on project execution
• Support documentation of methodologies and analytic approaches
• Participate in client discussions and internal working sessions
• Other duties as assigned

Requirements

• Bachelor's degree required
• 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

Preferred Requirements

• 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

Compensation & 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

The estimated base salary range for this position is $82,000 - $97,000. In addition to this base salary, individuals may be eligible for an annual discretionary bonus. This range is a part of a competitive, total compensation package together with our majority employer-paid benefits and incentive pay for eligible roles. Please note that this range is a guideline, and individual total compensation may vary due to numerous factors, including but not limited to experience level, certifications, and other relevant business considerations.

AArete will accept applications until the position is filled. The job posting will be removed once the role is no longer available.

We put humans at the center of our work

We're a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results.

But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.

And we've been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.

We've earned a Great Place to Work Certification and been named a World's Best Management Consulting Firm by Forbes, Vault's Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000's Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms.

Learn more about our award-winning culture

We are an Equal Employment Opportunity Employer

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.

#LI-DNI