Data Solutions Consultant

Overview

Aon is looking for a Consultant - Compensation, Data Solutions. Aon is looking to welcome a data-driven consultant to support our Data Solutions team, focusing on clients in the technology and life sciences sectors. This role is ideal for someone who excels in managing complex datasets, ensuring data quality, and translating insights into meaningful advisory support for executive compensation and organizational design.

Strong candidates will be able to demonstrate a keen interest in rewards by working with compensation survey products and data, sharing stories of project managing client engagements, and building and championing strong client relationships. Preferred locations for the role include San Francisco / Santa Clara, or Boston, or New York / Norwalk.

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 team and we are passionate about helping our colleagues and clients succeed.

Duties and Responsibilities:

In this role, you will:

• Data Management & Quality Assurance:
  Ingest, clean, and validate large datasets related to executive compensation and organizational structures. Ensure data integrity across multiple client segments, including emerging tech, biotech, and global life sciences firms. Align client data with public filings and industry benchmarks to support high-quality deliverables.
• Industry-Focused Analysis:
  Develop a working understanding of compensation trends and organizational structures in tech and life sciences. Apply industry knowledge to contextualize data and identify meaningful insights for clients. Support benchmarking and analytics projects with a focus on relevance and accuracy for sector-specific needs.
• Advisory Support &
  
  Collaboration:
  
  Partner with consultants and stakeholders to deliver timely and impactful executive benchmarking and organizational consulting (OC) engagements. Standardize templates and processes to improve efficiency and scalability across clients. Collaborate with cross-functional teams (operations, offshore, tech, business) to ensure smooth data flow and issue resolution.
• Process Improvement & Innovation:
  Identify systemic data issues and propose solutions to improve quality and efficiency. Contribute to the development of tools and templates that enhance data analysis and reporting. Support training and documentation efforts to scale best practices across the team.

Qualifications:

• 5+ years of experience in data analytics, compensation consulting, or related fields.
• Strong proficiency in Excel and data management tools; experience with SQL, Python, or R is a plus.
• Ability to work with large, complex datasets and ensure data accuracy.
• Familiarity with executive compensation structures and public company disclosures.
• General understanding of the tech and life sciences industries, including organizational and compensation trends.
• Strong communication skills, especially in presenting data to internal and external stakeholders.

What We Offer

• Opportunity to work with leading tech and life sciences firms.
• A collaborative, high-performing team environment.
• Exposure to strategic projects that shape client talent and rewards strategies.
• Professional development and growth opportunities.

Preferred Experience

• 5+ years of experience in compensation, total rewards, or other related areas of human resources preferred.
• 2+ years of experience in project management preferred.
• Data management skills, process orientation, and attention to detail are critical.
• Strong analytical skills (both qualitative and quantitative).
• Able to work under tight deadlines while prioritizing multiple tasks.
• Excellent written and oral communication skills, with the ability to work in a collaborative, team-oriented environment.
• Proficiency in Microsoft Excel, Word, and PowerPoint.

Education

• Bachelor’s degree in related subjects (Business, Finance, Human Resources).

Equal Opportunity & Benefits

We offer a comprehensive benefits package for full-time and regular part-time colleagues, including, but not limited to: a 401(k) plan with employer…