Commissions Specialist

BravoTECH; Urbandale (IA); On-site; USD 42,000 - 54,000; Part time

Job summary

BravoTECH in Urbandale, IA is seeking a Commissions Analyst I for a 6+ month onsite role. You will handle commission statements, calculate overrides and bonuses, and reconcile commissions with the General Ledger.

You will also address inquiries from agents, wholesalers, and partners, ensuring accuracy and timely processing. The ideal candidate has strong Excel skills (formulas, PivotTables), solid math and analytical ability, and excellent written and verbal communication.

Qualifications

• Retrieve commission statements from carrier websites and prepare commission files.
• Calculate commission overrides and bonus payments using rate schedules and grids.
• Reconcile carrier statements and commission revenue to the General Ledger.
• Investigate discrepancies, reporting errors, and payment issues with Accounting.
• Manage shared commission inboxes and respond to inquiries from agents and partners.

Responsibilities

• Ensure commission data is accurate, complete, and processed on time.
• Provide excellent customer service with strong attention to detail.
• Support agents and business partners with commission-related questions.

Skills

Excel formulas

PivotTables

Analytical thinking

Written & verbal communication

Research & problem-solving

Attention to detail

Education

Associate degree in accounting

Tools

Microsoft Excel

Microsoft Outlook

Microsoft Word

Adobe Acrobat

Job description

Role: Commissions AnalystLocation: Urbandale, IA – OnsiteDuration: 6 Months +Role OverviewWe are seeking a Commissions Specialist I to manage commission statements, calculate override and bonus payments, reconcile commission revenue with the General Ledger, and support agents and business partners with commission-related questions.Key Responsibilities:Retrieve commission statements from carrier websites and prepare commission files.Calculate commission overrides and bonus payments using rate schedules and compensation grids.Reconcile carrier statements and commission revenue to the General Ledger.Investigate discrepancies, reporting errors, and payment issues with Accounting.Manage shared commission inboxes and respond to agent, wholesaler, and business partner inquiries.Ensure commission data is accurate, complete, and processed on time.Provide excellent customer service and maintain strong attention to detail.Required Skills:Microsoft Excel – formulas and PivotTablesMicrosoft OutlookMicrosoft WordAdobe AcrobatStrong mathematical and analytical skillsExcellent written and verbal communicationStrong research, problem-solving, and attention-to-detail skillsPreferred QualificationsOne or more years of relevant professional experienceExperience in financial services, insurance, or annuitiesAssociate degree in accounting or a related field, or equivalent experienceIdeal CandidateSomeone who is highly accurate, detail-oriented, analytical, customer-service focused, and comfortable working with Excel, financial data, and commission calculations.IND123