Data Analyst

SUMMARY:

Reporting directly to the Director, Data Analytics, the Data Analyst is responsible for auditing and analyzing all monthly commission reports and addendums.  The Data Analyst will be essential in creating and maintaining sales, commissions, business, and financial reporting for the Commissions Department.

ESSENTIAL FUNCTIONS:

• Maintain and build BI reporting
• Audits commission supplier reports and partner commission reports
• Audits Addendums
• Sets up new addendums
• Prepares monthly reports
• Calculates and uploads manual referral fees into RPM
• Coordinates Teaming Program and pay4partner program
• Prepares Sales Partner Variance Report
• Processes commission reports as assigned
• Coordinates VAR Upfront Commission Program
• Prepares monthly New Billings Report
• Prepares Key Indicator Reports for quarterly business review
• Updates the Partner and Supplier Scorecards
• Prepares weekly Channel Manger Order reports
• Prepares business reports as needed
• Prepares partner order reconciliations
• Coordinates Financial Partner Programs
• All other duties as assigned

Supervisory Responsibilities: None

Key Working Relationships: Suppliers, Sales Partners, Internal Colleagues and Supervisor.

EDUCATION / EXPERIENCE & OTHER MINIMUM QUALIFICATIONS REQUIRED:

The minimum qualifications listed below are representative of the knowledge, skill, and ability necessary for an individual to perform each essential duty satisfactorily.  Reasonable amounts of training are provided. 

• A bachelor’s degree in accounting, business, economics, or computer science or a related discipline is required.
• One to three years of similar or related experience.
• Moderate Microsoft Power BI skills, DAX, power query, SQL
• Advanced Microsoft Excel skills, including pivot tables, Macro’s, vlookups, etc.
• High attention to detail and ability to be flexible and learn quickly
• Accounting and financial analysis experience a plus
• Experience with computerized accounting software a plus
• Experience with databases a plus
• Excellent organization skills
• Must be reliable, maintain consistent attendance and meet strict deadlines
• Ability to prioritize tasks and complete work assignments with minimal supervision
• Ability to follow through and bring assignments to closure
• High attention to detail and ability to be flexible and learn quickly
• Ability to work in a cooperative and team environment, as well as the ability to work independently
• Telecom industry experience a plus

COMPENSATION:

Compensation Range: $50,000 - $60,000 annually

Actual annual salary offered to a candidate will be based on a number of variables including work experience, education and skills/ achievements, and will be mutually agreed upon at the time of offer.  This position is not eligible for a variable pay component as part of the hiring range.

While we’re committed to providing top-tier solutions, we’re just as committed to supporting our own team. Our employees enjoy a variety of comprehensive benefits, including medical/dental/vision coverage, life insurance, and a 401(k) plan with matching provision.  Outside of CA, ScanSource grants 128 hours of paid time off (PTO) each calendar year (prorated for date of hire).   In the state of CA, employees accrue a set number of hours each pay period equaling the same 128 hours of PTO.  ScanSource also celebrates 8 paid company holidays.

ScanSource, Inc. is an Equal Opportunity Employer

EOE/M/F