Health Analytics Senior Consultant / Senior Data Analyst

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,