Employee Benefits - Data Analytics Intern

Conner Strong & Buckelew Internship Program

Camden (NJ)

On-site

USD 28,000 - 40,000

Part time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Conner Strong & Buckelew is seeking a Data Analytics Intern in the Employee Benefits – Data Analytics and Underwriting department. You will perform detailed consultative reviews of health and welfare plans for prospective and existing clients, focusing on plan analysis, budget forecasting, and trend assessment.

This internship supports client-facing consulting and new business teams, including RFQ/RFP preparations, renewal negotiations, and data-driven recommendations.

Qualifications

  • Exceptional organization and customer service skills.
  • Excellent interpersonal, analytical, written and verbal communication skills.
  • Must be an enthusiastic self-starter, flexible, able to multi-task and delegate or handle responsibilities with minimal supervision.
  • PC proficiency required, MS Office (Word and Excel) a must.

Responsibilities

  • Review health and welfare plans for clients, analyzing costs, budget forecasts, and plan design.
  • Support RFQ/RFP processes with data collection, recommendations, and presentations.
  • Analyze rate renewals and year-end financials; benchmark trends and renewal actions.
  • Assist with claims analysis, trend/utilization analyses, and data projects for clients.
  • Manage benefit cost modeling using the BeneFuture tool.
  • Leverage BeneView data warehouse results for client insights.
  • Coordinate with pharmacy coalition and re-insurance terms.
  • Help consultants in proper usage of analytics tools and monitor effectiveness.

Skills

Analytical thinking
Organizational skills
Written and verbal communication
Self-starter
Multi-tasking

Tools

MS Office
Excel

Job description

Department: Employee Benefits – Data Analytics and Underwriting
Position: Data Analytics Intern
Summary

The Intern for the Data Analytics and Underwriting Team is responsible for performing detailed consultative reviews of the health and welfare plans for prospective and/or existing clients. Focuses on analysis of plans and other financials, budget forecasting, plan modeling, contribution analysis, conducting trend and cost analysis of claim history. The Data Analytics Team supports the client facing consulting teams and the new business sales team in performing the analytical services noted throughout.

Principal 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.
Requirements
  • Exceptional organization and customer service skills.
  • Excellent interpersonal, analytical, written and verbal communication skills.
  • Must be an enthusiastic self-starter, flexible, able to multi-task and delegate or handle responsibilities with minimal supervision.
  • PC proficiency required, MS Office (Word and Excel) a must.
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.

The pay rate for this role is $25 per hour.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Benefits Data Analytics Intern — Flexible Hours & Growth
Benefits Data Analytics Intern — Flexible Hours & Growth

Conner Strong & Buckelew Internship Program • Camden (NJ)

On-site
USD 28,000 - 40,000
Associate Consultant – Data Analytics Team
Associate Consultant – Data Analytics Team

Conner Strong & Buckelew • Camden (NJ)

Hybrid
USD 80,000 - 110,000
Hybrid work model
Employee Benefits Intern
Employee Benefits Intern

Conner Strong & Buckelew Internship Program • Camden (NJ)

On-site
USD 28,000 - 40,000
Health & Benefits Financial Analyst
Health & Benefits Financial Analyst

WTW group • Seattle (WA)

On-site
USD 90,000 - 98,000
Health and Welfare Benefits
Paid Holidays
Annual Paid Time Off
+2
Associate Benefits Consultant
Associate Benefits Consultant

Segal • New York (NY)

Hybrid
USD 84,000 - 105,000
Pension plan
401(k) contributions
Medical benefits
+6
Senior Benefits Analyst - Health & Welfare
Senior Benefits Analyst - Health & Welfare

Rael & Letson • Seattle (WA)

Hybrid
USD 90,000 - 125,000
Flexible work arrangements
Annual bonus program
401k with company contribution
+1
Intern
Intern

Lockton • Irvine (CA)

On-site
USD 28,000 - 40,000
Health and Benefits - Senior Analyst Consulting
Health and Benefits - Senior Analyst Consulting

WTW group • Philadelphia

On-site
USD 85,000 - 110,000
Health benefits
Pension plan
Paid time off
Health & Benefits Financial Consultant
Health & Benefits Financial Consultant

WTW group • San Francisco (CA)

On-site
USD 95,000 - 162,000
Health and welfare benefits
Paid time off
401(k) plan
Health and Benefits Consulting - Senior Analyst
Health and Benefits Consulting - Senior Analyst

WTW group • Atlanta (GA)

On-site
USD 90,000 - 120,000