Job Title: U.S. Data Analytics - Professional 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 Aon Risk Consultants, Inc. seeks a U.S. Data Analytics - Professional based out of headquarters in Chicago, Illinois to analyze data. Identify business trends with data analytics. Build and refine data collection methods as well as outputs and analytics. Utilize and manipulate large sets of data to determine relevant indicators that can be leveraged into trend and insight reports. Build and maintain reports and dashboards using data visualization software including Power BI and Tableau. Analyze, organize, and visualize data using database management concepts and database structures; Excel, Access, and VBA; and programming languages including SQL and Tableau. Develop technology and data analytics solutions using knowledge of the software development lifecycle. Configure cloud-based data platforms and solve technology challenges. Define and validate KPI and business metrics. Identify and implement automation processes to reduce costs and improve operational efficiency. Interpret business needs and translate into functional and non-functional business requirements. Define and validate KPI and business metrics. Build database systems using relational databases and SQL. Gather, aggregate, clean, and validate data from multiple sources using ETL processes and Microsoft Excel. May work from home 5 days per week. Annual salary: $93,974 - $150,400. Job Location: 200 E. Randolph Street, Chicago, IL 60601 Skills and experience that will lead to success Master’s degree in Information Management, Information Technology, or a related field plus one year of data analysis experience. Must have at least one year of experience in each of the following: 1. Identifying business trends with data analytics; 2. Building and maintaining reports and dashboards using data visualization software including Power BI and Tableau; 3. Configuring cloud-based data platforms; 4. Identifying and implementing automation processes; 5. Building database systems using relational databases and SQL; and 6. Gathering, aggregating, cleaning, and validating data from multiple sources using ETL processes and Microsoft Excel. 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 (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, domestic partner status, or other legally protected status. Aon is committed to a diverse workforce and is an affirmative action employer. People with criminal histories are encouraged to apply. 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 Salary range or hourly pay range for the position The salary range for this position is $93,974 - $150,400 annually. 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. How to Apply To apply, please send resume to aonresumes@aon.com and cite requisition number 00633, apply at jobs.aon.com, or click the apply button. This notice is subject to Aon Risk Consultants, Inc.'s employee referral program. 2025-85337