Associate Consultant - Data Analytics

Job Description

Job Description

Associate Consultant Data Analytics Team

Location : Camden, New Jersey, United States (Hybrid)

Department : Employee Benefits Data Analytics and Actuarial Services

Job Summary : The Associate Consultant for the Data Analytics and Actuarial Services Team is responsible for performing detailed consultative and financial reviews of the health and welfare plans for existing and prospective clients.

The 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.
• Assist in the marketing of new vendor relationships on behalf of fully insured and self-funded accounts including the medical, PBM, and stop loss RFP process.
• Maintenance of an assigned book of business.
• 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.
• Ability to manage both internal and external client deadlines.
• Ability to develop custom financial modeling 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 Excel, PowerPoint, Word and Power apps.
• 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).

Working Conditions

Office environment with moderate noise level; Able to work flexible hours and travel to other Conner Strong buildings and client work sites on a regular basis.

Conner Strong & Buckelew is proud to be an equal opportunity employer. All qualified applicants will receive consideration without regard to race, color, religion, gender, affectional or sexual orientation, gender identity or expression, national origin, ancestry, nationality, age, disability (physical or mental), marital or domestic partnership or Civil Union status, pregnancy, family medical history or genetic information, atypical cellular or blood trait, military service or any other status protected by law.

LI-HYBRID