Job Summary This role will support the Benefits team through administration, auditing, reporting, and systems management related to company benefit programs. This role is responsible for ensuring the accuracy and integrity of benefits data, payroll deductions, carrier integrations, file feeds, etc. The ideal candidate is highly detail-oriented, analytical, organized, and comfortable working across multiple systems and large datasets, including advanced use of Excel. Duties & Responsibilities Benefits Systems & Data Integrity Maintain and audit benefit system integrations, carrier file feeds, and EDI feedback reports to ensure accurate data transmission and enrollment processing Troubleshoot and resolve carrier, payroll, and enrollment discrepancies through ongoing auditing and reconciliation Support vendor implementations, benefit migrations, and file feed rebuilds, including testing scenarios and post-go-live validation Maintain benefits-related processes within UKG and other vendor systems Process weekly consultant onboarding and terminations in UKG Track and manage benefit eligibility for new hires and ongoing employee status changes Maintain benefits payroll deductions and partner closely with Payroll on deduction scenarios, arrearages, and reporting Generate and manage COBRA notifications and related tracking Perform ongoing audits related to terminations, finish forms, extensions, dependent eligibility, and ACA compliance 401(k) Administration & Compliance Administer quarterly and annual 401(k) processes, including enrollment support, deferral changes, contribution submissions, and participant communications Maintain Fidelity tasks, notifications, participant audits, and distribution lists Coordinate and support annual 401(k) audit activities, including documentation gathering, testing selections, and DOL 5500 filing support Manage nondiscrimination testing, match analysis, census reporting, and reconciliation processes Reporting, Auditing & Analytics Conduct monthly carrier bill audits and active participant reconciliations to ensure billing accuracy and eliminate undue risk Monitor worked hours and eligibility reporting for ACA and self-funded plan purposes Own ACA annual filing processes, including 1095-C generation, auditing, and IRS submissions Prepare and maintain recurring reports related to benefits eligibility, payroll arrearages, reimbursements, and benefits costs Perform W-2 reconciliation analysis related to benefits deductions and expenses Partner with Accounting and Finance teams on benefits forecasting, cost analysis, and reporting Utilize Excel to analyze large data sets, perform reconciliations, create reporting dashboards, and identify trends or discrepancies Open Enrollment & Process Improvement Support annual Open Enrollment planning, system updates, employee communications, and enrollment auditing Ensure payroll deductions and carrier enrollments are accurate following plan year changes Continuously identify opportunities to improve processes, automate tasks, and enhance operational efficiency through technology and reporting tools Required Skills & Abilities Strong analytical and problem-solving skills Excellent attention to detail and organizational skills Advanced Microsoft Excel skills, including: VLOOKUP/XLOOKUP Pivot Tables Data validation and reconciliation Reporting and data analysis Ability to manage multiple priorities and deadlines in a fast-paced environment Experience working across multiple systems and large data sets Strong communication and collaboration skills Self-motivated with the ability to work independently Ability to maintain confidentiality and handle sensitive information appropriately