Essential Responsibilities

• Data entry and analysis - assist the consulting team in gathering, organizing, entering and analyzing data using Excel spreadsheets to be used for various client projects. This role also involves an increased focus on analysis of the results and managing portions of projects, including reviewing the work of lower level analysts.
• Marketing efforts - gather benchmarking, utilization or rate data from the vendors via a Request for Proposal (RFP); interpret the meaning of the data and summarize the responses from the RFP in Excel or PowerPoint format for presentation to the client
• Plan design consolidation - gather data from the client and current vendors needed for analyzing the impact of a client’s consolidation of its healthcare plans; typically involves organizing and summarizing plan design details and costs in Excel for further analysis by the team; responsibilities also include checking data for reasonableness and follow-up with vendors regarding missing or inaccurate data.
• For experience rated clients - Cost projections and vendor renewal workups - gather data from the client and vendors to populate Excel spreadsheets used for developing cost projections and evaluation of vendor renewal workups; results are used as part of client renewal and budget meetings
• For experience rated clients - Tracking claims experience - gather data from client and vendors and check for reasonableness using independent judgment; analyze actual versus expected healthcare costs using an Excel template; results are typically sent to clients on a monthly or quarterly basis
• Understand Health and Benefits products, services and tools - Understand vendor/carrier markets, more advanced underwriting and financial skills, Health & Benefit products, services and technical tools, and intranet resources offered by NFP by participating in training courses, online learning, or through learning from more experienced colleagues.
• Project management & consulting skills - understand and demonstrate project management and consulting skills such as:
• Managing the quality and timeliness of client deliverables
• Helping to develop budgets and billing reports
• Participating in client calls and meetings as appropriate
• Delegating to and reviewing project work of more junior colleagues
• Assisting with the preparation and delivery of clear and concise client-friendly communications.
• Develop and present benchmarking reports - gather and analyze health benefits data from a national survey administered and published by various sources, input it into a standardized template and compare a client’s medical and dental plan information (such as the benefits they offer, rates, contributions) to other companies by industry or geography and present the final report to the client. The analyst will have a discussion with a consultant up front to determine what cuts of the data to make

Requirements

• BA/BS preferred
• Three to five years of industry experience required
• Intermediate to Advanced knowledge of MS Office Tools (Excel, PowerPoint)
• Excellent interpersonal skills; strong oral and written communication skills.
• Life & Health License required

What We Offer We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, at the end of the day, we exist to be there for others. The base salary range for this position is $55,000 - $110,000. The base salary offered will be determined by factors including, but not limited to, experience, credentials, education, certifications, skill level required for the position, the scope of the position, and geographic location. Actual base salary offered will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

NFP and You... Better Together! NFP is an inclusive Equal Employment Opportunity employer. PDN-a0ae9f32-3d19-4f9f-a985-df702cdbe04f