Senior Commissions Analyst

Shamrock Trading Corporation; Overland Park (KS); On-site; USD 70,000 - 110,000; Full time

Job summary

Shamrock Trading Corporation in Overland Park, KS is seeking a Senior Commissions Analyst to ensure accurate, transparent and timely distribution of variable compensation for quota-bearing employees and external agents. You will work with Sales, Finance, HR and Accounting to streamline commissions processes.

Ideal candidates bring 5+ years in financial/sales analytics, strong Excel and Salesforce experience, and a proven ability to handle confidential information in a fast-paced environment.

Qualifications

• Bachelor's degree in accounting or finance or related area.
• 5+ years of experience as a financial analyst, sales analyst, sales operations support or commission analyst.
• Experience supporting a sales organization with multi-currency and FX rates.
• Strong understanding of sales compensation concepts: quotas, attainment, rates, draws, splits and claw backs.
• Proficient with Excel; Salesforce experience is a plus.

Responsibilities

• Understand commission structures and calculations to process payments accurately and timely.
• Prepare and review commission reports for accuracy and reconciliation.
• Develop financial reporting/analysis related to commissions for various stakeholders.
• Investigate and respond to commission variances in a timely, professional manner.
• Leverage IT to enhance data analysis and predict future commissions based on sales behavior.
• Review processes for improvements and collaborate on automation where feasible.
• Identify and implement daily process improvements.
• Support additional accounting or operational projects as assigned.

Skills

Financial analysis

Sales analytics

Excel proficiency

Attention to detail

Multitasking

Confidentiality

Cross-functional collaboration

Education

Bachelor's degree in accounting or finance

Tools

Salesforce

Microsoft Excel

ERP systems

Job description

About the Role

Shamrock Trading Corporation is looking to add a Senior Commissions Analyst to the team. As a Senior Commissions Analyst, you will work cross-functionally with leaders in Sales, Finance, HR, and Accounting. The primary responsibility will be to ensure variable compensation for our quota-bearing employees and external agents is distributed with accuracy, transparency, and on schedule.

What You’ll Do

• Understand the various commission structures and calculations to process payments accurately and timely for multiple business units according to compensation plans and internal policies
• Prepare and review commission reports for accuracy and completeness - reconciling any issues through cross-functional collaboration
• Responsible for developing and providing sales leaders, finance, HR and any other departments various financial reporting/analysis related to commissions on a recurring and/or on an ad-hoc basis
• Research and respond to commission-related variances as requested by management or commissioned employees in a timely, diplomatic and professional matter
• Leverage information technology to enhance data analysis on commission plans to predict future commissions based on sales behavior
• Consistently review processes and procedures for improvement opportunities and efficiency enhancements, including partnering with development to automate processes and reports where feasible
• Identifying and implementing process improvementsin daily processes
• Additional accounting or operational projects as assigned

What You’ll Bring

• Bachelor’s degreein accountingor finance preferred(or related areas)
• 5+ years of experience as a financial analyst, sales analyst, sales operations support or commission analyst role
• Experience supporting a sales organization, including working with multiple currencies and FX Rates
• Comprehensive understanding of sales compensation concepts, including quotas, attainment, rates, draws, splits and claw backs
• Proficient in Microsoft Office Products, especially Microsoft Excel
• Hands-on experience using Salesforce strongly preferred but not required
• High energy and ability to multi-task
• Exceptional analytical skills and attention-to-detail
• Strong auditing skills to ensure accuracy and compliance
• Ability to solve complex problems
• Demonstrated capacity to handle and maintain confidential information
• Thrives in a high volume, fast-paced environment
• Effectively prioritize tasks and manages time efficiently