Aon · 2 weeks ago
Health Solutions Assistant Vice President - Data Warehouse Analytics
Chicago, IL
Full-time
Hybrid
Senior Level, Lead/Staff
$115K/yr - $175K/yr
8+ years expAon Corporation is seeking a Health Solutions Assistant Vice President - Data Warehouse Analytics to empower results for clients by delivering innovative solutions based on Data & Analytics. The role involves supporting the national data warehouse team, managing analytics content, and leading complex client implementations.
ConsultingProfessional ServicesRisk Management
Responsibilities
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
Qualification
Required
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, 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
Bachelor's degree in relevant discipline or equivalent years of industry experience
Benefits
401(k) savings plan with employer contributions
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
Employee assistance program that includes free counseling sessions
Company
Aon
Aon is a global provider of risk management, insurance and reinsurance brokerage, human resources solutions, and outsourcing services.
10001+ employees
H1B Sponsorship
Aon has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (9)
2024 (19)
2023 (13)
2022 (1)
2021 (21)
2020 (6)
Funding
Current Stage
Public CompanyTotal Funding
$1.94BKey Investors
Citibank NABerkshire Hathaway
2023-10-24Post Ipo Debt· $1B
2021-05-17Post Ipo Equity· $942.6M
1987-01-01IPO
Leadership Team
Alejandro Galizia
CEO Latin America, AON
Andy Marcell
CEO Global Solutions
Recent News
Yahoo Finance
2026-01-05
Life Insurance International
2026-01-05
Company data provided by crunchbase