Health Analytics Senior Consultant / Senior Data Analyst

Aon; Chicago (IL); Hybrid; USD 110,000 - 135,000; Full time

Benefits offered by this job

401(k) plan

Employee stock purchase plan

Health, dental, vision insurance

Paid holidays and vacation

Job summary

Aon is seeking a Health Analytics Senior Consultant / Senior Data Analyst in a role that blends analysis, auditing, and reporting across medical, pharmacy, dental, and vision data. You will translate complex datasets into actionable insights, build dashboards, and partner with Analytics, Engineering, Business, and Actuarial teams to deliver scalable solutions.

The position emphasizes collaboration, data quality, and responsible use of AI tools, with a hybrid work model in select locations.

Qualifications

• Experience with healthcare data and claims analysis, including eligibility issues and payments.
• Proficiency in SQL and BI tools to review and communicate data findings.
• Knowledge of CPT/HCPCS, ICD-10, revenue codes, NDCs is a plus.
• Experience automating analytics and reporting tasks using macros or templates.

Responsibilities

• Analyze large healthcare datasets across medical, pharmacy, dental, and vision claims.
• Lead and support healthcare claims audits and analytical reviews for errors and anomalies.
• Develop reports and dashboards with SQL, Excel, Power BI, or Tableau.
• Automate routine analytics tasks to improve efficiency and quality.
• Validate AI-assisted outputs and maintain documentation of methodologies.

Skills

Analytical storytelling

Stakeholder communication

Data quality assessment

Problem solving

Cross-functional collaboration

Healthcare data familiarity

Education

Bachelor’s degree in analytics, data science, computer science, information systems, statistics, mathematics, actuarial science, public health or related field

Tools

SQL

Power BI

Tableau

Excel

Databricks

Job description

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.

What the day will look like

• 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 workstreams and priorities while delivering timely, accurate, and high-quality results.

Skills and experience that will lead to success

• 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 audiences.
• Ability to work independently, exercise sound judgment, manage competing priorities, and maintain close attention to detail.

Data Science - Advanced; Data Visualization - Advanced; Predictive Modeling - Advanced; Statistical Analysis - Advanced; Advanced Analytics - Experienced; Structured Query Language (SQL) - Advanced; Data Analysis - Advanced; Data Integration - Advanced; Data Modeling - Advanced; Data Management - Advanced; Data Mining - Advanced

Education

Bachelor’s degree in analytics, data science, computer science, information systems, statistics, mathematics, actuarial science, public health, healthcare administration, economics, finance, or a related field, or equivalent relevant professional experience.

For positions in San Francisco and Los Angeles, we will consider for employment qualified applicants with arrest and conviction record in accordance with local Fair Chance ordinances.

Aon is not accepting unsolicited resumes from search firms for this position. If you are a search firm, you will not be compensated in any way for your submission of a candidate, even if Aon hires that candidate.

Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.

Pay Transparency Laws:

The salary range for this position (intended for U.S. applicants) is $110,000 to $135,000 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant’s geographic location.This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual discretionary bonus in addition to base salary. The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan.

A summary of all the benefits offered for this position:

Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an employee stock purchase plan; consideration for long-term incentive awards at Aon’s discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, short-term disability and optional long-term disability, health savings account, health care and dependent care reimbursement accounts, employee and dependent life insurance and supplemental life and AD&D insurance; optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies.