Health Solutions Consultant - Financial Manager

Health Solutions Consultant- Financial Manager Locations: Denver Co, Salt Lake City UT What The Day Will Look Like 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 How This Role Is different: 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. Skills and Expertise That Will Lead to Success: 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. Knowledge of MS Access, SQL a plus. Bachelor’s Degree in relevant discipline or equivalent experience For positions in San Francisco and Los Angeles, we will consider for employment qualified applicants with arrest and conviction record in accordance with local Fair Chance ordinances. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Pay Transparency Laws: The salary range for this position (intended for U.S. applicants) is $95,000-$110,000 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant’s geographic location. This position is eligible to participate in one of Aon’s annual incentive plans to receive [an annual discretionary bonus] in addition to base salary. The amount of any [bonus] varies and is subject to the terms and conditions of the applicable incentive plan. A summary of all the benefits offered for this 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. #J-18808-Ljbffr Aon Corporation