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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

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

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

<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>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>users</code> table

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

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

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
 
Output:

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

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

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

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

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</code> table

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

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

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

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

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

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Manager Team Sizes

Aon Business Intelligence Interview Questions

Aon is looking for a Senior Product Manager, Payments!
As a Senior Product Manager in our Payments team, you will be responsible for defining and executing the product roadmap for our payment solutions. You will work closely with cross-functional teams, including engineering, design, operations, and compliance, to build and optimize payment products that enhance user experience, ensure compliance, and drive business growth. You'll have a significant impact on how customers interact with our payment systems and play a key role in shaping the future of payments at Affinity.
What the day will look like
Product Strategy & Vision: Define the product strategy and vision for payment products that align with business objectives. Stay ahead of market trends, customer needs, and emerging technologies in the payments space.
Roadmap Development: Own and prioritize the product roadmap for payments solutions. Collaborate with stakeholders to gather requirements, validate opportunities, and define clear product initiatives.
Cross-Functional Leadership: Work closely with engineering, design, data science, marketing, operations, and legal teams to deliver product features from concept to launch, ensuring alignment across all areas of the business.
Market & Customer Insights: Conduct market research, competitor analysis, and customer interviews to gain insights and ensure products meet customer needs and drive business value.
Compliance & Risk Management: Ensure product features comply with regulatory and legal requirements, including PCI DSS, GDPR, and other relevant standards. Manage risk by integrating appropriate fraud prevention and security measures.
Data-Driven Decision Making: Leverage analytics to inform product decisions, measure the success of features, and iterate on product offerings. Use KPIs to track product performance and ensure alignment with business goals.
Stakeholder Communication: Act as the main point of contact for key stakeholders regarding product status, timelines, and goals. Provide regular updates on progress, challenges, and successes.
Innovation & Optimization: Identify opportunities for improving and optimizing existing payment processes, systems, and integrations. Lead initiatives to drive efficiency, reduce friction, and improve overall user satisfaction.
Skills and experience that will lead to success
Experience: 5+ years of experience in product management, with at least 2 years focused on payment products or financial technology (FinTech).
Deep Knowledge: Strong understanding of payment systems, including gateways, fraud prevention, payment methods (credit/debit cards, wallets, bank transfers, etc.), and industry standards (e.g., PCI DSS, PSD2).
Technical Proficiency: Solid technical acumen with experience working closely with engineering teams to design and build scalable, secure payment systems. Familiarity with APIs, integrations, and back-end payment architecture is a plus.
Customer-Centric: A passion for understanding customer needs and pain points, with a proven track record of delivering successful products that improve user experience.
Leadership Skills: Demonstrated ability to lead cross-functional teams, manage multiple stakeholders, and drive alignment on complex product initiatives.
Analytical Thinking: Strong analytical skills, with experience using data to drive product decisions, optimize features, and measure success.
Communication: Excellent communication skills, both verbal and written, with the ability to translate complex technical concepts into clear, actionable insights for non-technical stakeholders.
Education:
Bachelor's degree in Business, Engineering, Computer Science, or a related field. MBA or advanced degree is a plus.
Pay Transparency Laws
The salary range for this position (intended for U.S. applicants) is $145,000 to $155,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 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 Data Engineer to join our team!

We have an exciting opportunity for a Data Engineer within Aon Global Risk Consulting (AGRC). This is a remote opportunity.

What the day will look like

We are seeking a skilled and motivated Data Engineer to join our team. As a Data Engineer at Aon, you will play a key role in designing, developing, and maintaining our data architecture. You will work closely with cross-functional teams to ensure efficient data flow and contribute to the enhancement of our data infrastructure to support a wide variety of business solutions. We are looking at the best of breed integration & data management tools to achieve this. Most of these are cutting edge technologies (StreamSets, Amazon S3, Snowflake, Databricks, Power Automate).

Essential job functions

Develop, construct, test, and maintain data architectures (databases, large-scale processing systems, etc.).
Collaborate with data scientists, analysts, and other stakeholders to understand data requirements.
Optimize and troubleshoot data processes for improved efficiency.
Ensure data security, integrity, and availability.
Stay informed about emerging technologies and contribute innovative ideas.
Participate in strategic initiatives related to innovation and process improvements.

Skills and experience that will lead to success
Proven 5+ years of experience as a Data Engineer or similar role.
A background in software development, preferred.
Working knowledge with big data file formats such as Avro, Parquet, and Optimized Row-Columnar (ORC), etc.
Strong awareness of Data Security, Data Governance, and Data Operations processes, with an ability to deliver on these key non-functional requirements.
Experience in data integration (ETL/ELT) process design, development, and testing.
Ability to perform root cause analysis on data processes and pipelines to answer specific business questions, solve issues, and identify opportunities for improvement.
Proficiency in documentation and presentations for IT and business consumption.
Exceptional problem-solving and communication skills.
A passion for working with large, structured, and unstructured datasets.

Education:
Degree in Computer Science, Software Engineering, Information Systems, or a related quantitative field.

Technical:
Experience in programming (SQL, Python, Scala) for automation and data processing.
Experience in programming Apache Spark solutions (PySpark, Scala) etc. will be a distinct advantage.

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

Pay Transparency Laws:

The salary range for this position (intended for U.S. applicants) is $90,000 to $150,000 annually. The actual salary will vary based on the 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 the 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.

#LI-NS1

#LI-REMOTE

2549952
#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. Your impact as a Compliance Risk Analyst Job Responsibilities include: + Prepare workers' compensation self-insurance filings + Prepare auto rental limited lines licensing and auto liability self-insurance filings + Maintain accurate and detailed records of state self-insurance filings and patient compensation fund compliance. + Review data reports from numerous RMIS and claims systems + Meet multiple deadlines + Log information in databases + Prepare correspondence and forms + Develop and maintain excellent client relationships + Provide guidance to clients + Assist with sale and cross selling of compliance products + Work in a team environment Qualifications: + Minimum 5 years business experience. Self-insurance compliance experience preferred but not required. + General office and math skills, computer literate (proficient in Microsoft Word, Excel and Access and Adobe Acrobat Pro) + Claim data reporting skills sought: Proficiency in Risk Console, STARS, e-Carma, Risktrac, Juris or ESIS preferred but not required + Excellent interpersonal skills, organization skills, and time management skills are necessary + Ability to multi-task and meet deadlines Education: + College degree (Business, Insurance related, or Paralegal preferred but not required) We offer you 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. 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. 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. Pay Transparency Laws: 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 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. 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 2549924 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. Your impact as a Compliance Risk Analyst Job Responsibilities include: + Prepare workers' compensation self-insurance filings + Prepare auto rental limited lines licensing and auto liability self-insurance filings + Maintain accurate and detailed records of state self-insurance filings and patient compensation fund compliance. + Review data reports from numerous RMIS and claims systems + Meet multiple deadlines + Log information in databases + Prepare correspondence and forms + Develop and maintain excellent client relationships + Provide guidance to clients + Assist with sale and cross selling of compliance products + Work in a team environment Qualifications: + Minimum 5 years business experience. Self-insurance compliance experience preferred but not required. + General office and math skills, computer literate (proficient in Microsoft Word, Excel and Access and Adobe Acrobat Pro) + Claim data reporting skills sought: Proficiency in Risk Console, STARS, e-Carma, Risktrac, Juris or ESIS preferred but not required + Excellent interpersonal skills, organization skills, and time management skills are necessary + Ability to multi-task and meet deadlines Education: + College degree (Business, Insurance related, or Paralegal preferred but not required) We offer you 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. 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. 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. Pay Transparency Laws: 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 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. 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

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. Your impact as a Compliance Risk Analyst Job Responsibilities include: + Prepare workers' compensation self-insurance filings + Prepare auto rental limited lines licensing and auto liability self-insurance filings + Maintain accurate and detailed records of state self-insurance filings and patient compensation fund compliance. + Review data reports from numerous RMIS and claims systems + Meet multiple deadlines + Log information in databases + Prepare correspondence and forms + Develop and maintain excellent client relationships + Provide guidance to clients + Assist with sale and cross selling of compliance products + Work in a team environment Qualifications: + Minimum 5 years business experience. Self-insurance compliance experience preferred but not required. + General office and math skills, computer literate (proficient in Microsoft Word, Excel and Access and Adobe Acrobat Pro) + Claim data reporting skills sought: Proficiency in Risk Console, STARS, e-Carma, Risktrac, Juris or ESIS preferred but not required + Excellent interpersonal skills, organization skills, and time management skills are necessary + Ability to multi-task and meet deadlines Education: + College degree (Business, Insurance related, or Paralegal preferred but not required) We offer you 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. 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. 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. Pay Transparency Laws: 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 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. 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 2549924 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. Your impact as a Compliance Risk Analyst Job Responsibilities include: + Prepare workers' compensation self-insurance filings + Prepare auto rental limited lines licensing and auto liability self-insurance filings + Maintain accurate and detailed records of state self-insurance filings and patient compensation fund compliance. + Review data reports from numerous RMIS and claims systems + Meet multiple deadlines + Log information in databases + Prepare correspondence and forms + Develop and maintain excellent client relationships + Provide guidance to clients + Assist with sale and cross selling of compliance products + Work in a team environment Qualifications: + Minimum 5 years business experience. Self-insurance compliance experience preferred but not required. + General office and math skills, computer literate (proficient in Microsoft Word, Excel and Access and Adobe Acrobat Pro) + Claim data reporting skills sought: Proficiency in Risk Console, STARS, e-Carma, Risktrac, Juris or ESIS preferred but not required + Excellent interpersonal skills, organization skills, and time management skills are necessary + Ability to multi-task and meet deadlines Education: + College degree (Business, Insurance related, or Paralegal preferred but not required) We offer you 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. 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. 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. Pay Transparency Laws: 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 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. 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

Aon Business Intelligence Interview Guide

Overview

Aon Business Intelligence Salary

Aon Business Intelligence Interview Process

Aon Business Intelligence Interview Questions

Aon Business Intelligence Jobs