Data Analyst - Internal Audit 5/18/2018

Aon Chicago, IL

Chicago, IL
AJE Ref #
Job Classification
Full Time
Job Type
Company Ref #
Entry Level (0 - 2 years)
Bachelors Degree


Job Family US-IL-Chicago


Aon is looking for a Data Analyst - Internal Audit

Overview of Internal Audit Department:

Aon's Global Internal Audit Department reports directly to Audit Committee of Aon Corporation s Board of Directors. The global department has approximately 76 team members located in Chicago, London, Amsterdam, and Hong Kong and performs reviews in over 100 countries in all business lines. The department s primary mission is to evaluate the adequacy of Aon s internal control environment and to assess compliance with corporate policy and designated laws and regulations.

Position Summary:

This exciting position will impact the overall success of the Internal Audit Global Data Analytics Program through the development of innovative and advanced data analytics and visual reporting, building and maintaining effective processes around the analytics program, translating risk focused initiatives into advanced analytics that will serve to improve and optimize the departmental strategic initiative. This role also oversees and performs the data discovery, collection, and acquisition procedures, documents and maintains the library of analytics, and integrates analytics into the current process and designs analytic-enabled testing programs. This is a highly visible position collaborating across Aon with both technical leaders and business stakeholders.

Ideal Candidate:

The ideal candidate will have an ability to innovate, collaborate, and comfortable with ambiguity and working in uncharted territory. Have a deep interest in combining data science, business concepts, and technology. Have an analytical mindset, exceptional analytical and problem-solving skills.

This progressive individual will engage cross functionally with global teams, internal leadership, and external resources; to facilitate understanding and access to data necessary to achieve data analytics objectives. This is a highly visible position requiring excellent visual reporting, written and verbal communication skills and the experience and ability to manage multiple projects simultaneously in a matrix environment.

Key Responsibilities:

* This role represents a critical component to our growth strategy and is where much of the innovative early thinking takes place on fraud detection and other data driven risk analytics projects

* You will have an opportunity to apply your expertise in an innovative way and be part of our exciting growing team

* You will collect requirements and design advanced analytics ranging from descriptive to predictive models, machine learning techniques and further AI and RPA

* You will function as a subject matter expert in our global audit projects reviewing areas where advanced analytics, machine learning, AI and RPA are utilized

* You will monitor incoming data analytics request, execution of analytics as requested, and distribution of the results in an efficient and effective manner

* Plan and moderate the periodic data analytics champions meetings and communicate required information with the team

* Develop, implement, support, and maintain data analytics protocols, standards, and documentation

* As part of the analytics services, analyze complex data, identify anomalies, trends, risks, and provide useable insight to improve internal controls.

* Prepare documentation and analytic dashboards/reports that effectively and efficiently provide summarized results, analysis, conclusions to stakeholders, with supporting details readily available.

* Address ad-hoc analytics requests and facilitate needed data acquisition, as needed, to support internal projects, special projects, and investigations.

* Contribute to internal activities for overall process improvement, efficiencies, and innovation

* Communicate the data requirements and ensure the global team receives access to the source information needed, understanding of the data relationships to the business processes.

* Assist global teams with the use of inquiry of key systems to facilitate understanding of data in the business process.

* Participate in department technology leadership work streams on support, knowledge management processes and use of tools.

* Prepare written summaries to accompany results and maintain documentation

* Able to understand business requirement and communicate effectively with business stakeholders

* Clearly explain what the data and results indicates and how it can be utilized to support the project objectives

Skills Required:

The role requires a mixture of multidisciplinary skills ranging from an intersection of data science, communication and business acumen. The key skills required for this position are:

Data Science and Data Analytics

* Experience in gathering, cleaning and analyzing large sets of data

* 2+ years of experience in database management systems such as SQL, Oracle, or other RDMS

* Minimum one year of experience with analytics/statistical software language such as R, Python, or others
* Significant experience in gathering, cleaning, and analyzing large sets of data (1TB)

* Sound knowledge of data management and data privacy concepts

* Exposure to cloud ERP systems such as Workday Finance is a plus

* ETL and exposure to multiple cloud and hybrid application connection methodologies is a plus

* Statistical computing package e.g. SAS, SPSS and others is a plus

Business Acumen

* Minimum 2+ years' of experience working in Data Analytics with a business teams such as Internal Finance, Audit, IT and or similar environment

* Ability to learn, adopt, and apply Aon business/concepts in short amount of time

* Develop analytics solution using your technical and business domain knowledge

Visualization & Reporting

* Experience with QlikView/QlikSense, Tableau or alternative data visualization packages

* Ability to visualize the analytics results in effective manner

* Have an artistic approach when creating dashboards and reports

* Able to collect, analyze requirements from global teams and develop visualization and reporting

Communication & Presentation

* Strong communication skills and a desire to work in a team environment

* Experience communicating technical concepts to a non-technical audience

* Excellent verbal and written communication skills

* Strong organizational and multi-tasking skills

Work Experience:

2+ years of data analytics experience with a professional services firm, business facing teams finance/internal audit/analytics group, or similar environment.

Professional Education:

BA or BS in management information systems, computer science, finance, business, operations management, statistics, engineering, or related field required. Certification in visualization software(s) is a plus. Advanced degree in above areas is a plus.

Aon provides equal employment opportunities (EEO) 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, or domestic partner status. Aon is committed to a diverse workforce and is an affirmative action employer.


Aon plc (NYSE:Aon) is a leading global professional services firm providing a broad range of risk, retirement and health solutions. Our 50,000 colleagues in 120 countries empower results for clients by using proprietary data and analytics to deliver insights that reduce volatility and improve performance.

Company Size:
50,000+ Employees
Financial Services
Social Media:
200 East Randolph
Chicago, IL 60601

View Larger Map