Accounts Receivable & Invoicing Analyst

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

Benefits offered by this job

Medical, Dental, and Vision Coverage

Disability Insurance

401(k) with Company Match

Flexible Spending Accounts

Health Savings Account Contributions

Fitness Membership Discounts

Company-paid Life Insurance

Tuition/Professional Development Reimbursement

Employee Assistance Programs

Paid Time Off

Job summary

A benefits administration firm in Texas seeks a detail-oriented Premium Invoicing Analyst I to ensure accurate financial operations. The role involves generating invoices, data reporting, reconciliation, and analysis using Excel and SQL. Candidates should have strong analytical skills, a foundation in accounting, and preferably three years of relevant experience. FCE offers competitive benefits, including health coverage and a 401(k). This is an entry-level, full-time position.

Qualifications

• Intermediate to Expert level in Microsoft Excel is critical.
• Understanding of employee benefits preferred.
• Three years of relevant experience in a related field.

Responsibilities

• Prepare and issue invoices for clients.
• Extract and report data from internal systems.
• Reconcile discrepancies between reports and internal systems.
• Analyze large datasets using SQL queries and Excel.
• Maintain data accuracy and integrity.

Skills

Microsoft Excel proficiency

Accounts Payable/Receivable knowledge

Data Management

Communication Skills

Organizational Skills

Education

Bachelor’s Degree in Accounting, Human Resources, or Analytics

Job description

Get AI-powered advice on this job and more exclusive features.

FCE Benefit Administrators, Inc. provided pay range

This range is provided by FCE Benefit Administrators, Inc.. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$45,000.00/yr - $53,000.00/yr

Direct message the job poster from FCE Benefit Administrators, Inc.

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.

If you thrive in a fast-paced environment, possess exceptional analytical abilities, and are ready to leverage your Excel expertise to solve complex data challenges, we encourage you to apply.

• 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, including 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.

Seniority level

Entry level

Employment type

Full‑time

Job function

Analyst

Industries

Insurance and Employee Benefit Funds