Business Analyst

ESSENTIAL JOB FUNCTIONS:

- Run reporting and create weekly Compensation Schedule contracts out of Siebel and deliver to Sales.
- Process new and maintain W-9 and ACH payment data in AP systems and Broker Payment Tool.
- Prepare and verify commissions and obtain approval for Commercial third parties using MS Access and the Broker Payment Tool.
- Use SQL queries and MS Excel to prepare and verify commission reports, obtain approval and submit payment requests for Mass Market Brokers.
- Liaison with Sales and Brokers on Compensation Schedule and payment issues.
- Contribute to process improvement and collaborate with other departments to enhance efficiency and accuracy of business processes.
- Participate and contribute to integration efforts.
- Identify, research, and resolve commission inquiries using Siebel, LODESTAR, Broker Payment Tool and Partner Portal.
- Weekly reporting, other duties, and special assignments as needed.

SKILLS:

EDUCATION/EXPERIENCE:

- 4 Year College Degree.
- 3+ years experience in a job that requires strong attention to detail.
- Proficiency with Microsoft Office applications, including Microsoft Access with demonstrated understanding of relational database concepts.
- 1+ years experience using MS Excel demonstrating skill using VLookups functions.
- Experience effectively and accurately interacting communicating with both internal and external customers in writing, and over the phone.
- English Proficiency is required.
- High degree of initiative and strong analytical skills.
- Experience multitasking to meet short term, dynamic deadlines.
- Team player with positive attitude.