SUMMARYResponsible for working with account team in processing renewals, conducting and analyzing marketing, preparing financial summaries and providing general technical support for assigned fully-insured and self-funded accounts. Performs a variety of analysis including provider network analysis and carrier utilization analysis. ESSENTIAL DUTIES AND RESPONSIBILITIES• Initiates recurring analyst renewal projects on assigned accounts (pre-renewal spreads, carrier renewal process initiation, information requests, etc.); Gathers, reviews and validates all information related to assigned clients for renewal analysis and marketing purposes, gaining comprehensive familiarity with client’s current details and history;• Evaluates carrier utilization reporting to identify key cost drivers and make recommendations for possible plan design changes;• Coordinates and assists in renewal challenges (underwriting);• Creates new financial reporting package from templates as needed;• Conducts provider network comparison analysis (access disruption analysis);• Coordinates with account team to understand strategy for client renewal and define roles and responsibilities. Revisits throughout the renewal development process, outlining renewal project action items, including all deadlines;• Collaborates with all current insurance carriers and vendors to obtain preliminary and/or firm renewals and prepares initial financial summary and benefit highlights;• Presents preliminary renewal summaries and marketing results to account team to determine plan options and/or marketing strategy; works with account team to develop and execute negotiation strategy.• Presents all final results to account team; determines content and structure of renewal presentation and identifies analytical support materials (i.e.; utilization review, contribution strategy, benchmarking, financial reporting, etc.);• Executes all relevant plan option requests, marketing projects and necessary analysis to complete account strategy objectives;• Reviews all marketing and plan option responses, evaluates for accuracy and completeness, and requests clarifications and revisions as needed;• Handles ongoing (monthly/quarterly) client maintenance projects as determined by account team;• Reviews team members work for accuracy and completeness as needed;• Complies with agency management system data standards and data integrity (enters and maintains complete and accurate information);• Other duties as assigned. QUALIFICATIONSEDUCATION / EXPERIENCEBachelor’s degree or equivalent combination of education and experience. Degree in Business or Mathematics preferred. One (1) or more years related work experienceValid insurance license (or must be obtained within ninety (90) days of employment)Must continue to meet Continuing Education requirements for license renewalBasic knowledge of compliance topics (HIPAA, COBRA, ACA, Medicare).Basic knowledge of programs (know of existence and how to get a quote). Salesforce experience preferredKnowledge of all major fully-insured and self-funded lines of benefits insurance (Medical, Dental, Vision, Life and Disability, EAP); SKILLSProficient in Microsoft Office Suite: Excel, Power Point, and Outlook Intermediate skills in Microsoft ExcelExcellent verbal and written communication skills Excellent problem solving and time management skillsGood customer service skills, including telephone and listening skillsExcellent planning, organizational and prioritization skillsAbility to work within a team and to foster teamwork Ability to work productively as an individual to accomplish assigned projectsAbility to prioritize work for multiple projects and deadlines #LI-LM1