Jobs
>
Chicago

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

    Aon
    Aon Chicago, United States

    2 weeks ago

    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

  • HUB International

    Director, Data Engineering

    1 week ago

    HUB International Chicago, United States

    Join a Winning Team at HUB International · When you join the team at HUB International, you become part of the 5th largest global insurance broker, providing a broad array of property, casualty, risk management, life and health, employee benefits, investment and wealth management ...

  • PDX

    Manager, Data Engineering

    3 weeks ago

    PDX Chicago, United States

    **Company Description** · A division of Publicis Groupe, Publicis Digital Experience is a network of top-tier agencies designed to develop capabilities and solutions to enable growth and provide scaled access to the digital capabilities of Publicis Groupe in service of our client ...

  • Avant, LLC

    Associate, Data Analytics Engineering

    1 week ago

    Avant, LLC Chicago, United States

    Avant is looking for a Associate Data Analytics Engineer, to play a crucial role in building and evolving our data model to meet a range of business initiatives. This position is suited for someone who is driven to understand complex problems and use technology to build robust so ...

  • Radiant Innovations

    Data Engineer

    3 weeks ago

    Radiant Innovations Chicago Ridge, United States

    Ahoy Captain · Are you a Data Engineer with a passion for food? Then we may be a perfect match. · Join the team behind Germany's most successful cooking app and help hundreds of thousands of users live happier and healthier lives. · As a Data Engineer for our mobile food app with ...

  • Stellar Enterprises

    Data Engineer

    2 days ago

    Stellar Enterprises Melrose, United States

    What to expect at Melrose? · You will lead the design, construction, and maintenance of the back-end data infrastructure, including data collection and pipelines for data warehousing · You will be responsible for data mining and integration, developing and maintaining data connec ...

  • Jet Support, Inc.

    Data Engineer

    2 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 ...

  • Planet Technology

    Data Engineer

    4 weeks ago

    Planet Technology Chicago, United States

    No Sponsorship Available · No C2C available · We are working with our Chicago based client who is embarking on a greenfield data migration to Azure. They are searching for a talented Azure Data Engineer with like experience to join the project from the beginning. There is an oppo ...

  • Dexian - Signature Consultants

    Data Engineer

    2 weeks ago

    Dexian - Signature Consultants 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 ...

  • SPECTRAFORCE

    Data Engineer

    6 days 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 ...

  • The LaSalle Group

    Data Engineer

    2 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 ...

  • Publicis Media

    Data Engineer

    2 weeks ago

    Publicis Media Chicago, United States

    Job Description · Job DescriptionCompany Description · Publicis Media harnesses the power of modern media through global agency brands CJ, Performics, Publicis Collective, Publicis Health Media, Spark Foundry, Starcom and Zenith. A key business solution of Publicis Groupe ([Euron ...

  • Anuvu - Global Eagle Entertainment

    Data Engineer

    3 weeks ago

    Anuvu - Global Eagle Entertainment Chicago, United States

    We are currently looking to hire a Data Engineer who will report into the Director of Air Network and become the newest member of our team. They should have a strong background in Python and SQL along with good problem-solving skills, critical thinki Data Engineer, Database Engin ...

  • Optomi

    Data Engineer

    2 weeks ago

    Optomi Chicago, United States

    Optomi, is in partnership with an Enterprise Automotive Repair Company, is seeking a Mid-Senior Level Data Engineer to join and grow the Data/BI Team in the Chicago Area. · What The Right Professional Will Enjoy · The ability to work with emerging technologies in the data enginee ...

  • 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 ...

  • AHEAD

    Data Engineer

    2 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 ...

  • Caterpillar

    Data Engineer

    3 weeks ago

    Caterpillar Chicago, United States

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

  • Georgia IT Inc

    Data Engineer

    2 weeks ago

    Georgia IT Inc Chicago, United States

    Job Title : Data Engineer · Location : Chicago, IL - Remote · Position Type : Contract · US Citizen, Green Card, TN, GC EAD and H4 EAD only No Third-party agencies corp to corp. · Job Description: 5+ years of experience in a Data Engineer role, with a Graduate degree in ...

  • BAI

    Data Engineer

    2 weeks ago

    BAI Chicago, United States

    Data Engineer Reports To: Director, Product Development & Operations BAI is the financial services industry's leading provider of powerful tools, relevant content, and meaningful connections. Our mission is to give financial services leaders the confidence to make smart business ...

  • Tekgence Inc

    Data Engineer

    3 weeks ago

    Tekgence Inc Chicago, United States

    Hi · Hope your doing good · Data Engineer · Location: Chicago, Wabash Location · Data Engineer Req Notes · need to have scalability experience/leverage cloud and build interfacing applications · need people who have built reliable applications for finance domain · understand nonf ...

  • Independence Pet Group

    Data Engineer

    3 weeks ago

    Independence Pet Group Chicago, United States

    Independence Pet Group (IPG) is one of North America's largest pet insurance and services organizations. Our impressive family of brands supports insurance for more than 1,000,000 pets in the U.S. and Canada and provides well-being, safety, resources, and business solutions to th ...