The Aon Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Aon Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Aon? The Aon Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Aon Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Aon.</li>
<li>Practice real Aon Business Intelligence interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Aon Business Intelligence interview.


Getting ready for an Business Intelligence interview at Aon? The Aon Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Aon Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Aon.
- Practice real Aon Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Aon Business Intelligence interview.
        

Overview

Aon Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Aon Business Intelligence Interview Process

We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Rolling Bank Transactions

You’ve been asked to analyze the player’s behaviors at a gaming company.

Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.

Example:

Input:

<code>players</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Obtain count of players based on games played.

Player Analysis

What are the logistic and softmax functions? What is the difference between the two?

What makes them useful for use in logistic regression?

In logistic regression, how is the predicted class determined based on the logistic function?

In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Aon Business Intelligence Interview Questions

Business AnalystThe Business Analyst will support Aons Affinity Insurance Services group in the AICPA Insurance Programs Department. This position is responsible for providing analytical and technical support to the business community through the development of programs that provide solutions to business problems.T his is a hybrid role with the flexibility to work both virtually and from our Fort Washington, PA office two to three days per week.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:Works with the business group to document and map the current-state business processes and to translate business needs into formal, documented business requirements.Partners with the Project Manager, Business Unit and leaders on assigned technology projects to understand project scope.Maintains an acceptable level of technical proficiency in business system platforms in order to understand the interdependencies between the business and technical environments.Responsible to work thru Agile/Scrum and/or SDLC -System Development Life Cycle with offshore to ensure business requirements are being met.Create and execute test plans. Manage testing resources and document results.Works on multiple projects in different phases at one time.Supports creation, tracking and resolution of defects noted for all in scope system applications.Key accountability is to create business requirements/user storis for assigned projects.Skills and experience that will lead to successBusiness Analyst or similarly related work experience (2+ years)Experience with Microsoft Office Suite (Word, Excel, PowerPoint)Agile/Scrum experience or training preferredBusiness Analyst or related course work preferredEducation:College degree or equivalent work experienceHow we support our colleaguesIn 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 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 ReasonableAccommodations@Aon.comFor 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.Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.The salary range for this position (intended for U.S. applicants) is $80,000 $90,000 annually. The actual salary will vary based on applicants education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicants geographic location.This position is eligible to participate in one of Aons 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.A summary of all the benefits offered for that position: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 Aons 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 p rogram that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies.#LI-PR1#LI-HYBRID#LI-AM42551188Business AnalystThe Business Analyst will support Aons Affinity Insurance Services group in the AICPA Insurance Programs Department. This position is responsible for providing analytical and technical support to the business community through the development of programs that provide solutions to business problems.T his is a hybrid role with the flexibility to work both virtually and from our Fort Washington, PA office two to three days per week.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:Works with the business group to document and map the current-state business processes and to translate business needs into formal, documented business requirements.Partners with the Project Manager, Business Unit and leaders on assigned technology projects to understand project scope.Maintains an acceptable level of technical proficiency in business system platforms in order to understand the interdependencies between the business and technical environments.Responsible to work thru Agile/Scrum and/or SDLC -System Development Life Cycle with offshore to ensure business requirements are being met.Create and execute test plans. Manage testing resources and document results.Works on multiple projects in different phases at one time.Supports creation, tracking and resolution of defects noted for all in scope system applications.Key accountability is to create business requirements/user storis for assigned projects.Skills and experience that will lead to successBusiness Analyst or similarly related work experience (2+ years)Experience with Microsoft Office Suite (Word, Excel, PowerPoint)Agile/Scrum experience or training preferredBusiness Analyst or related course work preferredEducation:College degree or equivalent work experienceHow we support our colleaguesIn 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 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 ReasonableAccommodations@Aon.comFor 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.Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.The salary range for this position (intended for U.S. applicants) is $80,000 $90,000 annually. The actual salary will vary based on applicants education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicants geographic location.This position is eligible to participate in one of Aons 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.A summary of all the benefits offered for that position: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 Aons 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 p rogram that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies.#LI-PR1#LI-HYBRID#LI-AM4

Aon is looking for an Eagle Pace Data Analyst

The Delegated team (an outsource chief investment officer unit) of Aon Investment Consulting is currently seeking a Data Analyst to join the team. This individual will be responsible for the following responsibilities:

Handle daily data processing routines in a data warehouse and Trade Order Management System. View status and exceptions. Investigate and resolve discrepancies and exceptions. Ensure data integrity.

Provide ongoing data support and troubleshooting

Work with IT teams to technical requirements

The individual will be located in Chicago and will interact with Team members in the US and UK to support a global business platform.

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.

Required Skills

High learning agility.

Bachelor’s degree with course work in business/computer science or related experience preferred.

Basic understanding of financial/investment concepts and math.

Excellent analytical skills.

Ability to work well in a fast-paced,environment.

Accuracy and attention to detail.

Ability to work independently and within a team on a variety of projects, receive instructions from a number of people and meet project deadlines.

Excellent planning and organizational skills.

Good oral/written communication skills.

Experience with databases, data management a plus

Experience with SQL a plus

Experience with Bloomberg AIM/Eagle Pace a plus

2+ years of work experience as an Operations Data Analyst preferred

Desire to pursue technology / data management career track

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

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 ReasonableAccommodations@Aon.com

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

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

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.

#LI-BN1

2553354

Aon is looking for an Eagle Pace Data Analyst

The Delegated team (an outsource chief investment officer unit) of Aon Investment Consulting is currently seeking a Data Analyst to join the team. This individual will be responsible for the following responsibilities:

Handle daily data processing routines in a data warehouse and Trade Order Management System. View status and exceptions. Investigate and resolve discrepancies and exceptions. Ensure data integrity.

Provide ongoing data support and troubleshooting

Work with IT teams to technical requirements

The individual will be located in Chicago and will interact with Team members in the US and UK to support a global business platform.

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.

Required Skills

High learning agility.

Bachelor’s degree with course work in business/computer science or related experience preferred.

Basic understanding of financial/investment concepts and math.

Excellent analytical skills.

Ability to work well in a fast-paced,environment.

Accuracy and attention to detail.

Ability to work independently and within a team on a variety of projects, receive instructions from a number of people and meet project deadlines.

Excellent planning and organizational skills.

Good oral/written communication skills.

Experience with databases, data management a plus

Experience with SQL a plus

Experience with Bloomberg AIM/Eagle Pace a plus

2+ years of work experience as an Operations Data Analyst preferred

Desire to pursue technology / data management career track

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

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 ReasonableAccommodations@Aon.com

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

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

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.

#LI-BN1

Health Analytics Product Analyst/ConsultantWe are seeking an innovative health analytics analyst or consultant to join our dynamic team.As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions developing and commercializing health analytics capabilities at Aon. This role will lead development and commercialization initiatives supporting new and existing analytics solutions and serve as the analytics subject matter expert for practice-wide initiatives, client and prospect conversations. The ideal candidate will possess strong organizational skills, the ability to collaborate and communicate clearly and effectively with cross-functional teams and deliver market-leading solutions to Aon clients.This is a hybrid role with the flexibility to work both virtually and from our Atlanta, Chicago, Denver, or Philadelphia offices.While there is a preference for someone in the above listed locations, we are willing to consider a candidate to work virtually as well.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 like<ul><li>Consultant for advanced analytics client projects and pilot projects and initiatives. Ensure high-quality and timely delivery that exceeds client expectations.</li><li>Participate in and put together proposals for new business discussions with prospective clients.</li><li>Showcase and present on analytics capabilities and market trends at both internal and external events.</li><li>Support the commercialization and development of analytics capabilities, maintaining or leading the development and implementation of new products and solutions.</li><li>Go to market activities including development of consulting materials, sales materials, leading national trainings, training and organizing sales resources.</li><li>Build out and improve processes for client analytics delivery and onboarding, including identifying opportunities for automation, developing management reporting, and client reporting improvements.</li><li>Stakeholder alignment: Collaborate with stakeholders, including clients, internal teams, legal, marketing and industry experts, to gather requirements for new analytics solutions.</li><li>Prioritization: Prioritize features and functionalities based on their value, feasibility, and alignment with strategic objectives.</li><li>Innovation: Stay current on emerging trends and industry developments, propose new capabilities or suggestions to revamp existing capabilities to meet emerging client needs.</li><li>Cross-functional collaboration: Work closely with cross-functional teams, including data scientists, analytics engineers, actuaries, and consultants, to develop and maintain analytics solutions.</li><li>Iterative Development: Oversee the iterative development process, including sprint planning, backlog grooming, and sprint reviews.</li><li>Quality Assurance: Ensure the quality and reliability of new analytics solutions by defining acceptance criteria, conducting user acceptance testing, and monitoring performance metrics.</li><li>Engage with clients and Aon colleagues to gather feedback, demonstrate prototypes, and solicit input for future enhancements.</li></ul>Skills and experience that will lead to success<ul><li>3+ years of client-facing or related experience in health or benefits, health actuarial and analytics work.</li><li>Excellent communication and interpersonal skills, with the ability to effectively collaborate with diverse stakeholders.</li><li>Experience contributing to national initiatives, products, model and tool development is strongly preferred.</li><li>Demonstrated ability to think strategically, solve complex problems, and drive results in a fast-paced environment.</li><li>Experience with reinsurance and reinsurance modeling, including stop loss, captives, and related arrangements.</li><li>Understanding of predictive modeling and insurance applications.</li><li>Strong technical background in actuarial modeling and statistical methods including familiarity with emerging technologies, data science and machine learning techniques.</li><li>Understanding of market trends, client needs, and emerging vendors.</li><li>Proven ability to mentor junior colleagues.</li><li>Understanding of Agile project management a plus.</li><li>ASA or pursuing FSA Actuarial credentials a plus.</li></ul>Education<ul><li>Bachelor's degree in Economics, Actuarial Science, Mathematics, Informatics, Statistics, or related field.</li></ul>Pay TransparencyThe salary range for this position (intended for U.S. applicants) is $80,000 - $120,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.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.How we support our colleaguesAon 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; medical, dental and vision insurance; paid time off; short-term and optional long-term disability; health savings account; and tuition assistance.We encourage a diverse workforce and recognize the importance of work/life balance, ensuring you can be your best self at Aon.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.
#J-18808-Ljbffr

Aon is looking for a Self-Insurance Compliance Risk Analyst.As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting our Aon Global Risk Consultant Group, in Bloomington, MN. As a Compliance Risk Analyst for Self-Insured companies, you will report directly to the Senior Risk Consultant.This is a hybrid role in Bloomington, MN and there will be an in-office requirement of 1+ days per week.<h3>Your impact as a Compliance Risk Analyst</h3>Job Responsibilities include:<ul><li>Prepare workers' compensation self-insurance filings</li><li>Prepare auto rental limited lines licensing and auto liability self-insurance filings</li><li>Maintain accurate and detailed records of state self-insurance filings</li><li>Review data reports from numerous RMIS and claims systems</li><li>Meet multiple deadlines</li><li>Log information in databases</li><li>Prepare correspondence and forms</li><li>Develop and maintain excellent client relationships</li><li>Provide guidance to clients</li><li>Assist with sale and cross selling of compliance products</li><li>Work in a team environment</li></ul><h3>Qualifications:</h3><ul><li>Minimum 5 years business experience. Self-insurance compliance experience preferred but not required.</li><li>General office and math skills, computer literate (proficient in Microsoft Word, Excel and Access and Adobe Acrobat Pro)</li><li>Claim data reporting skills sought: Proficiency in Risk Console, STARS, e-Carma, Risktrac, Juris or ESIS preferred but not required</li><li>Excellent interpersonal skills, organization skills, and time management skills are necessary</li><li>Ability to multi-task and meet deadlines</li></ul><h3>Education:</h3><ul><li>College degree (Business, Insurance related, or Paralegal preferred but not required)</li></ul><h3>We offer you</h3>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.<h3>How we support our colleagues</h3>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 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 ReasonableAccommodations@Aon.com.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.Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.<h3>Pay Transparency Laws:</h3>The salary range for this position (intended for U.S. applicants) is $65,000 to $80,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.The salary range reflected is based on a primary work location of Bloomington, MN. The actual salary may vary for applicants in a different geographic location.#LI-MB1#LI-HYBRID
#J-18808-Ljbffr

Aon is looking for an Eagle Pace Data Analyst
The Delegated team (an outsource chief investment officer unit) of Aon Investment Consulting is currently seeking a Data Analyst to join the team. This individual will be responsible for the following responsibilities:
Handle daily data processing routines in a data warehouse and Trade Order Management System. View status and exceptions. Investigate and resolve discrepancies and exceptions. Ensure data integrity.
Provide ongoing data support and troubleshooting
Work with IT teams to technical requirements
The individual will be located in Chicago and will interact with Team members in the US and UK to support a global business platform.
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.
Required Skills
High learning agility.
Bachelor's degree with course work in business/computer science or related experience preferred.
Basic understanding of financial/investment concepts and math.
Excellent analytical skills.
Ability to work well in a fast-paced,environment.
Accuracy and attention to detail.
Ability to work independently and within a team on a variety of projects, receive instructions from a number of people and meet project deadlines.
Excellent planning and organizational skills.
Good oral/written communication skills.
Experience with databases, data management a plus
Experience with SQL a plus
Experience with Bloomberg AIM/Eagle Pace a plus
2+ years of work experience as an Operations Data Analyst preferred
Desire to pursue technology / data management career track
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 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.
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 ReasonableAccommodations@Aon.com
Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.
The salary range for this position (intended for U.S. applicants) is $51,000 to $75,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.
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.
#LI-BN1
2553354

Health Analytics Product Analyst/Consultant We are seeking an innovative health analytics analyst or consultant to join our dynamic team. As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions developing and commercializing health analytics capabilities at Aon. This role will lead development and commercialization initiatives supporting new and existing analytics solutions and serve as the analytics subject matter expert for practice-wide initiatives, client and prospect conversations. The ideal candidate will possess strong organizational skills, the ability to collaborate and communicate clearly and effectively with cross-functional teams and deliver market-leading solutions to Aon clients. This is a hybrid role with the flexibility to work both virtually and from our Atlanta, Chicago, Denver, or Philadelphia offices. While there is a preference for someone in the above listed locations, we are willing to consider a candidate to work virtually as well. 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 <ul><li>Consultant for advanced analytics client projects and pilot projects and initiatives. Ensure high-quality and timely delivery that exceeds client expectations. </li><li>Participate in and put together proposals for new business discussions with prospective clients. </li><li>Showcase and present on analytics capabilities and market trends at both internal and external events. </li><li>Support the commercialization and development of analytics capabilities, maintaining or leading the development and implementation of new products and solutions. </li><li>Go to market activities including development of consulting materials, sales materials, leading national trainings, training and organizing sales resources. </li><li>Build out and improve processes for client analytics delivery and onboarding, including identifying opportunities for automation, developing management reporting, and client reporting improvements. </li><li>Stakeholder alignment: Collaborate with stakeholders, including clients, internal teams, legal, marketing and industry experts, to gather requirements for new analytics solutions. </li><li>Prioritization: Prioritize features and functionalities based on their value, feasibility, and alignment with strategic objectives. </li><li>Innovation: Stay current on emerging trends and industry developments, propose new capabilities or suggestions to revamp existing capabilities to meet emerging client needs. </li><li>Cross-functional collaboration: Work closely with cross-functional teams, including data scientists, analytics engineers, actuaries, and consultants, to develop and maintain analytics solutions. </li><li>Iterative Development: Oversee the iterative development process, including sprint planning, backlog grooming, and sprint reviews. </li><li>Quality Assurance: Ensure the quality and reliability of new analytics solutions by defining acceptance criteria, conducting user acceptance testing, and monitoring performance metrics. </li><li>Engage with clients and Aon colleagues to gather feedback, demonstrate prototypes, and solicit input for future enhancements. </li> </ul>Skills and experience that will lead to success <ul><li>3+ years of client-facing or related experience in health or benefits, health actuarial and analytics work. </li><li>Excellent communication and interpersonal skills, with the ability to effectively collaborate with diverse stakeholders. </li><li>Experience contributing to national initiatives, products, model and tool development is strongly preferred. </li><li>Demonstrated ability to think strategically, solve complex problems, and drive results in a fast-paced environment. </li><li>Experience with reinsurance and reinsurance modeling, including stop loss, captives, and related arrangements. </li><li>Understanding of predictive modeling and insurance applications. </li><li>Strong technical background in actuarial modeling and statistical methods including familiarity with emerging technologies, data science and machine learning techniques. </li><li>Understanding of market trends, client needs, and emerging vendors. </li><li>Proven ability to mentor junior colleagues. </li><li>Understanding of Agile project management a plus. </li><li>ASA or pursuing FSA Actuarial credentials a plus. </li> </ul>Education <ul><li>Bachelor's degree in Economics, Actuarial Science, Mathematics, Informatics, Statistics, or related field. </li> </ul>Pay Transparency The salary range for this position (intended for U.S. applicants) is $80,000 - $120,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. 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. 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; medical, dental and vision insurance; paid time off; short-term and optional long-term disability; health savings account; and tuition assistance. We encourage a diverse workforce and recognize the importance of work/life balance, ensuring you can be your best self at Aon. 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. #J-18808-Ljbffr

Aon is looking for an Eagle Pace Data Analyst The Delegated team (an outsource chief investment officer unit) of Aon Investment Consulting is currently seeking a Data Analyst to join the team. This individual will be responsible for the following responsibilities: <ul><li>Handle daily data processing routines in a data warehouse and Trade Order Management System. View status and exceptions. Investigate and resolve discrepancies and exceptions. Ensure data integrity. </li><li>Provide ongoing data support and troubleshooting </li><li>Work with IT teams to technical requirements </li></ul> The individual will be located in Chicago and will interact with Team members in the US and UK to support a global business platform. 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. Required Skills <ul> <li>High learning agility. </li><li>Bachelor's degree with course work in business/computer science or related experience preferred. </li><li>Basic understanding of financial/investment concepts and math. </li><li>Excellent analytical skills. </li><li>Ability to work well in a fast-paced,environment. </li><li>Accuracy and attention to detail. </li><li>Ability to work independently and within a team on a variety of projects, receive instructions from a number of people and meet project deadlines. </li><li>Excellent planning and organizational skills. </li><li>Good oral/written communication skills. </li><li>Experience with databases, data management a plus </li><li>Experience with SQL a plus </li><li>Experience with Bloomberg AIM/Eagle Pace a plus </li><li>2+ years of work experience as an Operations Data Analyst preferred </li><li>Desire to pursue technology / data management career track </li></ul> 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 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. 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 ReasonableAccommodations@Aon.com Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. The salary range for this position (intended for U.S. applicants) is $51,000 to $75,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. 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. #LI-BN1 2553354

Health Analytics Product Analyst/ConsultantWe are seeking an innovative health analytics analyst or consultant to join our dynamic team.As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions developing and commercializing health analytics capabilities at Aon. This role will lead development and commercialization initiatives supporting new and existing analytics solutions and serve as the analytics subject matter expert for practice-wide initiatives, client and prospect conversations. The ideal candidate will possess strong organizational skills, the ability to collaborate and communicate clearly and effectively with cross-functional teams and deliver market-leading solutions to Aon clients.This is a hybrid role with the flexibility to work both virtually and from our Atlanta, Chicago, Denver, or Philadelphia offices. While there is a preference for someone in the above listed locations, we are willing to consider a candidate to work virtually as well.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 like<ul><li>Consultant for advanced analytics client projects and pilot projects and initiatives. Ensure high-quality and timely delivery that exceeds client expectations.</li><li>Participate in and put together proposals for new business discussions with prospective clients.</li><li>Showcase and present on analytics capabilities and market trends at both internal and external events.</li><li>Support the commercialization and development of analytics capabilities, maintaining or leading the development and implementation of new products and solutions.</li><li>Go to market activities including development of consulting materials, sales materials, leading national trainings, training and organizing sales resources.</li><li>Build out and improve processes for client analytics delivery and onboarding, including identifying opportunities for automation, developing management reporting, and client reporting improvements.</li><li>Stakeholder alignment: Collaborate with stakeholders, including clients, internal teams, legal, marketing and industry experts, to gather requirements for new analytics solutions.</li><li>Prioritization: Prioritize features and functionalities based on their value, feasibility, and alignment with strategic objectives. This requires balancing competing demands and making data-driven decisions to maximize the impact of the solutions.</li><li>Innovation: Stay current on emerging trends and industry developments, propose new capabilities or suggestions to revamp existing capabilities to meet emerging client needs.</li><li>Cross-functional collaboration: Work closely with cross-functional teams, including data scientists, analytics engineers, actuaries, and consultants, to develop and maintain analytics solutions.</li><li>Iterative Development: Oversee the iterative development process, including sprint planning, backlog grooming, and sprint reviews.</li><li>Quality Assurance: Ensure the quality and reliability of new analytics solutions by defining acceptance criteria, conducting user acceptance testing, and monitoring performance metrics.</li><li>Engage with clients and Aon colleagues to gather feedback, demonstrate prototypes, and solicit input for future enhancements.</li></ul>Skills and experience that will lead to success<ul><li>3+ years of client-facing or related experience in health or benefits, health actuarial and analytics work.</li><li>Excellent communication and interpersonal skills, with the ability to effectively collaborate with diverse stakeholders.</li><li>Experience contributing to national initiatives, products, model and tool development is strongly preferred.</li><li>Demonstrated ability to think strategically, solve complex problems, and drive results in a fast-paced environment.</li><li>Experience with reinsurance and reinsurance modeling, including stop loss, captives, and related arrangements.</li><li>Understanding of predictive modeling and insurance applications.</li><li>Strong technical background in actuarial modeling and statistical methods including familiarity with emerging technologies, data science and machine learning techniques.</li><li>Understanding of market trends, client needs, and emerging vendors.</li><li>Proven ability to mentor junior colleagues.</li><li>Understanding of Agile project management a plus.</li><li>ASA or pursuing FSA Actuarial credentials a plus.</li></ul>Education<ul><li>Bachelor's degree in Economics, Actuarial Science, Mathematics, Informatics, Statistics, or related field.</li></ul>Pay TransparencyThe salary range for this position (intended for U.S. applicants) is $80,000 - $120,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 colleaguesAon 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 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 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 ReasonableAccommodations@Aon.com.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.Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.#LI-HP1#REMOTE#HYBRID
#J-18808-Ljbffr

Aon Business Intelligence Interview Guide

Overview

Aon Business Intelligence Salary

Aon Business Intelligence Interview Process

Aon Business Intelligence Interview Questions

Aon Business Intelligence Jobs