Health Solutions Assistant Vice President - Data Warehouse Analytics

Posting Description Health Solutions Assistant Vice President - Data Warehouse Analytics Aon is looking for a Health Solutions Assistant 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. Although we would prefer candidates to work in a hybrid work environment from our Chicago, IL, Atlanta, GA, Denver CO, or New York, NY offices, we are willing to consider a remote working environment for a strong candidate. Your impact as a Health & Benefits Assistant Vice President - Data Warehouse Analytics This position is part of our broader Health Analytics team, which falls under Aon's Health Actuarial and Financial 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. 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 Analytics & Content Management Oversee the creation, review, and delivery of analytics content and visualizations for both platform-wide and client-specific needs. Manage ad hoc analytic requests, ensuring timely and accurate responses to client inquiries. Train internal users on data warehouse tools to drive self-service analytics. Actively engage in peer review; review colleagues’ work and have your work reviewed to ensure high-quality deliverables. Data Warehouse Support & Implementation Collaborate with Aon clients, client teams, and data warehouse vendor partners to facilitate effective data warehousing solutions. Support large-scale, complex client data warehouse implementations by providing analytic oversight and guidance as needed. Support data quality assurance and the resolution of analytic issues from start to finish. Assist in defining and promoting analytic best practices, demonstrating the value of our data warehouse platform. Sales Enablement & Team Processes Support sales activities and tool demonstrations to help grow the data warehouse customer base. Assist in the coordination and creation of team process documentation to ensure consistent, efficient workflows. Ensure analytic and sales trackers, as well as issue logs, are maintained and up to date. Coordinate with vendor partners and internal teams for seamless project execution and client satisfaction. Legal & Contract Operations Manage the sign-off process, execution, and storage/maintenance requirements for legal agreements on both a client-specific and global basis. Support legal process operations related to the Health Analytics Intelligence Data Warehouse services. Support contract renewals with external team partners, collaborating with Aon procurement and business leaders as appropriate. Skills and experience that will lead to success Minimum of 8 years of analytic and team management experience Demonstrated experience providing advisory and training support to client teams on the effective use of tools and solutions. Specific knowledge and experience with health care benefits data such as Medical 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, Cedar Gate, 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 Pay Transparency Laws: 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 to receive an annual discretionary 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. How we support our colleagues Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an 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, and an employee assistance program that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies. In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile 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 for our colleagues as well. 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 and inclusive 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. People with criminal histories are encouraged to apply. 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 View email address on click.appcast.io For positions in San Francisco and Los Angeles, we will consider for employment qualified applicants with arrest and conviction record in accordance with local Fair Chance ordinances. Aon is not accepting unsolicited resumes from search firms for this position. If you are a search firm, you will not be compensated in any way for your submission of a candidate, even if Aon hires that candidate. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. #J-18808-Ljbffr AON PLC