Data Analytics Intern

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.

https://www.best10weeks.com/