Premium Invoicing Analyst I

FCE is seeking a detail-oriented and analytical Premium Invoicing Analyst I to join our dedicated Premium Accounting Department team. This role is essential for ensuring accurate and timely financial operations related to client Health & Welfare Trusts. The ideal candidate will have a strong foundation in accounting principles, an understanding of employee benefits, and—most importantly—proven, robust skills in Microsoft Excel and data analysis. Generate Invoices: Accurately prepare and issue invoices for clients to fund their Health & Welfare Trusts, ensuring continuous maintenance of fringe benefits. Data Reporting: Extract comprehensive monthly data from internal systems and report relevant information efficiently and on time to self-billed carriers. Reconciliation & Resolution: Reconcile benefit discrepancies identified between carrier reporting and our internal systems; collaborate cross-functionally with necessary departments to ensure timely resolution of data issues. Data Analysis (SQL & Excel): Extract and manipulate large datasets using predetermined SQL queries. Utilize intermediate to expert-level Excel functions (e.g., VLOOKUPs, Pivot Tables, logical functions) to troubleshoot, analyze, and resolve discrepancies found within system data. Accuracy & Integrity: Identify and investigate discrepancies within client reporting, utilizing meticulous attention to detail to ensure data accuracy and integrity. Client Service: Ensure the timely delivery of resolved reporting and data to clients, maintaining a high level of service and responsiveness. Collaboration: Work effectively within a team environment and collaborate with other departments to streamline processes and address shared data challenges. Any other duties as assigned to support department goals. Requirements & Qualifications Skills & Knowledge Excel Proficiency (Critical): Must demonstrate Intermediate to Expert abilities within Microsoft Excel. The pre-screening process will assess your comfortability and ask for specific examples of how you utilize complex functions and formulas to manipulate data, troubleshoot issues, and generate reports. Accounts Payable/Receivable Knowledge: Must be able to demonstrate a high level of understanding of AP/AR experience knowledge and accounting principles. Data Management: Ability to prepare, analyze, and prioritize data analysis tasks effectively. Benefits Knowledge (Preferred): Understanding of employee benefits, to include HRA/HSA/FSA benefits. Software Skills: PC literate, including proficiency with Microsoft Office products. Organizational Skills: Excellent organizational skills, accuracy, and attention to detail are paramount. Communication: Strong interpersonal and communication skills, both written and oral. Experience & Education Preferred Experience: At least three (3) years of experience in an insurance, employee benefits, accounts receivable or payable, and/or payroll position, preferably within a medium-to-large employer setting. Education (Preferred): A bachelor’s degree in accounting, Human Resources, Analytics, or a related field is preferred. Core Competencies Ability to interpret a variety of complex instructions furnished in written, oral, diagram, or schedule form. Must be able to handle multiple priorities in an ever-changing, deadline-driven environment. Ability to work both independently and within a collaborative team structure. Ability to meet or exceed established performance competencies. Benefits Offered We understand that top talent is attracted to organizations offering competitive compensation, comprehensive benefits, and opportunities for professional growth. FCE offers a robust benefits package including: Medical, Dental, and Vision Coverage Disability Insurance 401(k) with Company Match Flexible Spending Accounts (FSA) Health Savings Account (HSA) Contributions Fitness Membership Discounts Company-paid Life Insurance Tuition/Professional Development Reimbursement Employee Assistance Programs Paid Time Off (PTO) About FCE Benefit Administrators, Inc. With nearly 30 years of experience, FCE Benefit Administrators, Inc. has helped hundreds of For-Profit and Not-For-Profit organizations achieve full compliance under the Service Contract Act (SCA), Davis-Bacon Act (DBA), Javits-Wagner-O’Day (JWOD), and related federal legislation. As trusted experts in government contracts, we specialize in the administration of bona-fide fringe benefit plans through an irrevocable funding arrangement, ensuring full compliance with SCA requirements. Equal Opportunity Employer FCE is an equal opportunity employer and is committed to creating an inclusive and diverse workplace #J-18808-Ljbffr FCE Benefit Administrators, Inc.