Strategic Variable Compensation Data Analyst

Wesco; Pittsburgh (Allegheny County); On-site; USD 59,000 - 76,000; Full time

Job summary

Wesco in Pittsburgh is seeking an Analyst - Variable Compensation to prepare, coordinate, and document incentive programs. You will extract data from multiple systems, calculate payments, and provide analytics and guidance to sales leaders and finance.

Ideal candidates have a Bachelor's in business, finance, or accounting, 2 years' experience with large data sets, strong Excel skills, and knowledge of internal controls and SOX.

Qualifications

• Bachelor's Degree in Business, finance, or accounting or related required
• 2 years of relevant work experience, specifically with large data sets
• Understanding of internal controls and SOX requirements
• Strong overall business skills and common-sense approach to issues
• Effective communication and presentation skills with ability to translate analytical data into easily understandable format
• Strong teamwork and collaboration skills
• Proficiency with Microsoft Office
• Report writing experience is preferred

Responsibilities

• Extract and prepare data from various sources and systems to facilitate variable compensation programs.
• Use prepared data to calculate various types of variable compensation payments.
• Provide analyses and recommendations based on gathered variable compensation data and other pertinent information.
• Provide guidance and support to sales managers and sales employees on reports, transactions, and variable pay programs.
• Respond to questions from Finance, sales leaders or managers regarding data used to calculate commissions.
• Identify issues and suggest courses of action.
• Work closely with corporate and business unit resources to support implementation of process improvements and best practices.
• Communicate and ensure compliance with policies and procedures.
• Record the necessary month end accruals and reconciliations.

Skills

Data analysis

Communication

Teamwork

Report writing

Microsoft Excel

Education

Bachelor's degree in Business/Finance/Accounting

Tools

Microsoft Office

Job description

Wesco in Pittsburgh is seeking an Analyst - Variable Compensation to prepare, coordinate, and document incentive programs. You will extract data from multiple systems, calculate payments, and provide analytics and guidance to sales leaders and finance.

Ideal candidates have a Bachelor's in business, finance, or accounting, 2 years' experience with large data sets, strong Excel skills, and knowledge of internal controls and SOX.