Kaeppel Consulting

Position Summary

The Agency Compensation Analyst is responsible to Administer Agent compensation, loan, and SitCom programs. Works with the IT Division and/or Agency Strategic Reporting section to support the creation and maintenance of Agent production reporting. Communicates with field and Home Office management regarding data analysis, Agent compensation, 1099's, and special incentive programs and deductions.

Key Responsibilities

• Administers and maintains Agent compensation programs.
• Coordinates revisions to ERIE informational and operational manuals, monthly reporting, and related communication planning and implementation.
• Researches and assembles litigation information for the Law Division.
• Processes Agent compensation
  • Processes compensation updates-accelerated, reduced, and adjusted commission.
  • Interfaces and balances payment and reduction files.
  • Works interdepartmentally to ensure all commission deductions, loan payments, and required accounts payable checks are processed, balanced and remitted to the correct party.
  • Balances, creates, and reconciles monthly journals for commission processing.

• Maintains and runs custom programs to meet compensation reporting and payment needs.
• Maintains files and responds to requests for production information.
• Calculates data and recommends adjustments as needed.
• Validates and ensures timely and accurate loan, incentive and compensation payment information
• Works with the business and IT Division to support the eliciting, recording and validating of system requirements for new and enhanced Agent compensation programs.
• Updates and processes existing department programs

Qualifications

Education

• Bachelor’s degree in Finance, Accounting, Business Administration, or a related field preferred

Experience

• 1–3 years of experience in compensation analysis, commissions administration, finance, or sales operations preferred

• Experience within the insurance or financial services industry is a plus

Knowledge & Skills

• Understanding of commission structures and incentive compensation programs

• Strong analytical and problem-solving skills

• High attention to detail and accuracy

• Proficiency in Microsoft Excel, including formulas and data analysis

• Experience with payroll or accounting  preferred

• Strong organizational and time management skills

• Excellent written and verbal communication skills

• Ability to manage multiple deadlines and priorities in a fast-paced environment

Key Competencies

• Data analysis and reporting

• Attention to detail

• Integrity and confidentiality with financial information

• Collaboration and cross-functional teamwork