Commission System Analyst

Transamerica•Cedar Rapids, IA

3d•$56,000 - $66,000•Hybrid

About The Position

Serve as a strategic subject matter expert for compensation and commission systems, driving alignment between business objectives and technology solutions. Conduct semiweekly commission cycles.

Requirements

Bachelor's degree in accounting or business field, or equivalent experience
Three plus years of experience with commission systems or related system QA/testing
Knowledge of commissions processing, system rules, and agent debt processes
Analytical and problem-solving ability
Verbal and written communication skills
Ability to work under pressure of deadlines and outside of normal working hours
Decision-making and organizational skills
Strong MS Excel skills
Knowledge of MS SQL

Nice To Haves

Background in the insurance/financial services industry

Responsibilities

Responsible for semi-weekly commission cycles, including ACH transmissions for field agents, for multiple providers in the U.S. including Puerto Rico, and Canada.
Oversee all commission system related data to include retrieving, logging, and loading electronic commissions into appropriate systems for processing and resolve system errors encountered during file loading.
Perform complex research using MS SQL queries to independently identify and resolve commission errors or inquiries.
Research and provide timely responses to debt rollup related inquiries for field agents and collection agencies through analysis of balances and roll up history and assist with debt reporting.
Conduct comprehensive balance reviews and perform cash flow analysis to assess long-term debt eligibility.
Develop test plans and oversee validation of system enhancements within the commission platform.
Execute advanced quality assurance audits on commission processes to detect discrepancies, resolve, conflicts, and mitigate potential risks.
Lead and collaborate in department projects as needed.

Benefits

Competitive Pay
Bonus for Eligible Employees
Benefits Package
Pension Plan
401k Match
Employee Stock Purchase Plan
Tuition Reimbursement
Disability Insurance
Medical Insurance
Dental Insurance
Vision Insurance
Employee Discounts
Career Training & Development Opportunities
Health and Work/Life Balance Benefits
Paid Time Off starting at 160 hours annually for employees in their first year of service.
Ten (10) paid holidays per year (typically mirroring the New York Stock Exchange (NYSE) holidays).
Be Well Company holistic wellness program, which includes Wellness Coaching and Reward Dollars
Parental Leave – fifteen (15) days of paid parental leave per calendar year to eligible employees with at least one year of service at the time of birth, placement of an adopted child, or placement of a foster care child.
Adoption Assistance
Employee Assistance Program
Back-Up Care Program
PTO for Volunteer Hours
Employee Matching Gifts Program
Employee Resource Groups
Inclusion and Diversity Programs
Employee Recognition Program
Referral Bonus Programs