Jobs
>
Chicago

    Assistant Vice President, Claims Analytics Data Engineer - Chicago, United States - Aon Corporation

    Default job background
    Full time
    Description
    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

  • SPECTRAFORCE

    Data Engineer

    1 week ago


    SPECTRAFORCE Chicago, United States

    Job Title: Data Engineer · Duration: 6-month Contract to Hire possibility · Location: Chicago, IL Must be onsite 3 days per week · Day to day: · The client is seeking a highly skilled and motivated Data Engineer to join the team. · The ideal candidate will have expertise in dat ...

  • CapTech

    Data Engineer

    6 days ago


    CapTech Chicago, United States Full time

    Job Description · CapTech Data Engineering consultants enable clients to build and maintain advanced data systems that bring together data from disparate sources in order to enable decision-makers. We build pipelines and prepare data for use by data scientists, data analysts, and ...

  • Verano

    Data Engineer

    6 days ago


    Verano Chicago, United States

    Verano is seeking an innovative Data Engineer to join our team within IT Applications. You will be responsible for designing and building data pipelines using Python and Google cloud infrastructure. This role requires a strong understanding of data engineering principles and the ...

  • United Airlines

    Data Engineer

    2 weeks ago


    United Airlines Chicago, United States Job Type Full time

    Description · Our Marketing and Loyalty team is the strategic force behind United's industry-leading brand and experience, supporting revenue growth by turning customers into lifelong United flyers. Our marketing communications, market research and brand teams drive travelers' fa ...

  • Dexian

    Data Engineer

    3 weeks ago


    Dexian Chicago, United States

    Job Summary: · Dexian is seeking a Data Engineer for an opportunity with a client located in Chicago, IL. · Responsibilities: · Analyze and organize raw data · Build data systems and pipelines · Evaluate business needs and objectives · Interpret trends and patterns · Conduct com ...

  • Tiger Analytics

    Data Engineer

    2 days ago


    Tiger Analytics Chicago, United States Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data. Our bu ...

  • Caterpillar Inc.

    Data Engineer

    3 weeks ago


    Caterpillar Inc. Chicago, United States

    Job Title: Data Engineer 3 · Location: Chicago, IL (Hybrid 1-2 days in a week office) · Duration: 12 Months · Position's Contributions to Work Group: Python & AWS development to build, enhance and maintain monitoring capabilities. · Reason/motivation for request: - Backfill · Typ ...

  • AbbVie

    Data Engineer

    2 weeks ago


    AbbVie Chicago, United States Full time

    Job Description · Come to work each day with an inclusive and collaborative business technology team. As a Data Engineer in AbbVie Business Technology Solutions (BTS), you'll have opportunities to contribute to the digital transformation of a leading biopharma company, helping to ...

  • Dexian

    Data Engineer

    2 weeks ago


    Dexian Chicago, United States

    Job Summary: · Dexian is seeking a Data Engineer for an opportunity with a client located in Chicago, IL. · Responsibilities: · Direct programmers and analysts to make changes to existing databases and database management systems · Direct others in coding logical and physical dat ...

  • SPECTRAFORCE

    Data Engineer

    1 week ago


    SPECTRAFORCE Chicago, United States

    Job Title: Data Engineer · Duration: 6-month Contract to Hire possibility · Location: Chicago, IL Must be onsite 3 days per week · Day to day: · The client is seeking a highly skilled and motivated Data Engineer to join the team. · The ideal candidate will have expertise in dat ...

  • Jet Support, Inc.

    Data Engineer

    3 weeks ago


    Jet Support, Inc. Chicago, United States

    About JSSI For more than 35 years, Jet Support Services, Inc. (JSSI) has been the leading independent provider of maintenance support, advisory services, software, and financial tools to the business aviation industry. With 6,000+ aircraft supported by maintenance programs and so ...

  • AHEAD

    Data Engineer

    3 weeks ago


    AHEAD Chicago, United States

    AHEAD builds platforms for digital business. By weaving together advances in cloud infrastructure, automation and analytics, and software delivery, we help enterprises deliver on the promise of digital transformation. · At AHEAD, we prioritize creating a culture of belonging, wh ...

  • The LaSalle Group

    Data Engineer

    3 weeks ago


    The LaSalle Group Chicago, United States

    Want to grow your career with one of the fastest growing industries? LaSalle Network is partnered with a top Chicago-based client looking to hire a Data Engineer their team. · The Data Engineer will be responsible for delivering strategic and tangible solutions through data. We a ...

  • VXForward

    Data Engineer

    2 weeks ago


    VXForward Chicago, United States

    Job Description · Job DescriptionJoin our innovative team and help us in shaping the future of Technology · About Us: · VXForward is a leading technology solutions provider that helps to create a business value with innovative and cost-effective services across different industri ...

  • McDonald's

    Data Engineer

    4 weeks ago


    McDonald's Chicago, United States

    McDonald's evolving Accelerating the Arches growth strategy puts our customers and people first and demonstrates our competitive advantages to strengthen our brand. We are recognized on lists like Fortune's Most Admired Companies and Fast Company's Most Innovative Companies. · Do ...

  • Tiger Analytics

    Data Engineer

    15 hours ago


    Tiger Analytics Chicago, United States

    Job Description · Job DescriptionTiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate ...

  • Waltz Health

    Data Engineer

    3 weeks ago


    Waltz Health Chicago, United States

    We are a Chicago-based technology startup that is leading a new way forward for prescription care. We're rethinking the pharmaceutical supply chain, introducing AI-driven marketplaces that drive down costs, and new consumer tools that guide decisions on care. Led by a team of ind ...

  • Sky Consulting Inc

    Data Engineer

    15 hours ago


    Sky Consulting Inc Chicago, United States

    Job Description · Job DescriptionThis is a full time role in Chicago, IL Hybrid role 3 days/week. Open for candidates who are ready to relocate Day 1. No C2C enquires please · Position: Data Engineer · Location: Chicago, IL (Hybrid 3 Days/ week) · Duration: Full Time · Key Skil ...

  • Dexian

    Data Engineer

    3 weeks ago


    Dexian Chicago, United States

    Job Summary: · Dexian is seeking a Data Engineer for an opportunity with a client located in Chicago, IL. · Responsibilities: · Direct programmers and analysts to make changes to existing databases and database management systems · Direct others in coding logical and physical dat ...


  • Kin Insurance Chicago, United States

    The world has changed. Why hasnt insurance? · Kins mission is to reimagine home insurance For Every New Normal. While other insurers struggle to handle a fast-changing world, Kin is built for the future and is prepared to meet its challenges head on while helping our customers d ...