Apply on Employer Site

Conner Strong & Buckelew · 2 months ago

Employee Benefits - Data Analytics Intern

Camden, New Jersey, United States

Internship

Onsite

Intern

$25/hr - $25/hr

Conner Strong & Buckelew is a company that focuses on providing consulting services in employee benefits. The Intern for the Data Analytics and Underwriting Team is responsible for performing detailed consultative reviews of health and welfare plans, analyzing financials, and supporting client-facing consulting teams.

Employee BenefitsInsurance

Responsibilities

Perform detailed consultative review of prospective/existing clients’ health and welfare plans, including medical, pharmacy, dental, life, disability, long term care, re-insurance, voluntary plans. Review to include performing detailed gap analysis for all coverages, examining cost and policy data, plan design strategies, budget forecasting followed by detailed recommendations and corrective action steps for prospective/and or existing clients

Work with the new business production team in the consultative review process. Interface with the prospective client in data collection. Prepare recommendations and presentations to support the RFQ/RFP process for new business

Work with Consultants and Associate Consultants to analyze and negotiate rate renewals and year-end financials on behalf of clients. Responsible for proactive preparation for renewal negotiation process through detailed analysis of client objectives, performing claims experience and benchmarking analysis and identifying and introducing market trends to provide clients with an understanding and justification of renewal action. Prepare recommendations and presentations to support the RFQ/RFP process for renewal business

Assist with project analysis work related to current clients. This may include but is not limited to claims analysis, trend and utilization analysis, IBNR and reserve studies, lag analysis, vendor discount reviews and other special on-going data projects requests that may arise on client business

Manage and perform benefit cost modeling projects using the BeneFuture tool

Utilize the data results for clients using the BeneView data warehouse

Manage and be engaged with the pharmacy coalition and preferred re-insurance terms

Assist the consulting staff in the proper usage of these features and be engaged in the monitoring and analysis of the continued effectiveness of the tools

Qualification

Data analysisBudget forecastingPlan modelingMS OfficeCustomer serviceMulti-taskingInterpersonal skillsWritten communicationVerbal communicationSelf-starter