Health Analytics Senior Consultant / Senior Data Analyst

Aon plc; Denver (CO); Hybrid; USD 110,000 - 135,000; Full time

Benefits offered by this job

401(k) matching

Medical, dental and vision insurance

Paid holidays and vacation

Job summary

Aon plc is seeking a Health Analytics Senior Consultant / Senior Data Analyst to work in a hybrid capacity across Chicago, IL, Atlanta, GA, or Denver, CO with possible remote options for qualified candidates. You will analyze healthcare data, develop dashboards, and drive audit analytics across medical, pharmacy, dental, and vision claims.

Ideal candidates have 3–7 years of healthcare data experience, strong SQL/Excel, and familiarity with BI tools; Python/Databricks and cloud skills are a plus.

Qualifications

• Three to seven years of hands-on experience with healthcare data across medical, pharmacy, dental or vision claims, including identifying payment errors and eligibility issues.
• Working knowledge of claims coding and adjudication (CPT/HCPCS, ICD-10, revenue codes, modifiers, NDCs) for pharmacy.
• Proficiency in SQL and Excel; working knowledge of BI tools such as Power BI or Tableau; Python/Databricks a plus.
• Experience streaming or automating analytics and reporting tasks to improve consistency and efficiency.

Responsibilities

• Analyze large and complex healthcare datasets across medical, pharmacy, dental and vision claims and eligibility data.
• Lead and support healthcare claims audits and analytical reviews, identifying errors and trends.
• Develop analytics findings, recurring reports, dashboards, and data visualizations using SQL, Excel, Power BI or Tableau.
• Streamline analytics and reporting tasks using Excel macros, templates, or workflow tools to improve efficiency.
• Apply AI tools responsibly to build, maintain, and validate audit and analytics workflows.
• Collaborate with Analytics, Engineering, Business and Actuarial teams to define requirements and deliver solutions.
• Document data sources, rules, methodologies, findings, and QC procedures for repeatable analyses.

Skills

SQL

Excel

Power BI

Tableau

Python

Databricks

Cloud experience

Data analysis

Education

Bachelor's degree in analytics or related field

Tools

Power BI

Tableau

SQL

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.

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.