Assistant Vice President, Claims Analytics Data Engineer - Health Commercial Analytics
Company: Aon Hewitt
Location: Chicago
Posted on: April 26, 2024
Job Description:
Assistant Vice President, Claims Analytics Data Engineer -
Health Commercial AnalyticsAs 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 decisionsAt 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 likeThis 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 needsHow this opportunity is differentA
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, technologiesNice 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 equivalentPay
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 2024-75447
#J-18808-Ljbffr
Keywords: Aon Hewitt, Schaumburg , Assistant Vice President, Claims Analytics Data Engineer - Health Commercial Analytics, Executive , Chicago, Illinois
Didn't find what you're looking for? Search again!
Loading more jobs...