Senior Associate Consultant - Data Analytics
Company: Conner Strong & Buckelew
Location: Camden
Posted on: September 13, 2023
Job Description:
Senior Associate Consultant Data Analytics Team Department:
Employee Benefits Data Analytics and Underwriting Job Summary: The
Senior Associate Consultant for the Data Analytics and Underwriting
Team is responsible for performing detailed consultative reviews of
the health and welfare plans for existing clients. Focuses heavily
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 senior level Consultative Support to the Consulting
team based on a detailed analytic review existing clients health
and welfare plans; including medical, pharmacy, stop loss, dental,
vision, life/disability, and voluntary plans.
- Review to include performing detailed gap analysis for all
coverages, examining cost and policy data, plan design strategies,
contribution modelling, budget forecasting followed by detailed
recommendations and corrective action steps for prospective/and or
existing clients.
- Particular expertise with large self-funded accounts as it
relates to variable and fixed expenses. Management of the carrier
claims reporting process as it relates to timing and accuracy.
Solid knowledge of stop loss arrangements and contracts.
- Knowledge of the application of self-funded arrangements as it
relates to our Captive practice
- Ability to develop custom financial modelling at the clients
request and/or the ability to incorporate a non-standard request
using our existing tools.
- Maintenance of an assigned book of business, managing the
Consulting team and client needs.
- Ability to manage both internal and external deadlines.
- Attend client meetings/conference calls at the request of the
Consultant.
- 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,
claims experience and benchmarking analysis. 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 larger, more
complex 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 ongoing
data projects requests that may arise.
- Manage and perform benefit cost modeling projects using the
Data Analytics tools available including the Underwriting Model,
Actuarial Value Calculator, BeneView (claim/cost versus budget
tracking), and various Data Warehouse tools utilized by our
clients.
- Knowledge of the pharmacy marketplace and ability to evaluate
the financial terms of various PBMs, including discounts, fees,
rebates, and the impact of changes in formulary and utilization
management.
- Remain current on industry trends and information, new product
information, legislation, regulatory requirements, coverages,
compliance, and technology; communicate changes and address issues
with Consulting teams and clients on a proactive basis. Other
Functions
- Projects and assignments essential to the day-to-day operations
of the employee benefits division as needed.
- Other duties as assigned. Requirements
- Bachelors degree and/or equivalent business experience
required.
- Minimum of 7-10 plus years of experience working in the
employee benefits field; preferably in an in a financial consulting
role
- Strong working knowledge in underwriting, plan design, employee
contributions, plan funding, data warehouse management, 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
LicensesHealth and Life license required.Completion of actuarial
exams preferred.Related designations preferred. 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.
Keywords: Conner Strong & Buckelew, Camden , Senior Associate Consultant - Data Analytics, Professions , Camden, New Jersey
Didn't find what you're looking for? Search again!
Loading more jobs...