Transamerica

Commission System Analyst

Transamerica

full-time

Posted on:

Location Type: Hybrid

Location: Cedar RapidsColoradoIowaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $56,000 - $66,000 per year

Tech Stack

About the role

  • 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.

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
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
  • 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
  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
MS SQLcommission systemsquality assurancecash flow analysisdata analysistest planssystem enhancementsproblem-solvingdata loggingACH transmissions
Soft Skills
analytical abilityverbal communicationwritten communicationdecision-makingorganizational skillsability to work under pressurecollaborationleadership
Certifications
Bachelor's degree in accountingBachelor's degree in business