Associate Consultant - Data Analytics

Job Summary: The Associate Consultant will report report directly to Conner Strong’s Chief Actuary and is responsible for performing detailed consultative reviews of the health and welfare plans for existing clients. This Data Analytics team supports the client facing consulting teams in performing the analytical services noted throughout.

Principal Responsibilities

• Provide support to the Consultants teams by providing periodic benefits and cost analysis of our existing clients’ health and welfare plans with primary focus on medical, pharmacy, dental, life and disability on both fully insured and self-funded accounts.
• Perform financial analysis for all coverages, examining both overall cost and benefit structures, various plan design and contribution modeling on both fully insured and self-funded accounts.
• Develop budget forecasting followed by detailed recommendations and corrective action steps for existing Fully Insured Accounts clients. Ability to compare to a Fully Insured to a Self-funded model for comparative purposes with the guidance of the Data Team manager.
• Knowledge of the carrier claims reporting process as it relates to content and accuracy.
• Maintenance of an assigned book of business.
• Ability to manage both internal and external client deadlines.
• Ability to develop custom financial modelling at the client’s request and/or the ability to incorporate a “non standard “ request using our existing tools
• Attend client meetings/conference calls at the request of the Consultant.
• Work with Data Team Manager and Consultant teams to analyze and negotiate Fully Insured rate renewals. Prepare recommendations and presentations to support the RFQ/RFP process for renewal business.
• Provide support for our cost modeling projects using the Data Analytics tools available including BeneFuture, Beneview and the various Data Warehouse utilities in place today.
• Identify process improvements when possible
• Remain current on industry trends and information, new product information, legislation, regulatory requirements, coverage’s, compliance and technology; communicate changes and address issues with clients on a proactive basis.
  
  

Requirements

• Bachelor’s degree and/or equivalent business experience required.
• Minimum 5 plus years of experience working in the Broker/Consulting Analytics field; preferably in an underwriting and/or consulting role.
• Strong working knowledge in plan design, funding, underwriting, and related compliance issues impacting health and welfare plans.
• Experience in plan cost analysis, claim analysis and reconciliation and evaluation of financials.
• Demonstrated knowledge of both self-insured and fully insured plans and both private and public sector clients.
• Strong written and verbal communication skills, presentation skills, critical thinking and problem solving skills.
• Ability to make verbal in person presentations to internal staff and prospects/clients.
• Ability to work independently on projects and in a consultative team environment.
• Advanced proficiency in Microsoft Excel including financial modeling and underwriting analysis.
• Proficiency in the Microsoft Office products including PowerPoint, Access and Word.
• Authorized to work in the United States on a full-time basis without Company sponsorship.
  
  

Specialized Knowledge or Licenses

• Health and Life license required.
• Related designations preferred (ASA or equivalent experience).
  
  

Compensation

Salary for this position ranges from $75,000.00 - $110,000.00. The base pay offered will be determined on factors such as experience, skills, training, location, certifications, and education. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

Qualifying positions will also be eligible for comprehensive benefits, such as participation in family medical and dental insurance programs, 401K plan, and PTO.

Conner Strong & Buckelew is an equal opportunity employer. It is Conner Strong & Buckelew’s policy to grand equal employment opportunities to all qualified persons without regard to race, sex, religion, age, national origin, creed, marital status, color, citizenship, sexual orientation, physical or mental disability, veterans’ status or any other characteristic protected by the law. Conner Strong & Buckelew provides equal opportunities in employment, promotion, wages, benefits and all other privileges, terms and conditions of employment. It is Conner Strong & Buckelew’s policy to make reasonable accommodations for the disables that do not impose an undue hardship on Conner Strong & Buckelew.