Multi-Market Administrator I-Remote 8am-5pm PST

Multi-Market Administrator I

Department: Large Group and Level Funded Employee Benefits

Job Summary: The Multi-Market Administrator is responsible for supporting the Large Group and Level Funded Employee Benefits department by creating and maintaining extensive spreadsheets that compile Rates and Benefits for multiple Medical and Ancillary insurance carriers. This role plays a critical part in ensuring accurate and professional rate and benefit illustrations that support the sale and renewal of insurance policies. The ideal candidate possesses advanced Excel skills, the ability to synthesize complex data from multiple sources into a consistent format, and strong communication skills for collaboration with internal analysts, sales consultants, and brokers. The ability to meet tight timeframes and deadlines is essential in this fast-paced environment.

Overview of Responsibilities:

• Develop, update, and maintain complex spreadsheets containing Rates and Benefits for multiple insurance carriers.
• Organize and standardize data from various sources to ensure consistency and accuracy.
• Create professional rate and benefit illustrations to support new and renewing insurance policies.
• Collaborate with internal multi-market analysts, sales consultants, and brokers to obtain, clarify, and verify necessary information.
• Ensure data integrity and accuracy by reviewing all compiled information before finalizing reports.
• Ensure proper tracking methods are being updated in real-time to provide metrics for reporting purposes.
• Assist in streamlining and improving processes related to rate and benefit data management.
• Maintain compliance with company policies and industry regulations related to insurance benefit documentation.
• Work efficiently under tight timeframes and deadlines to meet business needs.

Client Communications:

• Support brokers and sales consultants by providing accurate and timely rate and benefit illustrations.
• Respond to inquiries and requests for clarification on plan details and pricing information.
• Assist in preparing client-facing materials that clearly communicate insurance benefit options.
• Ensure professional and clear communication when addressing client needs and concerns.

Collaboration & Team Support:

• Work with the sales team, brokers, and account managers to provide support during the proposal process.
• Provide team support and desk coverage as needed to ensure smooth operations during absences or high-demand periods.
• Assist other departments as needed to support organizational goals.
• Overtime, as needed to support turnaround time goals and broker timelines.
• Work overtime as needed, particularly during peak periods, to meet turnaround time goals and support broker timelines.

Market & Product Knowledge:

• Stay updated on trends in employee benefits offerings, plan designs, and the competitive landscape to provide the best possible rate and benefits illustrations.
• Continuously monitor industry regulations (i.e., carrier 411) and compliance standards to maintain up-to-date knowledge of the employee benefits market.

Customer Service:

• Respond promptly to customer inquiries, within service level, delivering exceptional service throughout the quoting process.
• Promptly acknowledge urgent requests upon receipt to ensure timely response and action.
• Respond to client inquiries, concerns, or requests for adjustments related to their benefits packages, and work to resolve any issues promptly and effectively.

Expected Leadership Qualities:

• Treat all employees and internal/external customers with respect and foster a positive and professional work environment.
• Adhere to company policies, including those related to punctuality, attendance, workplace conduct, and professionalism.
• Adapt to change and encourage a positive, adaptable mindset among colleagues.
• Demonstrate strong judgment, integrity, and accountability in all aspects of job performance.
• Independently seek out additional work from current or other departments as time permits.
• Complete assignments on time and proactively seek additional responsibilities when

Qualifications & Skills:

• Advanced proficiency in Microsoft Excel, including functions, pivot tables, and data visualization tools.
• Strong analytical and problem-solving skills with attention to detail.
• Experience in compiling and presenting complex data in a professional and understandable format.
• Excellent communication skills, both written and verbal, with the ability to interact effectively with internal teams and brokers.
• Ability to manage multiple tasks, prioritize deadlines, and maintain accuracy in a fast-paced environment.
• Experience in employee benefits, health insurance, or a related field is preferred.
• Experience working with data analysis and presentation tools is highly desirable.

Education & Experience:

• High school diploma or equivalent required.
• 3 years of experience in a similar role, preferably within the insurance or benefits industry.
• Prior experience working with Large Group and Level Funded insurance products is a plus.
• Salesforce experience is a plus, along with experience using various quoting and benefit platforms.
• This role is essential in supporting the efficiency and effectiveness of the sales and renewal process within the Large Group and Level Funded Employee Benefits department. If you have a keen eye for detail, a passion for data organization, and the ability to collaborate with various teams while meeting tight deadlines, we encourage you to apply.

• Hourly Range: $18.50 - $24.66 per hour
• Actual compensation may vary from posting based on work experience, education, and/or skill level.
• • The hourly or salary range is the range Warner Pacific in good faith believes is the range of possible compensation for this role at the time of this posting. The Company may ultimately pay more or less than the posted range. This range may be modified in the future. No amount is considered to be wages or compensation until such amount is earned, vested, and determinable under the terms and conditions of the applicable policies and plans. The amount and availability of any bonus, commission, benefits, or any other form of compensation and benefits that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.
• We offer a range of market-competitive benefits that include merit increases, paid holidays, Paid Time Off, medical, dental, vision, short- and long-term disability benefits, 401(k) match, and life insurance.
• As an organization that values diversity of backgrounds, experiences, thoughts, and education levels, we know that an amazing candidate may not have all the qualifications that are listed above. Warner does not want to miss out on excellent candidates. If you believe you would be able to leverage your skills and strengths to meet our "Duties & Responsibleness" section, please apply! We look forward to hearing from you!