Producer Commission Analyst

JOB SUMMARY

Individual will be responsible for the accurate and timely calculation, reconciliation, reporting, and analysis of producer commissions across the company and its member agencies. This role will leverage AI and automation tools to streamline commission processes.

MAJOR DUTIES AND RESPONSIBILITIES

- Calculate, review, and process monthly & quarterly producer commissions, overrides, and bonuses in accordance with commission agreements and company policy.
- Prepare monthly commission accruals, journal entries, and account reconciliations to support the monthly, quarterly, and yearly close processes.
- Develop and maintain commission models and reports to support forecasting, budgeting, and strategic initiatives, including analysis of new or proposed compensation plans.
- Support the integration of commission processes and data for newly acquired agencies.
- Serve as a point of contact for producers, account managers, and carriers on commission inquiries, providing clear and timely resolution.
- Maintain commission schedules, rate tables, and producer splits; ensure compliance with internal controls and audit requirements.
- Identify and implement opportunities to automate and improve commission processes, including the use of AI tools for reconciliation, variance detection, and reporting.

QUALIFICATIONS & SKILLS

- Bachelor’s degree in Finance, Accounting or related field
- 2-5 years’ experience in commissions, finance, accounting, or payroll, preferably within an insurance agency, brokerage, or carrier.
- High level command of Excel (Pivot tables, XLOOKUP, formulas, charts etc.)
- Strong reconciliation and analytical skills with high attention to detail and accuracy.
- Understanding of insurance commission structures (new vs. renewal, direct bill vs. agency bill, splits) strongly preferred.
- Strong written and verbal communication skills;
- Ability to work in a fast-paced environment and manage multiple deadlines, including month-end close.
- Preferred: demonstrated experience using AI tools (e.g., Microsoft Copilot, ChatGPT, Claude) to automate workflows, analyze data, or improve reporting accuracy and efficiency.
- Agency management system experience (e.g., Applied Epic, AMS360) a plus.