Health Analytics Senior Consultant​/Senior Data Analyst

This position is preferred to be hybrid in the following or any Aon location:
Chicago, IL
- Atlanta, GA
- Denver, CO. Remote work may be considered for highly qualified candidates

The Health Analytics Senior Consultant / Senior Data Analyst will work closely with healthcare data-including medical, pharmacy, dental and vision claims, benefits, and eligibility-to support analytics and audit activities. This role will translate complex data into meaningful insights, develop reporting and dashboard capabilities, and partner across Analytics, Engineering, Business, and Actuarial teams to deliver accurate, efficient, and scalable solutions.

Aon is in the business of better decisions

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.

As an organization, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed.

• Analyze large and complex healthcare datasets, including medical, pharmacy, dental and vision claims, eligibility, benefits, membership, and related data.
• Lead and support healthcare claims audits and analytical reviews across medical, pharmacy, dental, and vision claims, including identification of payment errors, benefit misapplication, eligibility issues, anomalies, and trends.
• Develop clear analytics findings, recurring reports, dashboards, and data visualizations using tools such as SQL, Excel, Power BI, or Tableau.
• Streamline and automate routine analytics, audit and reporting tasks using Excel macros, templates, workflow tools, agentic AI, and other technologies to improve consistency, efficiency, and quality.
• Apply current AI tools responsibly to help build, maintain, document, and quality-check audit and analytics workflows, with appropriate validation and human oversight.
• Partner with Analytics, Engineering, Business, and Actuarial teams to define requirements, align analytical methods, and deliver solutions that meet business and client needs.
• Collaborate with healthcare carriers, payors, vendors, and internal stakeholders to resolve data questions and support analytics & audit activities.
• Document data sources, business rules, assumptions, methodologies, findings, and quality-control procedures to promote consistent and repeatable analyses.
• Identify opportunities to improve processes, automate routine work, and increase the efficiency, accuracy, and productivity of analytics and reporting.
• Communicate technical findings to both technical and nontechnical audiences through concise written materials, presentations, and discussions.
• Manage multiple work streams and priorities while delivering timely, accurate, and high-quality results.

• Three to seven years of hands-on experience working closely with healthcare data across medical, pharmacy, dental or vision claims, including identifying payment errors, benefit misapplication, and eligibility issues.
• Working knowledge of claims coding and adjudication, including CPT/HCPCS, ICD-10, revenue codes, modifiers, and NDCs for pharmacy, and an understanding of how plan benefits drive claim payment.
• Proficiency in SQL and Excel, and working knowledge of business intelligence tools such as Power BI or Tableau to review, interpret, and communicate claims data. Python, Databricks, and cloud experience are a plus.
• Experience streamlining or automating routine analytics and reporting tasks-for example, with Excel macros, SQL, templates, workflow tools, or similar approaches-to improve consistency and efficiency.
• Ability to leverage agentic AI and other current AI tools responsibly to build, maintain, document, or improve audit and analytics workflows; experience validating AI-assisted outputs is a plus.
• Strong analytical and investigative skills, including assessing data quality, reconciling results, identifying patterns, selecting claims for review, and explaining findings.
• Knowledge and understanding of healthcare claims administration, cost management activities, provider billing, benefit coding, and claim coding practices.
• Experience with claims payment integrity (CPI) or fraud, waste, and abuse (FWA) functions at a major health carrier or with a CPI/FWA firm is preferred.
• Strong collaboration, written and verbal communication, and stakeholder-management skills, with the ability to present complex information clearly to technical and nontechnical…