Actuarial Analyst

As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions as part of our Health and Benefits business group within Aon.

Job Responsibilities:

• Be responsible for all financial activities for assigned clients
• Prepare regular (monthly or quarterly) financial reporting packages for clients, leveraging existing templates
• Assist in collecting and completing input for various financial models such as Incurred But Not Reported Claims model, Actuarial Value Plan Model and Pricing Models
• Analyze ad hoc data using advanced functions in Excel and effectively communicate findings with both internal client team and stakeholders at the client
• Conduct ad-hoc projects as needed using appropriate resources (Health Care Reform impactmodeling, plan changes, self-funded vs. fully insured analysis, etc.)
• Develop executive summary on all key financial components of marketing andprovide recommendations
• Review financial caveats, deviations and other notes in proposals, addappropriate notes to the client RFP results presentation
• Review insurance carrier renewal calculations for medical, dental, vision, life and disability and identify areas for negotiation
• Collect and submit needed financial data for benchmarking projects
• Prepare client budget and contribution scenarios
• Maintain and manage open items lists to ensure each clientreceives the agreed upon deliverables
• Prepare and present in meetings both internal and client facing
• Provide cost estimates for Healthcare Reform expected fees or upcoming taxes
• Assist in new business sales opportunities as needed

Required Experience:

• One+ years of health and benefits underwriting or data analyst experience, preferably in a carrier or consulting environment. More experience is preferred.
• Advanced level proficiency with Microsoft Office, especially MS Excel and MS PowerPoint. Knowledge of MS Access, SQL a plus.
• Strong project management experience
• Self-starter who can work well in a fast-paced, team environment

Education:

• Bachelor’s Degree in relevant discipline or equivalent experience

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.