
Commission System Analyst
Transamerica
full-time
Posted on:
Location Type: Hybrid
Location: Cedar Rapids • Colorado • Iowa • United States
Visit company websiteExplore more
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