Analytics and Reporting Analyst

Job description

Aon is hiring for an Analystics and Reporting Analyst.



This hybrid position is based out of our Alpharetta, Georgia 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:

+ Writes, deploys, and maintains complex queries and stored procedures with SQL experience to support both internal and client delivery of reporting as well as analytical support and data requests.



+ Initiate analyses to determine the cause of trends that vary materially from anticipated results sharing conclusions with and recommendations with the client and internal team.



+ Creates/updates programming reporting data to a final delivery form through the use of Excel, Access, or other acceptable forms to create customer client reporting.



+ Coordinates the gathering of client data from functional areas for review and input into client reports as assigned Delivers custom reporting to clients on a timely basis through emails, ftp sites, etc.



+ Reviews and assesses data being reported, alerting team members of any issues or trends that should be acted upon.



+ Maintain accuracy for reporting tables provided by IT and provide IT requirements/direction when needed.

Understanding the impacts and proactively alerting internal customers and clients regarding issues and delays is entailed as well.

This position would oversee the automation of processes within the department as well.



+ Writes or otherwise communicates (email, PowerPoint) persuasively to client, and others to help explain analysis and/or program recommendations based on the data trends.

Attends to details with excellent written and verbal communication skills, extreme detail focus to avoid re-work and errors, and 100% follow-through on outstanding items.



+ Documents and maintains our records of report development work and communicates process to AIM team members and clients.

Publishes an inventory of reports and other contact points periodically.



+ Maintains reference tables in support of accurate client reporting.



+ Plans and prepares for new clients, new programs, and new reports occurring in the day-to-day process by working together with those providing data and developing the new reports and gaining a working knowledge of the new reports.



+ Maintains a work structure and records to enable extensive multi-tasking while keeping track of deliverables owed and deadlines.

Re-prioritizes tasks as required to accomplish each day's work.



+ Maintains good working relations with client contacts, key members of the Aon team and external resources.



+ Manages completion of specific reporting requests/tactics as assigned by VP.



Skills and experience that will lead to success:

+ 5-7 years of Financial Analysis experience

+ Expert level SQL experience is required- candidates will be tested on-site for SQL proficiency

+ Knowledge of Power BI is desired

+ Knowledge of call center fundamentals and reporting is desired

Education:

+ Bachelor’s degree or equivalent years of industry experience

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.


The salary range for this position (intended for U.S. applicants) is $78,200 to $100,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 p rogram that includes free counseling sessions.

Eligibility for benefits is governed by the applicable plan documents and policies.





#LI-KH2

#LI-HYBRID


2553887
Aon is hiring for an Analystics and Reporting Analyst.



This hybrid position is based out of our Alpharetta, Georgia 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:

+ Writes, deploys, and maintains complex queries and stored procedures with SQL experience to support both internal and client delivery of reporting as well as analytical support and data requests.



+ Initiate analyses to determine the cause of trends that vary materially from anticipated results sharing conclusions with and recommendations with the client and internal team.



+ Creates/updates programming reporting data to a final delivery form through the use of Excel, Access, or other acceptable forms to create customer client reporting.



+ Coordinates the gathering of client data from functional areas for review and input into client reports as assigned Delivers custom reporting to clients on a timely basis through emails, ftp sites, etc.



+ Reviews and assesses data being reported, alerting team members of any issues or trends that should be acted upon.



+ Maintain accuracy for reporting tables provided by IT and provide IT requirements/direction when needed.

Understanding the impacts and proactively alerting internal customers and clients regarding issues and delays is entailed as well.

This position would oversee the automation of processes within the department as well.



+ Writes or otherwise communicates (email, PowerPoint) persuasively to client, and others to help explain analysis and/or program recommendations based on the data trends.

Attends to details with excellent written and verbal communication skills, extreme detail focus to avoid re-work and errors, and 100% follow-through on outstanding items.



+ Documents and maintains our records of report development work and communicates process to AIM team members and clients.

Publishes an inventory of reports and other contact points periodically.



+ Maintains reference tables in support of accurate client reporting.



+ Plans and prepares for new clients, new programs, and new reports occurring in the day-to-day process by working together with those providing data and developing the new reports and gaining a working knowledge of the new reports.



+ Maintains a work structure and records to enable extensive multi-tasking while keeping track of deliverables owed and deadlines.

Re-prioritizes tasks as required to accomplish each day's work.



+ Maintains good working relations with client contacts, key members of the Aon team and external resources.



+ Manages completion of specific reporting requests/tactics as assigned by VP.



Skills and experience that will lead to success:

+ 5-7 years of Financial Analysis experience

+ Expert level SQL experience is required- candidates will be tested on-site for SQL proficiency

+ Knowledge of Power BI is desired

+ Knowledge of call center fundamentals and reporting is desired

Education:

+ Bachelor’s degree or equivalent years of industry experience

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.


The salary range for this position (intended for U.S. applicants) is $78,200 to $100,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 p rogram that includes free counseling sessions.

Eligibility for benefits is governed by the applicable plan documents and policies.





#LI-KH2

#LI-HYBRID

Required Skill Profession

Other General