Sales Finance Analyst

CDW LLC.; Cape Town; On-site; ZAR 300,000 - 500,000; Full time

Job summary

A leading IT solutions provider in Cape Town is looking for a professional to support the variable compensation process. You will handle the sales commission calculations, assist in month-end close, and manage queries from sales teams. Ideal candidates should have strong Excel skills and experience in finance. This role offers a great opportunity to contribute to financial processes in a dynamic environment.

Qualifications

• Intermediate or Advanced Excel skills necessary.
• Experience in finance or analytical functions required.
• Strong numerical skills and attention to detail needed.

Responsibilities

• Support sales commission process and models.
• Assist in month-end close for Sales Finance.
• Manage Sales Finance Inbox for query resolution.

Skills

Intermediate or Advanced Excel

Experience within a finance or analytical function

Basic Finance knowledge

Highly numerate with strong attention to detail

Exceptional time management skills

Good interpersonal skills

Analytical mindset

Confident self-starter

Tools

Excel

Job description

Description

At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It’s why we’re coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we’re headed. We’re proud to share our story and Make Amazing Happen at CDW.

Job Summary

This role will perform a key function relating to variable compensation within the CDW UK group. The individual will support the commissions calculation process as well as the Sales Finance function’s month-end close which includes collecting, processing and resolving commission queries from Sales.

What you will do

Support of the the sales commission calculation process and models. This will include tasks such as:

• Reconciliation of data sources to validate commission submission.
• Maintaining commission ledger records on billings and profit.
• Answering queries from Sales teams on commission statements.
• Maintainng and amending individual commission rates and thresholds.
• Identification and delivery of process improvement initiatives to drive efficiency and improved stakeholder experience.

Assist in the Sales Finance close process ensuring the key deadlines are achieved and ensuring all commission queries are resolved. As part of managing the Sales Finance close you will:

• Develop an understanding of the end-to-end sales process, from customer ordering through to commission payable, to help resolve commission-based sales queries.
• Manage the Sales Finance Inbox, ensuring queries are directed to the correct stakeholders for resolution or resolved when possible.
• Collect and process monthly commission charges relating to activities such as freight, rebates and warehousing.
• Handling of queries such as Intercompany, hedging, FX and explain these complex matters back to the business.
• Promote learning on common variable pay issues and implement corrective actions.
• Drive innovation and changes to business practice to reduce conflicts and create efficiencies.

Ad-hoc support for the Sales Finance function

What we expect of you

• Intermediate or Advanced Excel (Knowledge of sum, vlookups, index/match, sumifs & Pivot Tables)
• Experience within a finance or analytical function.
• Basic Finance knowledge.
• Highly numerate with strong attention to detail.
• Exceptional time management skills, working towards strict deadlines whilst handling a demanding workload.
• Good Interpersonal skills with the ability to communicate clearly to a wide range of stakeholders.
• An analytical mindset that logically approaches problems.
• Confident and trustworthy self-starter, able to manage their workload, and collaborate with the wider organisation.

We make technology work so people can do great things.

CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive.

CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law.