Aon
Health Solutions Assistant Vice President - Data Warehouse Analytics
Aon, Atlanta, Georgia, United States, 30383
Health Solutions Assistant Vice President - Data Warehouse Analytics
We are looking for a Health Solutions Assistant Vice President – Data Warehouse Analytics to support our health solutions practice in delivering innovative and effective solutions based on data and analytics. The position is located in our Chicago, IL or Atlanta, GA offices, or remote U.S. based location.
What The Day Will Look Like
Support Aon’s national data warehouse team: work with clients, team members, and vendor partners to support data warehousing investments, 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, managing sign‑off process, execution, and storage/maintenance requirements for legal agreements; data analytics process, managing analytics content and visualizations creation, review and decision process for both platform‑wide and client‑specific needs; contract renewals and support.
Client data warehouse implementations – lead large‑scale, complex client implementations, provide analytic oversight and guidance; define data‑warehouse‑based analytic best practices and demonstrate the value of our platform.
Support sales and tool demonstration activities to grow our customer base.
Engage in peer reviews, coordinate and create team process documentation, maintain analytic and sales trackers, issue logs, and coordinate with vendor and internal partners to resolve analytic issues.
Skills And Experience That Will Lead To Success
Minimum of 8 years of analytic and team‑management experience.
Knowledge of health‑care benefits data such as Medical, Eligibility, and Pharmacy claims coding, including CPT, DRG, ICD‑10, and other industry classifications.
Experience with employer plan designs – medical, pharmacy, enrollment, behavioral health, lost time, care management, population health programs, etc.
Experience overseeing analytic deliverables, creation and review of analytics content/visualizations, as well as 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, 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.
Ability to build data‑based reports, models, tools, and processes using MS Excel and Power Pivot, SQL/SQL Server, reporting template development, and other BI/data visualization 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 a comprehensive benefits package, we encourage an inclusive workforce. Our agile environment allows you to manage your wellbeing and work/life balance. All colleagues enjoy two “Global Wellbeing Days” each year, and we offer a variety of working‑style solutions. We also provide learning opportunities to help you grow.
Aon Values Aon is proud to be an equal‑opportunity workplace. We provide 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. If you require accommodations during the application or interview process, please email ReasonableAccommodations@Aon.com.
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 education, experience, skills, and abilities, as well as internal equity and market data. This position is eligible to participate in an annual incentive plan to receive a discretionary bonus.
Benefits Summary Aon offers a comprehensive package of benefits for full‑time and regular part‑time colleagues, including a 401(k) plan with employer contributions; an employee stock purchase plan; medical, dental and vision insurance; paid time off; short‑term disability; health savings account; life insurance; optional personal insurance; adoption assistance; tuition assistance; commuter benefits; and an employee assistance program with counseling sessions.
#J-18808-Ljbffr
What The Day Will Look Like
Support Aon’s national data warehouse team: work with clients, team members, and vendor partners to support data warehousing investments, 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, managing sign‑off process, execution, and storage/maintenance requirements for legal agreements; data analytics process, managing analytics content and visualizations creation, review and decision process for both platform‑wide and client‑specific needs; contract renewals and support.
Client data warehouse implementations – lead large‑scale, complex client implementations, provide analytic oversight and guidance; define data‑warehouse‑based analytic best practices and demonstrate the value of our platform.
Support sales and tool demonstration activities to grow our customer base.
Engage in peer reviews, coordinate and create team process documentation, maintain analytic and sales trackers, issue logs, and coordinate with vendor and internal partners to resolve analytic issues.
Skills And Experience That Will Lead To Success
Minimum of 8 years of analytic and team‑management experience.
Knowledge of health‑care benefits data such as Medical, Eligibility, and Pharmacy claims coding, including CPT, DRG, ICD‑10, and other industry classifications.
Experience with employer plan designs – medical, pharmacy, enrollment, behavioral health, lost time, care management, population health programs, etc.
Experience overseeing analytic deliverables, creation and review of analytics content/visualizations, as well as 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, 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.
Ability to build data‑based reports, models, tools, and processes using MS Excel and Power Pivot, SQL/SQL Server, reporting template development, and other BI/data visualization 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 a comprehensive benefits package, we encourage an inclusive workforce. Our agile environment allows you to manage your wellbeing and work/life balance. All colleagues enjoy two “Global Wellbeing Days” each year, and we offer a variety of working‑style solutions. We also provide learning opportunities to help you grow.
Aon Values Aon is proud to be an equal‑opportunity workplace. We provide 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. If you require accommodations during the application or interview process, please email ReasonableAccommodations@Aon.com.
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 education, experience, skills, and abilities, as well as internal equity and market data. This position is eligible to participate in an annual incentive plan to receive a discretionary bonus.
Benefits Summary Aon offers a comprehensive package of benefits for full‑time and regular part‑time colleagues, including a 401(k) plan with employer contributions; an employee stock purchase plan; medical, dental and vision insurance; paid time off; short‑term disability; health savings account; life insurance; optional personal insurance; adoption assistance; tuition assistance; commuter benefits; and an employee assistance program with counseling sessions.
#J-18808-Ljbffr