Health Solutions Assistant Vice President - Data Warehouse Analytics Job at Aon

Health Solutions Assistant Vice President – Data Warehouse Analytics

Join to apply for the Health Solutions Assistant Vice President – Data Warehouse Analytics role at Aon. 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.

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 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 visualisations 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 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 & Experience That Will Lead To Success

• Minimum of 8 years 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, behavioural health, lost time, care management, population health programs, etc.
• Experience with oversight of analytic deliverables, creation and review of analytic content/visualisations; 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, or other business‑intelligence/data visualisation tools – Tableau, Power BI.

Education

• Bachelor’s degree in a relevant discipline or equivalent years of industry experience.

How We Support Our Colleagues

In addition to our comprehensive benefits package, we encourage an inclusive workforce. Our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. All colleagues enjoy two “Global Wellbeing Days” each year, encouraging focus on yourself. We offer a variety of working‑style solutions and a continuous‑learning culture that helps you achieve your fullest potential. Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves.

Equal Employment Opportunity

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. People with criminal histories are encouraged to apply. We are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know at ReasonableAccommodations@Aon.com or your recruiter.

Pay Transparency

The salary range for this position (intended for U.S. applicants) is $115,000 to $175,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 for an annual discretionary bonus.

Benefits Summary

Aon offers a comprehensive package of benefits for full‑time and regular part‑time colleagues, including a 401(k) plan, employee stock purchase plan, long‑term incentive awards, medical, dental and vision insurance, various leaves of absence, paid time off (12 paid holidays, 15 days of paid vacation per year, paid sick leave), short‑term and optional long‑term disability, health savings account, dependent care reimbursement, life insurance, supplemental life and AD&D insurance, optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program with free counseling.

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Analyst and Consulting

Job ID

2570393