Commission Analyst (Mumbai Based)

Company Description

QAD is building a world-class SaaS company, and we are growing. We are looking for talented individuals who want to join us on our mission to help solve relevant real-world problems in manufacturing and the supply chain.

We are a virtual first company and your primary work experience will be virtual / working from your home. Occasional travel to a physical office may be required to enhance working relationships, collaboration, design, strategy and alignment.

Job Description

The Commission Analyst plays a vital role in ensuring accurate and timely calculation and processing of sales commissions. This individual will be responsible for maintaining commission data, analyzing trends, and communicating effectively with various stakeholders. This role is crucial for supporting our sales team's motivation and ensuring our financial records are accurate.

Commission Calculation:

• Calculate sales commissions for [specify sales force - e.g., internal sales team, independent reps, distributors] based on established compensation plans and sales data.

• Ensure accuracy and timeliness of commission payments.

• Develop and maintain comprehensive spreadsheets and databases for tracking commission data.

Analysis:

• Analyze commission trends, identifying key performance indicators (KPIs) and areas for improvement.

• Provide regular reports to management on commission expenses, variances, and potential budget implications.

• Conduct ad-hoc analysis to support business decision-making related to sales compensation.

Month-End Close:

• Prepare and post accurate journal entries for commission accruals and expenses.

• Reconcile commission-related accounts and ensure proper documentation.

• Assist with the overall month-end close process for the accounting department.

Communication and Query Resolution:

• Respond to inquiries from sales representatives and managers regarding commission calculations and payments.

• Effectively communicate commission policies and procedures to relevant stakeholders.

• Collaborate with sales operations and other departments to resolve commission-related issues.

Qualifications

Professional degree: Bachelor's degree in Finance, Accounting, or related field preferred.

Graduate Program (MBA, MIB or Masters): 

Number of years: 2-4 years of experience in analysis & reporting or a similar role like data analysis (Although the role is focussed to commissions)

Computer skills: Strong on Microsoft Excel (including macro's) and other data analysis tools. 

Knowledge of Access would be an advantage / must have

Other knowledge / skills: 

• Good understanding of accounting principles and practices.

• Excellent attention to detail and accuracy.

• Strong communication and interpersonal skills.

• Ability to work independently and as part of a team.

Additional Information

Review the potential task list 

Setting up Sales Comp Plans and Generating the files to provide PCR's for each employee

• Create the PDF versions of the Sales Comp Plans with PCR's

• Set up all of the Sales Comp Plans in Liferay

• Push the plans through for approval

• Chase up any outstanding Comp Plans

Set up database for any updates to rules for commissions

Will need to be set up at the start of the financial year once the final Sales, but depending on what rules need to be applied, it could mean changes to the following:

⦁ Access db

⦁ Salesforce Reports

⦁ Excel FIles (including macro's)

Generate monthly accruals for QAD & QRZ

• Pull together all of the updated raw data to create the accruals

• Create accruals data

• Review accruals data against prior month data and details from Salesforce

• Book the accruals

Generate monthly payments for QAD & QRZ

• Pull together all of the updated raw data to create the payments

• Create payments data

• Review the payments against the corresponding accruals data (2 months prior) and against prior month payment data and details from Salesforce.

• Review the payments against the rules set at the start of the year

• Send payments for approval

• Send payments to payroll (non-US entities get loaded directly in to Workday, US payments get sent to US payroll team

About QAD:

QAD Inc. is a leading provider of adaptive, cloud-based enterprise software and services for global manufacturing companies. Global manufacturers face ever-increasing disruption caused by technology-driven innovation and changing consumer preferences. In order to survive and thrive, manufacturers must be able to innovate and change business models at unprecedented rates of speed. QAD calls these companies Adaptive Manufacturing Enterprises. QAD solutions help customers in the automotive, life sciences, packaging, consumer products, food and beverage, high tech and industrial manufacturing industries rapidly adapt to change and innovate for competitive advantage.

QAD is committed to ensuring that every employee feels they work in an environment that values their contributions, respects their unique perspectives and provides opportunities for growth regardless of background. QAD’s DEI program is driving higher levels of diversity, equity and inclusion so that employees can bring their whole self to work.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. 

#LI-Remote