Proposal Coordinator
: Job Details :

POSITION:Financial Analyst - Employee BenefitsSummaryThe Financial and Healthcare Data Analyst is responsible for providing in depth analysis and reporting of healthcare plan design; Utilizing sophisticated software tools and platforms to aid in complex analysis, such as predictive analytics and population health forecasting; Strategic analysis of current and trending market changes; Analyzing claim utilization and changes in the market as well as within client groups; Merging benefit plan data into meaningful reporting dashboards; and Providing illustrations of various funding and alternate plan options and comparisons.Essential Duties And Responsibilities§ Utilize predictive analytics software to: produce renewal projections; Estimate actuarial differences between plan designs and relative values between specific reinsurance contracts; Predict population migration based on plan designs/contributions/incentives; Evaluate the appropriateness of self-funding vs fully insured; and Provide reporting on specific reinsurance deductible levels.§ Update Claims Reporting Dashboards on a monthly basis and provide reporting/written summaries of findings to clients.§ Produce IBNR estimates for client financials.§ Evaluate the appropriateness of self-funding vs fully insured and develop illustrative rates for plan designs.§ Analyze healthcare claims and identify members eligible for alternative coverage plans.§ Use financial modeler, population health analysis and other tools to predict financial impact on client plans.§ Other duties as assigned.Additional Responsibilities§ Lead, guide, direct mid-year and annual renewal meetings and participate in internal pre-renewal meetings.§ Prepare spreadsheets, graphs, charts, diagrams, and other illustrative tools for presentations and reports.§ Work collaboratively with client service teams to collect and review data for accuracy and consistency.§ Serve as a Subject Matter Expert on financial reporting.§ Adapt to new software programs when implemented.§ Attend all internal scheduled office and team meetings.§ Remain informed of insurance industry developments and products available in the marketplace and participate in continuingeducation events.§ Make a positive contribution to client satisfaction and strive to improve client service.§ Attend client meetings when necessary.§ Build rapport with clients, carrier representatives and respond to email inquiries in a timely manner.§ Participate in special projects as required.QualificationsTo perform this job successfully, an individual must be able to perform each essential duty at a high level. The requirements listed below are representative of the knowledge, skill, and/or ability required.Education and/or Experience§ Bachelor's degree in a business-related program or equivalent education and/or experience, with an emphasis in math,statistics, or finance required or equivalent level of experience.§ 2-5 years of experience in a similar position with knowledge in healthcare insurance.§ Familiarity with basic financial reporting and basic medical terminology.§ Familiarity with basic statistics and understanding of risk and insurance concepts is preferred.Computer Skills§ Intermediate to advanced skill level in MS Office Excel§ Excellent computer skills including word processing and spreadsheet expertise§ Brokerage Builder/ZyWave software experience§ Experience with reporting dashboards and plan comparison software is preferred.§ Experience working in other MS Office Suite programs such as PowerPoint, Word, etc.§ General use of standard office equipment, such as computer, keyboard, calculator, printer, etc.