Sr Commission Analyst

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. The Senior Commissions Analyst calculates commissions earned by coworkers in the Sales organizations and analyzes commission trends. This role also generates and improves reporting of the commission figures
What you will do:
* Determine earned commissions for Sales coworkers monthly by:
* Preparing commission earnings. Including calculation and testing system generated calculations to ensure accuracy and reasonableness of earnings.
* Ensuring the commission payment file is prepared in a timely manner.
* Sharing data with Sales Management to validate the accuracy and completeness of calculations.
* Design and develop analyses to identify drivers and trends of commission earnings.
* Researching and responding to inquiries and requests for adjustments from the Sales and Finance workforces, related to adjustments, invoices, freight, returns, etc.
* Providing support and guidance for other Commission Analyst(s) in processing all adjustments submitted.
* Performing User Acceptance Testing for Sales Compensation related system implementations and plan changes.
* Identify and participate as a team member in opportunities to improve or automate work that will result in more accurate commission payments and/or reduce the cycle time of commission processes.
* Training Sales Coworkers on compensation plan changes, system changes and/or reporting changes
What we expect of you:
* Bachelor's degree in Accounting or Finance and 5 years of experience in financial analysis and/or commissions/incentive compensation, OR 9 years of experience in financial analysis and/or commissions/incentive compensation
* Advanced Excel skills including, but not limited to, creation of pivot tables and formula creation
* Demonstrated technical and analytical skills, with the ability to be resourceful
* Excellent written and verbal communication skills with the ability to effectively interact with coworkers at all levels including senior leadership
* Strong attention to detail
* Demonstrated ability to identify areas of process improvement and make appropriate recommendations
* Handle complicated/complex situations and apply documented business policies to solve issues with little supervision
* Ability to prioritize many projects at once
* Working knowledge or familiarity with AS/400, TrueComp and ChangePoint,IBM ICM
* Financial Planning and Analysis knowledge
* 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.