Health Solutions Consultant - Financial Manager

Aon Corporation • Salt Lake City, UT

4d • Hybrid

About The Position

As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting Health Analytics. This role will assist the lead actuary and consultants on assigned large accounts and manage/lead smaller actuarial engagements.

Requirements

• Four plus years of health and benefits underwriting or data analyst experience, preferably in a carrier or consulting environment.
• Advanced level proficiency with Microsoft Office, especially MS Excel and MS PowerPoint.
• Bachelor’s Degree in relevant discipline or equivalent experience

Nice To Haves

• Knowledge of MS Access, SQL a plus.

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 impact modeling, plan changes, self-funded vs. fully insured analysis, etc.)
• Develop executive summary on all key financial components of marketing and provide recommendations
• Review financial caveats, deviations and other notes in proposals, add appropriate 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

Benefits

• 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
• 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
• an employee assistance program that includes free counseling sessions

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level