An Associate Consultant on the Data Analytics and Underwriting team reviews existing clients' health and welfare plans (medical, pharmacy, stop loss), performing cost analysis, budget forecasting, stop-loss RFPs, and financial/underwriting modeling — largely in Excel — to support client-facing consultants at a benefits brokerage and consulting firm.
Department: Employee Benefits– Data Analytics and Underwriting
Job Summary: The 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. 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 at Conner Strong and other Broadstreet firms by providing periodic benefits and cost analysis of our existing clients’ health and welfare plans with primary focus on medical, pharmacy, and stop loss.
Maintenance of an assigned book of business
Conduct stop loss RFPs and analysis of proposals.
Perform financial analysis for all coverages, examining both overall cost and benefit structures, various plan design and contribution modeling.
Develop budget forecasting followed by detailed recommendations and corrective action steps for 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 modelling 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 rate Prepare recommendations and presentations to support the RFQ/RFP process for renewal business.
Provide support our cost modeling projects using the Data Analytics tools available including actuarial modeling tools, 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.
Other Functions
Projects and assignments essential to the day to day operations of the employee benefits division as needed.
Other duties as assigned
Requirements
Bachelor’s degree and/or equivalent business experience
Minimum three to five (3-5) plus years’ 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
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
#LI-HYBRID
Must be authorized to work in the United States on a full-time basis without Company sponsorship.
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.