Premium Invoicing Analyst I

FCE Benefit Administrators, Inc.; San Antonio (TX); On-site; USD 55,000 - 75,000; Full time

Benefits offered by this job

Medical, Dental, and Vision Coverage

Disability Insurance

401(k) with Company Match

FSA/HSA Contributions

Fitness Membership Discounts

Company-paid Life Insurance

Tuition/Professional Development Reimb

Employee Assistance Programs

Paid Time Off (PTO)

Job summary

FCE Benefit Administrators, Inc. is seeking a detail-oriented Premium Invoicing Analyst I to join our Premium Accounting Department. The role focuses on generating accurate invoices for Health & Welfare Trusts and ensuring timely financial operations.

You will work with Excel and SQL to analyze data, reconcile discrepancies, and prepare reports for self-billed carriers while delivering high-quality service to clients.

Qualifications

• Proficient in Excel with advanced functions and data analysis.
• Strong understanding of accounts payable/receivable and accounting fundamentals.
• Ability to prepare, analyze, and prioritize data tasks.
• Experience or knowledge of employee benefits (HRA/HSA/FSA) preferred.
• PC literate with proficiency in MS Office.
• Excellent organization, accuracy, and attention to detail.
• Strong written and verbal communication skills.

Responsibilities

• Generate invoices for Health & Welfare Trusts and maintain fringe benefit invoicing.
• Extract monthly data from internal systems and report to self-billed carriers.
• Reconcile discrepancies between carrier reporting and internal data; coordinate resolutions.
• Extract and manipulate large data sets using SQL and Excel to troubleshoot issues.
• Identify and investigate discrepancies to ensure data accuracy and integrity.
• Deliver timely, high-quality reporting to clients and maintain service responsiveness.
• Collaborate with other departments to streamline data processes and address issues.
• Support department goals with any other duties as assigned.

Skills

Excel

AP/AR knowledge

Data management

Benefits knowledge

Communication

Organizational skills

Education

Bachelor's degree in Accounting

Tools

Microsoft Office

Job description

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