The Aon Data Analyst interview guide, interview questions, salary data, and interview experiences.

Aon Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Aon? The Aon Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Aon Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Aon.</li>
<li>Practice real Aon Data Analyst 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 Data Analyst interview.


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

- Know what skills are necessary for Aon Data Analyst roles.
- Gain insights into the Data Analyst interview process at Aon.
- Practice real Aon Data Analyst 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 Data Analyst interview.
        

Overview

Aon Data Analyst 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.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Aon Data Analyst Interview Process

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</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>
</tbody>
</table>
<code>expenses</code> table

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

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

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

The probability that it will rain tomorrow is dependent on whether or not it is raining today and whether or not it rained yesterday.

If it rained yesterday and today, there is a 20% chance it will rain tomorrow. If it rained one of the days, there is a 60% chance it will rain tomorrow. If it rained neither today nor yesterday, there is a 20% chance it will rain tomorrow.

Given that it is raining today and that it rained yesterday, write a function <code>rain_days</code> to calculate the probability that it will rain on the nth day after today.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n=5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def rain_days(n) -&gt; 0.39968
</code></pre>

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

You’re given two dataframes. One contains information about addresses and the other contains relationships between various cities and states:

Example:

<code>df_addresses</code>

<table>
<thead>
<tr>
<th>address</th>
</tr>
</thead>

<tbody>
<tr>
<td>4860 Sunset Boulevard, San Francisco, 94105</td>
</tr>

<tr>
<td>3055 Paradise Lane, Salt Lake City, 84103</td>
</tr>

<tr>
<td>682 Main Street, Detroit, 48204</td>
</tr>

<tr>
<td>9001 Cascade Road, Kansas City, 64102</td>
</tr>

<tr>
<td>5853 Leon Street, Tampa, 33605</td>
</tr>
</tbody>
</table>
<code>df_cities</code>

<table>
<thead>
<tr>
<th>city</th>
<th>state</th>
</tr>
</thead>

<tbody>
<tr>
<td>Salt Lake City</td>
<td>Utah</td>
</tr>

<tr>
<td>Kansas City</td>
<td>Missouri</td>
</tr>

<tr>
<td>Detroit</td>
<td>Michigan</td>
</tr>

<tr>
<td>Tampa</td>
<td>Florida</td>
</tr>

<tr>
<td>San Francisco</td>
<td>California</td>
</tr>
</tbody>
</table>
Write a function <code>complete_address</code> to create a single dataframe with complete addresses in the format of street, city, state, zip code.

Input:

<pre tabindex="0" class="chroma"><code>import pandas as pd

addresses = {&#34;address&#34;: [&#34;4860 Sunset Boulevard, San Francisco, 94105&#34;, &#34;3055 Paradise Lane, Salt Lake City, 84103&#34;, &#34;682 Main Street, Detroit, 48204&#34;, &#34;9001 Cascade Road, Kansas City, 64102&#34;, &#34;5853 Leon Street, Tampa, 33605&#34;]}

cities = {&#34;city&#34;: [&#34;Salt Lake City&#34;, &#34;Kansas City&#34;, &#34;Detroit&#34;, &#34;Tampa&#34;, &#34;San Francisco&#34;], &#34;state&#34;: [&#34;Utah&#34;, &#34;Missouri&#34;, &#34;Michigan&#34;, &#34;Florida&#34;, &#34;California&#34;]}

df_addresses = pd.DataFrame(addresses)
df_cities = pd.DataFrame(cities)
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def complete_address(df_addresses,df_cities) -&gt;
</code></pre>

<table>
<thead>
<tr>
<th>address</th>
</tr>
</thead>

<tbody>
<tr>
<td>4860 Sunset Boulevard, San Francisco, California, 94105</td>
</tr>

<tr>
<td>3055 Paradise Lane, Salt Lake City, Utah, 84103</td>
</tr>

<tr>
<td>682 Main Street, Detroit, Michigan, 48204</td>
</tr>

<tr>
<td>9001 Cascade Road, Kansas City, Missouri, 64102</td>
</tr>

<tr>
<td>5853 Leon Street, Tampa, Florida, 33605</td>
</tr>
</tbody>
</table>

Write a function to create a single dataframe with complete addresses in the format of street, city, state, zip code.

Complete Addresses

Aon Data Analyst Interview Questions

Posting Description: <h2>Risk Analyst</h2>Do you want to be a driving force in helping to deliver strong results? If so, we'd like to meet you! Aon is seeking a dedicated and highly analytical Risk Management Analyst to join our organization! The Risk Management Analyst will directly support our client, Hyatt, and collaborate with cross-functional teams and our insurance brokerage partners to protect our employees, guests, and properties through the placement of insurance programs. The ideal candidate will be responsible for assisting with the insurance renewal process, managing our annual Risk Management Survey to gather all hotel risk exposures, and working to maintain and update our various risk management information systems. This role will be a hybrid role with the expectation of being in the Chicago office 2-3 days/week.<h2>Role and Responsibilities: </h2><ul><li>Insurance Renewal Support: Assist the Senior Analyst with gathering and reviewing all exposure data for inclusion in insurance submissions. Keep the renewal tracking document up to date and alert team members of due dates. Work with brokers to answer any questions on the data. After the renewal is complete, update the risk management shared drive with the notices to bind coverage, insurance binders and insurance policies.</li><li>Certificates of Insurance: Responsible for support, coordination and administration of Certificates of Insurance documentation including collection, distribution and management summary and reporting for hotels globally. Responsible for responding to hotels request for new or additional certificates.</li><li>Onboarding hotels: Assist Senior Analyst with the Open, Change, and Close process by sending out notifications and following up locations on actual open/close dates. Assist with monthly reconciliation to ensure all active Hyatt hotels are in the Risk Portal. Keep brokers informed of changes.</li><li>Scheduling: Act as primary scheduler for all risk meetings, including but not limited to, underwriting meetings, internal team meetings, RIMS events, AHLA risk committee meetings, and captive insurance board meetings. Work with broker and team members to plan travel and ensure all appropriate invitees are include on meeting notices.</li><li>Risk Information Systems: Responsible for Risk Management Information System support, coordination and administration including user access requests, uploading information and input and verification of system information. Update our risk information systems to include the exposure data and the results (premium costs, limits, deductibles, etc.) of the insurance renewals.</li><li>Risk Management Survey: Assist the Senior Analyst with managing the process for collecting accurate property exposure data from the hotels.</li><li>Hotel Requests: Work with senior analyst to answer hotels questions about insurance coverage, pricing, invoices, and insurance documentation. Provide training to hotels on the self-service features of the Risk Portal.</li><li>NDA Management: Work with Legal and Hyatts Cyber broker to update and maintain the NDAs for the insurance carriers working bidding on Hyatts cyber insurance coverage.</li><li>The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.</li></ul><h2>Experience Preferred:</h2><ul><li>1 - 2 years of experience with risk management or insurance responsibilities preferred.</li><li>Bachelors degree in risk management, Business, Finance, or a related field preferred.</li><li>Proficiency in data analysis and reporting, using tools such as Excel and Risk Management Information Systems.</li><li>Excellent communication skills, both written and verbal, with the ability to convey complex information clearly and effectively.</li><li>Strong attention to detail and analytical thinking.</li><li>Ability to work collaboratively in a team environment and influence stakeholders at various levels.</li></ul> 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 program that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies. How we support our colleagues: In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two Global Wellbeing Days each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognize that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working! Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued. Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace. Aon provides equal employment opportunities 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 <a href="mailto:ReasonableAccommodations@Aon.com" target="_blank" rel="noopener">ReasonableAccommodations@Aon.com</a> 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 $75,000 to $85,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 Chicago, IL. The actual salary may vary for applicants in a different 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. #LI-MB1#LI-HYBRID

Are you technical with a passion for helping the business exceed goals? Do you enjoy using your analytical skills to identify inefficiencies and solving them? If so, this could be a fit for you! <h5>Aon is in the business of better decisions </h5>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. <h5>What the day will look like </h5><ul> <li>Responsible for partnering with business/user group representatives to understand business processes and underlying informational and/or process automation needs. </li><li>Responsible for translating business needs into formal and clearly documented business requirements to be used for system design </li><li>Responsible for identifying requirement and scope related issues and risks </li><li>Liaison between business/user group representatives and system development personnel during development efforts. </li><li>Assist in developing and conducting testing plans and criteria </li><li>Assist with system support of developed applications through the unique combination of business and system analysis, quality assurance and post implementation product support </li><li>Update, test and fix documents & associated logic in response to customer requests and regulations. </li></ul> <h5>How this opportunity is different </h5>The Technical Business analyst is a part of a tenured team assisting various businesses migrate and integrate systems, finding inconsistencies, testing and solving while being a liason between the business and IT. <h5>Skills and experience that will lead to success </h5><ul> <li>Business knowledge of Insurance Underwriting, Policy Administration or Claims preferred. </li><li>Microsoft Office products knowledge, with proficiency in Microsoft Word and Excel. </li><li>Proficiency using the SmartCOMM Next-Gen CCM tool and associated capabilities preferred. </li><li>Ability to use SmartCOMM' s Advanced Template Designer & Template Editor preferred. </li><li>Working knowledge of SmartCOMM Data Modeler design and testing methods preferred. </li><li>Proven analytical skills and ability to identify & implement efficiencies </li><li>Demonstrated ability to work independently to meet project deadlines </li><li>Understanding of project management tools and techniques </li><li>Working knowledge of systems development life cycle and systems development methodologies </li></ul> Education: Bachelor's degree in Computer Science, Information Technology (IT), comparable discipline preferred, or equivalent years of industry experience. <h5>How we support our colleagues </h5>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. <h5>Pay Transparency Law: </h5>The salary range for this position (intended for U.S. applicants) is $82100 to $90,000 annually. The actual salary will vary based on applicant's education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant's geographic location. This position is eligible to participate in one of Aon's annual incentive plans to receive an annual discretionary bonus in addition to base salary. The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan. Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an employee stock purchase plan; consideration for long-term incentive awards at Aon's discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, short-term disability and optional long-term disability, health savings account, health care and dependent care reimbursement accounts, employee and dependent life insurance and supplemental life and AD&D insurance; optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies #LI-NS1 #LI-REMOTE 2550892

Descripcin de la publicacin: WHO WE ARE At CoverWallet we are determined to revolutionize the insurance industry! We launched in 2015 and since then we are the leading digital platform for contracting insurance for small and medium-sized companies. Thanks to state-of-the-art technology and meticulous design we have turned insurance management and processing into a simple, fast and convenient process for our clients. All online, in minutes! Our passion is in delivering innovation and value creation through technology, and our mission is to become the worlds leading InsurTech. For this, we have built an incredible team of ~800 people based in New York, Spain, Poland and Singapore. Success is guaranteed as we are part of Aon, the global leaders in risk, retirement and health solutions with 50,000 colleagues worldwide. We combine the mindset and culture of a high-growth startup with the backing and support of a global multinational. The best of both worlds in one company - what more could we ask for? WHAT YOU WILL DO We're looking for an awesome Site Reliability Engineer and DevOps practitioner, to be part of the Engineering team and help us with the security, stability and scalability of our multi-site platform while being and operational enabler for the rest of the organization. A TYPICAL DAY <ul><li>Implement and maintain a metrics collection, log management and service health check systems. </li><li>Systems design consulting, infrastructure capacity planning and cost efficiency exercises. </li><li>Triage and troubleshoot production issues enriching feedback loops to other engineering teams with blameless postmortems. </li><li>Enable fast and reliable configuration changes and deployments to Engineering and Product teams. </li><li>Implement artifacts lifecycle policies and CI/CD Pipelines. </li><li>Maintain, customize and/or develop operational tooling that brings velocity to the engineering team. </li></ul> <h5>WHAT YOU NEED TO SUCCEED </h5> <ul><li>5+ years working in infrastructure and software engineering environments. </li><li>Problem solving enthusiast and technical deep diver. </li><li>Experienced engineer used to write software to solve problems. </li><li>Experienced engineer on systems bottlenecks analysis and scalability issues resolution. </li><li>Open contributor, collaborator and team player. </li><li>Computer Science fundamentals skillful: OS, Networking and Storage. </li><li>Experienced engineer on platform enforcement and service protection against external attacks. </li><li>English proficiency is a must. </li><li>Experience with Ruby and/or Javascript is a plus. </li></ul> OTHER VALUABLE TECHIE EXPERIENCES <ul><li>Blue-green deployment and A/B testing. </li><li>Cloud-native development and serverless approach. </li><li>Infrastructure as Code. </li><li>Security as a first class citizen (DevSecOps). </li><li>Microservices architecture. </li><li>Measure everything and data-driven decisions. </li></ul> ABOUT THE RECRUITMENT PROCESS <ul><li>Your first contact with CoverWallet will be through an HR interview with one of our colleagues from the Talent Acquisition area, who will tell you everything about our company and its history, as well as the details of the position, functions and your future conditions. We would love to know your professional and academic career, and of course, your motivations and expectations for a new professional project. We will be happy to answer all your questions! </li><li>Do we have a match? Lets move on to your First Technical Interview! You will meet two of your future colleagues from the SRE area, who will explain to you in more detail what the team's day-to-day life is and its responsibilities. They will be very interested in expanding information about your experience in infrastructure and systems, both from a corporate and application point of view, as well as your programming skills. </li><li>If everything has gone well and you have impressed our colleagues... we advance to the Second Technical Interview! In line with the previous one, you will meet two other members of the SRE team, who will continue to deepen your knowledge at the level of methodologies, roles and previous projects, as well as in relation to your background in our reference technological environments (cloud, containers, Kubernetes, etc.) </li><li>If you've made it this far, things are getting interesting... It's time for your Final Interview! In this case, you will have the opportunity to meet one of our VP of Engineering, who will close the selection process with an interview aimed at getting to know you not only on a professional and technical level, but also on a personal level, so that both of you can reach the conclusion of whether the purpose of our project fits with your professional aspirations. </li></ul> WHY COVERWALLET At CoverWallet you will have the opportunity to be a key player in the transformation of one of the largest industries and in one of the most developed digital markets in the world. You will work in a cutting-edge tech environment, alongside a super powerful and diverse global team. Join us and build your own career plan in one of the world's leading companies, tailored to your dreams and aspirations! And just for good measure <ul><li>Competitive salary based on your background and experience, and a variable annual bonus set according to your goals </li><li>Enjoy flexible working hours and find out your ideal way of working thanks to our smart work model: full remote or hybrid, its up to you! </li><li>Perks package consisting of a Company-paid Life, Accident Insurance and Medical Cover with free dental care. Complement your benefits with our flexible compensation plan (tickets restaurant, transport card, daycare checks, external training and even a Pension Scheme!) </li><li>Carry on with your training thanks to your additional budget of 1,500 per year to finance training courses, certifications, books or any teaching aids that will help you continue to grow professionally </li><li>Enjoy a lot of offers and save on your purchases thanks to our discount platform (BigPocket) on your favorite brands (travel, fashion, technology, leisure...) </li><li>23 paid vacation days per year, plus 2 additional personal days and 2 wellbeing days to focus on your own health and prioritize self-care :) </li></ul> Great offices in Madrid, Valencia and Sevilla, where you will find all the coffee, drinks, snacks and fruit you want. Come and enjoy all the activities we do, both inside and outside the office (hackathons, meetups, tech talks, code katas and much more!) 2539547 #LI-ED1

Risk AnalystAon is currently seeking a Risk Analyst to provide direct support to a client in West Palm Beach, FL. This is a hybrid position and the qualified candidate will be in close proximity to the office in that location.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.Responsibilities:Review contracts both domestic and international* Provide pending contracts list weekly to the Director of Risk Management* Provide daily and weekly update on activities* Contract review with copies saved in shared folder* Available to participate on calls with MSI contract legal and client to negotiate terms of insurance prior to contract execution* Ensure terms are negotiated and agreed to by all parties in timely manner for contracts to be executed and sales receives credit via internal processing to meet their monthly, quarterly and annual sales estimates.Ensure renewal listing is provided to Aon Client Services (ACS) Account Specialist by June 1st to ensure renewal COIs are issued and sent to all certificate holders prior to 7/1 renewal date.* Respond to all COIs within a 24-hour period* Provide weekly update on all COI issues* Save endorsement and COI client specific documents in shared folder* Ensure timeliness of completion as sales revenue depends on the acceptance of COI by client.Ensure renewal listing is provided to Aon ACS Account Specialist by June 1st to ensure renewal COIs are issued and sent to certificate holders prior to 7/1 renewal date.* Review renewal listing and make updates as necessary* Send listing to ACS Account Specialist* Follow up and obtain all renewal COIs prior to 7/1Review and purchase project specific policies or add to Reporter form policy for small projects* Obtain underwriting data and provide to broker/insurer* Provide quote and obtain authorization to bind from client project team* Obtain binder/policy/COI* Add to calendar for expiration dates and if any extensionsQualifications:Education* College degree, preferably with area of study in Business, Finance, or Risk Management* Advanced degree preferred* CRM, ARM or CPCU designationPrior Experience* Minimum five years in risk management field* Managerial experience* Safety, loss prevention, and claims training desirableSpecial Skills* Excellent oral and written communication skills* Strong interpersonal skills* Leadership abilities* Excellent administrative and organizational skills* Computer skills in Windows environment, working knowledge of Word, Excel, Access, Lotus Notes software, on-line data base systemsHow 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.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.Pay Transparency LawsThe salary range for this position (intended for U.S. applicants) is $80,000 to $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.The salary range reflected is based on a primary work location of West Palm Beach, FL. The actual salary may vary for applicants in a different 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.#LI-MB1#LI-HYBRID2544595

Posting Description: Technical Business Analyst Are you technical with a passion for helping the business exceed goals? Do you enjoy using your analytical skills to identify inefficiencies and solving them? If so, this could be a fit for you! This is a hybrid role out of our Fort Wayne, IN office. 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>Responsible for partnering with business/user group representatives to understand business processes and underlying informational and/or process automation needs.</li><li>Responsible for translating business needs into formal and clearly documented business requirements to be used for system design</li><li>Responsible for identifying requirement and scope related issues and risks</li><li>Liaison between business/user group representatives and system development personnel during development efforts.</li><li>Assist in developing and conducting testing plans and criteria</li><li>Assist with system support of developed applications through the unique combination of business and system analysis, quality assurance and post implementation product support</li><li>Update, test and troubleshoot documents & associated logic in response to customer requests and regulations.</li></ul>How this opportunity is different The Technical Business analyst is a part of a tenured team assisting various businesses migrate and integrate systems, finding inconsistencies, testing and solving while being a liason between the business and IT. Skills and experience that will lead to success<ul><li>Business knowledge of Insurance Underwriting, Policy Administration or Claims preferred.</li><li>Microsoft Office products knowledge, with proficiency in Microsoft Word and Excel.</li><li>Proficiency utilizing the SmartCOMM Next-Gen CCM tool and associated capabilities preferred.</li><li>Ability to utilize SmartCOMM s Advanced Template Designer & Template Editor preferred.</li><li>Working knowledge of SmartCOMM Data Modeler design and testing methods preferred.</li><li>Proven analytical skills and ability to identify & implement efficiencies</li><li>Demonstrated ability to work independently to meet project deadlines</li><li>Understanding of project management tools and techniques</li><li>Working knowledge of systems development life cycle and systems development methodologies</li></ul>Education: Bachelors degree in Computer Science, Information Technology (IT), comparable discipline preferred, or equivalent years of industry experience. Pay Transparency Laws The salary range for this position (intended for U.S. applicants) is $65,000 - $85,000. 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. 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; 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 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. 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 <a href="mailto:ReasonableAccommodations@Aon.com" target="_blank" rel="noopener">ReasonableAccommodations@Aon.com</a> Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.#LI-TJ1 #LI-HYBRID

Descripcin de la publicacin: WHO WE ARE At CoverWallet we are determined to revolutionize the insurance industry! We launched in 2015 and since then we are the leading digital platform for contracting insurance for small and medium-sized companies. Thanks to state-of-the-art technology and meticulous design we have turned insurance management and processing into a simple, fast and convenient process for our clients. All online, in minutes! Our passion is in delivering innovation and value creation through technology, and our mission is to become the worlds leading InsurTech. For this, we have built an incredible team of ~800 people based in New York, Spain, Poland and Singapore. Success is guaranteed as we are part of Aon, the global leaders in risk, retirement and health solutions with 50,000 colleagues worldwide. We combine the mindset and culture of a high-growth startup with the backing and support of a global multinational. The best of both worlds in one company - what more could we ask for? WHAT YOU WILL DO We're looking for an awesome Site Reliability Engineer and DevOps practitioner, to be part of the Engineering team and help us with the security, stability and scalability of our multi-site platform while being and operational enabler for the rest of the organization. A TYPICAL DAY <ul style="margin-top: 0; margin-bottom: 0;"><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Implement and maintain a metrics collection, log management and service health check systems.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Systems design consulting, infrastructure capacity planning and cost efficiency exercises.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Triage and troubleshoot production issues enriching feedback loops to other engineering teams with blameless postmortems.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Enable fast and reliable configuration changes and deployments to Engineering and Product teams.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Implement artifacts lifecycle policies and CI/CD Pipelines.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Maintain, customize and/or develop operational tooling that brings velocity to the engineering team.</li></ul><h2 style="margin-top: 0pt; margin-bottom: 0pt;"> </h2><h2 style="margin-top: 0pt; margin-bottom: 0pt;">WHAT YOU NEED TO SUCCEED</h2> <ul style="margin-top: 0; margin-bottom: 0;"><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">5+ years working in infrastructure and software engineering environments.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Problem solving enthusiast and technical deep diver.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Experienced engineer used to write software to solve problems.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Experienced engineer on systems bottlenecks analysis and scalability issues resolution.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Open contributor, collaborator and team player.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Computer Science fundamentals skillful: OS, Networking and Storage.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Experienced engineer on platform enforcement and service protection against external attacks.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">English proficiency is a must.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Experience with Ruby and/or Javascript is a plus.</li></ul>OTHER VALUABLE TECHIE EXPERIENCES <ul style="margin-top: 0; margin-bottom: 0;"><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Blue-green deployment and A/B testing.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Cloud-native development and serverless approach.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Infrastructure as Code.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Security as a first class citizen (DevSecOps).</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Microservices architecture.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Measure everything and data-driven decisions.</li></ul> ABOUT THE RECRUITMENT PROCESS <ul style="margin-top: 0; margin-bottom: 0;"><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Your first contact with CoverWallet will be through an HR interview with one of our colleagues from the Talent Acquisition area, who will tell you everything about our company and its history, as well as the details of the position, functions and your future conditions. We would love to know your professional and academic career, and of course, your motivations and expectations for a new professional project. We will be happy to answer all your questions!</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Do we have a match? Lets move on to your First Technical Interview! You will meet two of your future colleagues from the SRE area, who will explain to you in more detail what the team's day-to-day life is and its responsibilities. They will be very interested in expanding information about your experience in infrastructure and systems, both from a corporate and application point of view, as well as your programming skills.</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">If everything has gone well and you have impressed our colleagues... we advance to the Second Technical Interview! In line with the previous one, you will meet two other members of the SRE team, who will continue to deepen your knowledge at the level of methodologies, roles and previous projects, as well as in relation to your background in our reference technological environments (cloud, containers, Kubernetes, etc.)</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">If you've made it this far, things are getting interesting... It's time for your Final Interview! In this case, you will have the opportunity to meet one of our VP of Engineering, who will close the selection process with an interview aimed at getting to know you not only on a professional and technical level, but also on a personal level, so that both of you can reach the conclusion of whether the purpose of our project fits with your professional aspirations.</li></ul> WHY COVERWALLET At CoverWallet you will have the opportunity to be a key player in the transformation of one of the largest industries and in one of the most developed digital markets in the world. You will work in a cutting-edge tech environment, alongside a super powerful and diverse global team. Join us and build your own career plan in one of the world's leading companies, tailored to your dreams and aspirations! And just for good measure <ul style="margin-top: 0; margin-bottom: 0;"><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Competitive salary based on your background and experience, and a variable annual bonus set according to your goals</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Enjoy flexible working hours and find out your ideal way of working thanks to our smart work model: full remote or hybrid, its up to you!</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Perks package consisting of a Company-paid Life, Accident Insurance and Medical Cover with free dental care. Complement your benefits with our flexible compensation plan (tickets restaurant, transport card, daycare checks, external training and even a Pension Scheme!)</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Carry on with your training thanks to your additional budget of 1,500 per year to finance training courses, certifications, books or any teaching aids that will help you continue to grow professionally</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">Enjoy a lot of offers and save on your purchases thanks to our discount platform (BigPocket) on your favorite brands (travel, fashion, technology, leisure...)</li><li style="font-size: 9pt; font-family: Arial,sans-serif; color: #000000; font-weight: 400;" aria-level="1">23 paid vacation days per year, plus 2 additional personal days and 2 wellbeing days to focus on your own health and prioritize self-care :)</li></ul>Great offices in Madrid, Valencia and Sevilla, where you will find all the coffee, drinks, snacks and fruit you want. Come and enjoy all the activities we do, both inside and outside the office (hackathons, meetups, tech talks, code katas and much more!) 2539547#LI-ED1

About Us: CoverWallet is Aon's digital platform for Small Commercial & Middle Market institutions, responsible for distributing insurance solutions to commercial businesses and individuals through an innovative, data-led, digital model that demonstrates Aon's product capabilities, relationships and global scale. Aon is the leading global professional services firm providing a broad range of risk, retirement and health solutions with 50,000 colleagues in 120 countries. CoverWallet is the cornerstone of Aon Digital Client Solutions, founded in 2015 to reinvent the $100 billion small commercial insurance industry by using data, design, and technology. 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 Within Aon, the CoverWallet digital platform is transforming the insurance industry by connecting Clients with Insurance Markets and Capabilities in a digital-first way. The Lead Product Manager, Digital Insurance Platform role will lead a material part of our platform focused on scaling our capabilities and driving customer satisfaction. Our InsurTech platform provides both B2B and B2B2B solutions at a global scale through first-party, strategic partners, and private-labeled solutions. We are looking for an experienced product manager who can work collaboratively across the organization, including with senior leaders in Product, Engineering, Operations, Sales and Business Development teams, and with our customers. You will set strategy to achieve our vision, drive a feasible and valuable roadmap, and deliver results that impact our customer segments in measurable ways. You have experience driving digital solutions that generate value at scale, and will work with a cross-functional team of many in Engineering and other key disciplines. Growth in people management is possible over time with strong performance. The ideal candidate should have an understand of the digital insurance landscape, or a deep mastery of a related industry, as well as demonstrate competency in digital product management and leadership. A candidate who is able to balance the trade-off between long-term strategy and near-term value creation is sought. The candidate must have excellent communication skills and the ability to demonstrate experience managing cross-functional stakeholders with a variety of perspectives in a fast-paced environment. How this opportunity is different You'll work as part of an elite organization in a fast-paced environment, managing large-scale initiatives that have broad reach, improve our customer's experience, and impact operational teams across the organization. You will work in a highly collaborative environment. We are a fast-paced, growing firm that is the perfect place for a goal-oriented, hardworking individual who is looking to make a difference. We expect growth over the next few years, which means you can expect plenty of opportunities for advancement. Skills and experience that will lead to success <ul> <li>Define the product strategy and roadmap, and lead the cross-functional product teams responsible for one or multiple areas of our digital platform </li></ul> <ul><li>Manage digital products or services end to end including conception, launch, and scale in coordination with cross-functional teams </li></ul> <ul><li>Conduct strategic analyses, customer/competitor research, and market sizing </li><li>Own customer discovery and continuous evaluation of product-market fit </li><li>Collect, analyze and synthesize both quantitative and qualitative user data including using artificial intelligence and machine learning models where appropriate </li><li>Develop, test and launch new products and features </li><li>Analyze and manage product performance to meet company goals and targets </li></ul> <ul><li>Communicate clearly among the various stakeholders and manage their expectations </li></ul> <ul><li>Work closely with designers, engineers, operations, sales, marketing, and business teams to ship high quality, user-centric products and features </li></ul> Professional: <ul> <li>6+ years of experience in product management or related discipline </li><li>Experience with InsurTech or FinTech platforms and components is a plus </li><li>Has led a high-performing cross-functional product team and experience mentoring/coaching others on core product management skills </li><li>Ability to think strategically and a demonstrated ability to manage multiple, competing priorities simultaneously </li><li>Demonstrated success in defining, building and launching full-scale digital products that had a positive business impact </li><li>Driven product decisions that materially and quantifiably drove the business forward through deep understanding & analysis of business metrics </li><li>Strong analytical skills and deep experience with data tools to measure business performance and product adoption </li><li>Willingness to roll up your sleeves and get things done </li><li>Strong consensus and relationship-building skills </li><li>Proven ability to influence cross-functional teams without formal authority </li><li>Comfortable working in a fast-paced and dynamic environment </li><li>Outstanding communication skills across all medium (presentations, stories, verbal) </li></ul> Education: <ul> <li>Bachelor's degree. Master's or other advanced degree /certification welcomed </li><li>Field of study in a relevant aspect of digital technology including software development, computer or systems engineering, artificial intelligence, machine learning, entrepreneurship, or related. </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. 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 $140,000 to $160,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. 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 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-CC2 #LI-HYBRID 2547040

Aon Data Analyst Interview Guide

Overview

Aon Data Analyst Salary

Aon Data Analyst Interview Process

Aon Data Analyst Interview Questions

Aon Data Analyst Jobs