Carrier Implementation Specialist

We are seeking a highly skilled Carrier Implementation Specialist to support the transformation of employee benefits census data into carrier-specific formats. This role involves converting data from Benefits Administration systems (e.g., Employee Navigator, Ease, PlanSource) into structured, macro-enabled Excel templates required by insurance carriers. The ideal candidate will be an Excel power user with a meticulous eye for detail and a strong ability to work independently and efficiently.

Key Responsibilities:

• Convert and manipulate large datasets exported from Benefits Administration platforms into carrier-specific Excel templates.
• Utilize advanced Excel functions including pivot tables, complex formulas, data validation, and macros/VBA to ensure compliance with carrier specifications.
• Clean and standardize inconsistent or messy source data for delivery in accurate, high-quality carrier enrollment files (medical, dental, vision, life, etc.).
• Ensure strict adherence to carrier formatting requirements, including field-level logic, naming conventions, and file structures.
• Own the end-to-end request lifecycle, from intake through to final delivery, ensuring accuracy and timeliness.
• Collaborate with internal stakeholders to clarify requirements and confirm data completeness.
• Maintain a high standard of quality assurance across all deliverables, with oversight and guidance provided by a senior team member.

Qualifications:

• Proven expertise in Microsoft Excel, including advanced formulas, pivot tables, and VBA/macro development.
• Strong background in data cleaning, transformation, and formatting for external-facing reports or deliverables.
• Impeccable attention to detail with a passion for getting things right the first time.
• Ability to work autonomously, manage multiple priorities, and deliver accurate outputs under tight deadlines.
• Experience with benefits administration systems or HRIS platforms is a plus but not required.

Who You Are:

• A senior-level Excel user with an obsessive focus on accuracy and detail.
• Comfortable taking ownership of projects from start to finish with minimal supervision.
• Proactive and communicative, ensuring you have everything needed to complete your work efficiently.
• Comfortable receiving feedback and collaborating on improvements to optimize workflows.