Director

Aon Corporation; Norwalk (CT); Hybrid; USD 175,781 - 228,250; Full time

Benefits offered by this job

401(k) plan

Employee stock purchase plan

Medical, dental, vision insurance

12 paid holidays per year

Job summary

Aon Corporation in Norwalk, CT is seeking a Director to lead data analytics for investment banking and investor services clients. You will manage compensation data collection, cleaning, review, and finalization, and generate market benchmarking reports.

Responsibilities include client relationship support, training on data platforms, and building insights from equity and compensation data. Proficiency in Excel VBA, Tableau, SQL, and Access is required, with a focus on productivity and accuracy.

Qualifications

• Bachelor’s degree in Data Science, Economics, Finance, or related field.
• 5 years of progressive data analysis experience.
• Experience in compensation data collection, review, and finalization.
• Experience with Excel VBA, Tableau and SQL.
• Experience storing and automating data in Access database.

Responsibilities

• Analyze data for investment banking and investor services businesses.
• Complete product cycles including compensation data collection and finalization.
• Generate market benchmarking reports and provide qualitative insights.
• Support client relationships and respond to compensation-related questions.
• Develop processes to increase productivity using Excel VBA, Tableau, and SQL.

Skills

Data analysis

Excel VBA

Tableau

SQL

Microsoft Access

Education

Bachelor's degree in Data Science, Economics, Finance, or related field

Tools

Excel VBA

Tableau

SQL

Microsoft Access

Job description

Job Title: Director

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

McLagan Partners, Inc. seeks a Director in Norwalk, Connecticut to analyze data. Complete product cycles for investment banking and investor services businesses, including compensation data collection from clients, compensation data review and cleaning, and compensation data finalization. Generate market benchmarking reports. Support day-to-day relationships with investment banking clients (including boutique and middle market IBs) and Securities Services clients (including Custodian Banks and fund servicing firms) by answering compensation and industry-related questions, negotiating contracts, and offering the latest trends within the industry. Provide up-to-date trainings and demos on how to use data analytics platforms for report generation and report consumption. Conduct executive benchmarking, salary banding, job architecture, grade pyramid, sales incentive plan review, productivity report, industry pay practice, long-term incentive plan review, and peer group analysis. Build report templates, examine data output, and build and refine commentary to provide qualitative insights. Update financial benchmarks on a quarterly basis to keep internal teams updated with clients’ latest financial data and performance. Assist regional teams and non-Financial Services sector leaders to prepare conference materials and meetings with clients’ compensation committee or management committee by providing financial statistics. Research existing and emerging trends for investment banking and investor services businesses. Build marketing materials to show business capacities and product offerings. Prepare and support Human Capitol and Total Rewards RFPs for bidding businesses. Develop processes to increase productivity and efficiencies using Excel VBA, Tableau, and SQL. Analyze datasets related to both compensation and financial general ledger extracts. Store and automate data using Microsoft Access database. Local telecommuting available up to 3 days per week. Annual Salary: $175,781 - $228,250.

Job Location: 800 Connecticut Avenue, 3rd Floor, Norwalk, CT 06854

Skills and experience that will lead to success

Bachelor’s degree in Data Science, Economics, Finance, or a related field, plus five years of progressive data analysis experience. Must have at least two years of experience in each of the following: 1. Completing product cycles for investment banking and investor services businesses, including compensation data collection from clients, compensation data review and cleaning, and compensation data finalization; 2. Conducting executive benchmarking, salary banding, job architecture, grade pyramid, sales incentive plan review, productivity report, industry pay practice, long-term incentive plan review, and peer group analysis; 3. Preparing and supporting Human Capitol and Total Rewards RFPs; 4. Using Excel VBA, Tableau, and SQL; 5. Analyzing datasets related to both compensation and financial general ledger extracts; and 6. Storing and automating data using Microsoft Access database.

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 [e-mail]

Salary range or hourly pay range for the position

Thesalary range for this position is $175,781 - $228,250 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.