[ivory-search id="2595" title="AJAX Search Form"]

Accountant/Data Analyst

October 20, 2026

OPEN

What you’ll do

  • Commission reconciliation: download and process carrier and FMO commission statements (e.g. Messer, Community Health Choice, UHC, Aetna, Ambetter, Oscar, Cigna, Ameritas) and match paid commissions to policies, members and writing agents.

  • Sales rep commissions: calculate monthly agent/rep commissions for ACA/OBC and Dental-Vision-Hearing (DVH) lines using CRM deal data (HubSpot), including new vs. renewal business, chargebacks and AOR changes.

  • Discrepancy follow-up: identify missing, short-paid or misattributed commissions and follow up with carriers and FMOs until resolved.

  • Independent agent program: prepare monthly override/IA computations, invoices and payouts from portal reports.

  • Data consolidation: maintain consolidated commission workbooks (multi-carrier, multi-month, 30,000+ rows) and keep them reconciled to source statements.

  • QuickBooks Online: create invoices, record payments and support monthly closing for related entities.

  • Reporting: produce monthly commission summaries and P&L inputs for management.

What we’re looking for

  • 2+ years of insurance commission accounting (agency, FMO/IMO or carrier side). US health or Medicare commissions strongly preferred.

  • Strong Excel and data skills (required):

    • Power Query: combining multiple CSV/Excel statement files from a folder, cleaning and transforming data, refreshing queries

    • Pivot tables: summarizing by carrier, agent, product and month; tying totals back to source

    • Lookups (XLOOKUP / INDEX-MATCH, SUMIFS) and working comfortably with large files

  • Experience reconciling policy-level data (policy/member IDs, effective dates, paid-through dates, chargebacks)

  • QuickBooks Online experience (invoicing, receive payments, bank feeds)

  • Familiarity with a CRM (HubSpot preferred) and carrier/agent portals

  • Very good written English for email follow-ups with US carriers and agents

  • Organized and reliable with recurring deadlines; documents your work so others can follow it

Nice to have

  • Knowledge of ACA/Marketplace, Medicare Advantage or ancillary commission structures (overrides, AOR rules, chargebacks)

  • Power Pivot / data models or Power BI

  • Experience with US payroll or sales tax