Broker Commissions Analyst

Important things YOU should know:

• Fully Remote Opportunity
• Schedule: Monday - Friday - 8:00am - 4:30pm CST with the potential to flex schedule
• Previous SQL experience

What will YOU be doing? Will have the opportunity to manage all activities and analytics associated with complex broker commissions processing. Generate and distribute broker commission's reports to clients. Key aspect of role is ensuring timely and accurate commission payments which are payroll for brokers and agents. Monitor the Enterprise system technical commissions processing rules to ensure they are functioning as expected.

What will YOU be working on?

• Responsible for ensuring all monthly broker commissions are paid according to client schedules including the management of regular and tiered commissions handling.
• Ensure accurate payments of broker commissions.
• Identify opportunities to improve business processes including system performance.
• Develop, enhance and maintain comprehensive procedures and workflows.
• Effectively manage complex business challenges, tight deadlines, competing priorities and interactions with the management team.
• Prepare and implement various reports for operational areas to utilize on a go-forward basis to allow for appropriate management of processes.
• Work directly with client on any questions and discrepancies found in the cycle run. Troubleshoot issues identified.
• Coordinate with the Finance team regarding release and holds needed on cycle runs. Provide direction as needed.
• Utilizing SQL queries, run and manage on-going audit process to ensure accuracy of commissions system processing.
• Escalate to technical support and developers any potential issues in systems processing. Work with these individuals to resolve issues.
• Represent the Billing, Enrollment and Commissions team on all projects related to commissions handling.
• Primary resource for testing broker commissions processing for system upgrades and enhancements. This includes development of test scenarios, maintenance of test plans, providing appropriate feedback, documenting test results and developing respective documentation.
• Train other resources on basics of commissions processing. Monitor work output and accuracy of trained resources.

Additional Responsibilities:

• Prepare ad hoc reports and analysis as needed.
• Assist with other billing and enrollment processing, as needed.
• Assist with auditing of others work on the Billing, Enrollment and Commissions Team, as needed.
• Participate in other departmental projects, when applicable.

What qualifications do YOU need to have to be a GOOD candidate?

Required Level of Education, Licenses, and/or Certificates

• Bachelor's degree in a related field or work experience equivalent.

Required Level of Experience

• 2+ years related experience in an analytical role (areas of experience can include: commissions, finance, billing, accounts receivable and/or administrative processing)

Required Knowledge, Skills, and Abilities

• Advanced user of MS Office Suite
• Demonstrated experience working with SQL (Structured Query Language)
• Knowledge of and ability to interpret SQL
• Ability to analyze data from various databases
• Demonstrated problem solving skills
• Strong written and verbal communication skills
• Ability to explain complex concepts easily
• Ability to build and maintain work relationships and contacts needed to effectively address issues and obstacles.

What qualifications do YOU need to have to be a GREAT candidate?

Preferred Level of Education, License, and/or Certificates

• Additional coursework in business analytics (can include certifications or college coursework)

Preferred Level of Experience

• Prior knowledge working in a healthcare, health or dental insurance environment

Preferred Knowledge, Skills, and Abilities

• Knowledge of mainframe systems