FP&A Reporting and Automation Analyst

This position is part of the ARS Management Reporting group which mainly supports US Retail Finance teams through data analysis, process improvement and decision support solutions. The analyst will be responsible for performing financial data analysis and reporting tasks which, at times, will require developing automated processes to extract, transform, load, compile, analyze, and distribute data/reports in accordance with business needs. The analyst will assist in maintaining data repository processes to support daily, weekly, monthly, quarterly, and annual reports using a variety of reporting tools.

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

The position requires an ability to approach issues from a Finance standpoint while using technical skills to plan and accomplish projects and tasks such as:

• Revenue Variance Reporting

• AR/AP Reporting

• Expense Reporting

• Accruals calculations (revenue & expense)

• Client Profitability Initiatives

• Cash Flow & Scorecard

  Skills and experience that will lead to success

  Required skills:

• Intermediate to advanced level of Visual Basic for Applications (VBA)

• Intermediate to advanced level of Structured Query Language (SQL)

• Finance and accounting knowledge

• Advanced knowledge of Microsoft Office Suite (Excel, Access, etc)

• Spotless record & strong ethos

  Desired skills:

• BI tools exposure (PowerBI, PowerAutomate)

• Excellent analytical and communication skills

• Business requirement gathering

• Capable of working on projects with aggressive schedules

• Relational database concepts

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

  We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on ReasonableAdjustments@Aon.com

  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.

  NB. Dependant on regional requirements, please include specific benefits where applicable and relevant accommodation criteria and enhanced equal opportunities statement.

  #LI-Hybrid#LI-Financeoperations

  2543303 FP&A Reporting and Automation Analyst

  This position is part of the ARS Management Reporting group which mainly supports US Retail Finance teams through data analysis, process improvement and decision support solutions. The analyst will be responsible for performing financial data analysis and reporting tasks which, at times, will require developing automated processes to extract, transform, load, compile, analyze, and distribute data/reports in accordance with business needs. The analyst will assist in maintaining data repository processes to support daily, weekly, monthly, quarterly, and annual reports using a variety of reporting tools.

  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

  The position requires an ability to approach issues from a Finance standpoint while using technical skills to plan and accomplish projects and tasks such as:

• Revenue Variance Reporting

• AR/AP Reporting

• Expense Reporting

• Accruals calculations (revenue & expense)

• Client Profitability Initiatives

• Cash Flow & Scorecard

  Skills and experience that will lead to success

  Required skills:

• Intermediate to advanced level of Visual Basic for Applications (VBA)

• Intermediate to advanced level of Structured Query Language (SQL)

• Finance and accounting knowledge

• Advanced knowledge of Microsoft Office Suite (Excel, Access, etc)

• Spotless record & strong ethos

  Desired skills:

• BI tools exposure (PowerBI, PowerAutomate)

• Excellent analytical and communication skills

• Business requirement gathering

• Capable of working on projects with aggressive schedules

• Relational database concepts

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

  We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on ReasonableAdjustments@Aon.com

  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.

  NB. Dependant on regional requirements, please include specific benefits where applicable and relevant accommodation criteria and enhanced equal opportunities statement.

  #LI-Hybrid#LI-Financeoperations