Assistant Vice President, Claims Analytics Data Engineer - Health Commercial Analytics

As part of an industry-leading team, you will help empower results for our clients by supporting our health solutions practice in developing and delivering innovative and effective solutions based on Data & Analytics preferably in our Chicago, IL, Atlanta, GA, or Denver, CO office locations but with flexibility to other Aon offices in the US as well.

This is a hybrid role with the flexibility to work both virtually and from our Chicago, IL, Atlanta, GA, or Denver, CO office locations.

While there is a preference for someone in the above listed offices, the team may consider a virtual arrangement.

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.

What the day will look like

This position supports the flow of high quality and large quantity data into Commercial Analytics data science models, solutions, and analytics. You will be challenged to manage the complexities of health data on a cloud-first and automation focused footing. Commercial Analytics has a small but growing team of data engineers with many opportunities to make an impact.

This role involves

• Joining a dynamic team with diverse backgrounds including consultants, actuaries, data scientists, engineers, health analytics experts, and solution architects
• Excellent growth, mobility, flexibility, and advancement opportunities
• Seizing opportunities to scale and automate
• Developing practice-wide data strategy and architecture
• Designing processes to deliver data required for new solutions
• Collaborating with Aon Business Services and colleagues across different time zones
• Contribute to the design of our data lake and the development of all data assets and downstream warehouses/marts
• Design, build and maintain scalable ETL/ELT pipelines from raw data ingestion through final data consumption by diverse applications
• Develop and integrate an automated data validation and quality control mechanisms throughout pipelines
• Discover and develop opportunities for automation to minimize the need for manual intervention and streamline processing
• Assist in data security, permission management and de-identification processing
• Maintain up-to-date technical and operational documentation
• Collaborate with a team of actuaries, data scientists, developers and business experts to build flexible and scalable data management and delivery tools to support Aon's data, analytics and reporting capabilities
• Adhere to design philosophy emphasizing agile to meet complex and highly dynamic business needs

How this opportunity is different

A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

Skills and experience that will lead to success

• 7+ years of experience in a ETL/ELT or data engineering capacity, ideally in medical, pharmacy, benefits and insurance claim domains
• Strong health data experience in individual level claims and enrollment data from health carriers, data warehouses, and non-traditional health service vendors
• Strong familiarity with HIPAA and related industry standards and practices
• Cloud-first experience with modern data engineering tools such as Apache Spark, python, dbt, Databricks, and Snowflake
• Experience constructing automated and maintainable data pipelines ingesting large tabular datasets (insurance claims, medical, pharmacy, eligibility and human capital data) into a data lake and populating a structured warehouse
• Knowledge of data security and privacy practices and regulations, including data access controls and de-identification and protection of sensitive data
• Demonstrable ability to convey technical information successfully to a wide variety of stakeholders
• Demonstrable ability to pick up new technologies and solutions
• Experience with AWS, Snowflake, Databricks/Apache Spark, Redshift, technologies

Nice to have

• Experience with version control systems (e.g. Git)
• Knowledge of Agile Scrum and Continuous Delivery practices
• Familiarity with benefits or health administrative data including procedure coding, diagnostic coding, financial fields, etc.
• Experience with data visualization tools (e.g. Tableau, Power BI)

Education

• BS or MS degree in Health Informatics, Data Engineering, Computer Science, Information Technology or equivalent

Pay Transparency

The salary range for this position (intended for U.S. applicants) is $140,000 to $170,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.

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.

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 (EEO) 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. Aon is committed to a diverse workforce and is an affirmative action employer. People with criminal histories are encouraged to apply.

We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on

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

#LI-DD1
#LI-HYBRID
#LI-REMOTE