Aon is looking for a Health & Benefits Assistant Vice President/Vice President - Data Warehouse Analytics

As part of an industry-leading team, you will help empower results for our clients by supporting our health solutions practice in delivering innovative and effective solutions based on Data & Analytics working out of either our Chicago, IL, Atlanta, GA offices or from a remote US-based location.

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, diverse team, and we are passionate about helping our colleagues and clients succeed.

Your impact as a Health & Benefits Assistant Vice President/Vice President - Data Warehouse Analytics

This position is part of our broader Commercial Analytics team, which falls under Aon's national Analytics and Actuarial practice. Our team of individuals excel at assessing customers' data-based needs and ensuring customers (internal and external) receive a high value return. The team is a mix of data managers, data scientists, reporting data analysts, SQL/MS Office/Tableau/PowerBI/Python/R programming experts, statisticians, actuaries, and custom solution architects. Our group delivers and supports a wide array of reporting tools, special projects, and methodology development to address the analytic needs of our data-driven clients.

What the day will look like

• Support Aon's national data warehouse team: Work with Aon clients, national Commercial Analytics team members, client team members, and Aon's data warehouse vendor partners to support clients' investments in data warehousing including supporting client implementations, data quality assurance, analytic content creation, ad hoc requests, and user support.
• Analytics Management of Aon's Health Analytics Intelligence Data Warehouse services, including:
• Legal process operations
• Manage sign-off process, execution and storage/maintenance requirements for legal agreements on a client specific and global basis
• Data analytics process
• Manage analytics content and visualizations creation, review and decision process for both platform wide and client specific needs
• Contract renewals and support
• Manage contract renewals with external team partners, collaborating with Aon procurement and other business leaders as appropriate
• Client data warehouse implementations - analytic support
• Lead specific large-scale, complex client implementations providing analytic oversight and guidance as needed
• Assist with defining data warehouse-based analytic best practices and demonstrating the value of our data warehouse platform
• Support sales and tool demonstration activities to help grow the customer base of our data warehouse solution
• Actively engage in peer review; have documents reviewed and review other colleagues' work to ensure high quality.
• Assist in coordination and creation of team process documentation.
• Ensure analytic and sales trackers and issue logs are maintained and up to date. Coordinate with vendor partners and internal partners to facilitate start to finish analytic issue resolution.

Skills and experience that will lead to success

• Minimum of 8 years (AVP) or 10 years (VP) of analytic and team management experience
• Specific knowledge and experience with health care benefits data such as Medical, Eligibility and Pharmacy claims coding including CPT, DRG, ICD10 and other industry standard classifications
• Experience with employer plan designs -- medical, pharmacy, enrollment, behavioral health, lost time, care management, population health programs, etc.
• Experience with oversight of analytic deliverables, creation and review of analytic content/visualizations; and financial reporting validation, quality control and reconciliation
• Experience implementing health data feeds and troubleshooting data quality issues
• Experience using data warehouse tools such as IBM/Truven/Merative, Cotiviti, HDMS, Artemis, Springbuk, similar vendors, or internally developed health analytics data warehouse
• Experience with analytic methodologies such as episode of care groupers, health risk scores, service categories, provider attribution and other industry standard analytic practices
• Experience building data-based reports/models/tools/processes with any mix of the following:
• MS Excel and Power Pivot, SQL/SQL Server
• Reporting template development
• Other business intelligence/data visualization tools - Tableau, Power BI

Education:

• Bachelor's degree in relevant discipline or equivalent years of industry experience

How we support our colleagues

In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two "Global Wellbeing Days" each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognize that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working!

Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.

Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.

Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.

We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email

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

The salary range for this position is $118,000 to $190,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 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.

#LI-HYBRID

#LI-REMOTE

#LI-HP1