Senior Consultant, Claims Analytics

Description Senior Consultant, 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 a Senior Consultant, Claims Analytics to support and lead advanced analytic engagements that help health plans better understand claims data, uncover cost and utilization trends, improve reimbursement accuracy, and enhance operational performance. This role will play a key leadership role within the analytics pod, particularly within the medical management and prior authorization workstream. The Senior Consultant will operate with minimal ramp-up time, drive complex analyses, mentor junior team members, and translate data into actionable insights for clients. Work You'll Do Lead day-to-day execution of claims analytics projects across payer and provider clients Design analytic approaches to evaluate utilization, cost drivers, reimbursement patterns, and operational opportunities Develop advanced SQL queries, data models, and scalable analytic workflows Analyze complex datasets including medical, pharmacy, eligibility, provider, and pricing data Validate data accuracy and ensure consistency across multiple data sources Build dashboards and reporting frameworks using BI tools to support client decision making Translate complex claims data into clear insights and recommendations for stakeholders Partner with clients to understand objectives and develop custom analyses Mentor and train junior consultants and analysts Support project planning, prioritization, and delivery across concurrent engagements Contribute to internal analytics methodologies, best practices, and frameworks Support business development through proposals, scoping discussions, and client presentations Other duties as assigned Requirements 6 to 9+ yearsof experience in healthcare analytics, payer operations, and claims analytics with a Bachelor's degree, or equivalent experience Experience working with healthcare claims data or health plan Strong experience working with healthcare claims data, including medical and pharmacy datasets Proficiency in SQL and experience analyzing large, complex datasets Experience with Snowflake, Python, Excel, and Power BI Strong understanding of reimbursement methodologies across Medicare, Medicaid, and Commercial lines of business Ability to identify trends, anomalies, utilization patterns, and cost drivers in claims data Working knowledge of healthcare coding and reimbursement structures including CPT, HCPCS, ICD, DRG, APC, and fee schedules Experience with BI tools such as Power BI, Tableau, or similar platforms Strong communication skills with ability to translate technical findings into business insights Ability to operate independently and manage complex analytical workstreams Experience mentoring or supporting junior team members Must be legally authorized to work in the United States without employer sponsorship Preferred Requirements Experience in medical management, utilization management, prior authorization, or clinical operations analytics Experience working with health plans and or consulting firms Experience designing automated analytic workflows or ETL processes Experience with SQL Server, SSIS, Python, Snowflake, or similar data environments Familiarity with healthcare data architecture and data warehousing concepts Experience building visual analytics dashboards for ongoing monitoring and reporting 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 $125,000 - $145,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