Previous Job
Ref No.: 18-03459
Location: Scottsdale, Arizona
Start Date / End Date: 10/22/2018 to 04/12/2019
Prepare monthly incentive calculations for all incentive plans
Perform monthly incentive account reconciliations
Develop incentive and commission projections during annual budget process
Gather data from multiple sources, develop models for analysis of various plan design options, and review incentive payout
Plan and model commission expense in collaboration with Division executives, Finance and Corporate Compensation
Support implementation and ongoing administration of incentive plans
Forecast quarterly and annual commission/bonus program expenses
Provide quota attainment reporting to division management
Conduct regular audits for plan compliance
Performs general ad hoc analysis of financial and operational data for trends and variances and present findings to finance management
Uses historical trend information along with changes in market and business environments to create projections used for the budgeting or forecasting processes
Identifies trends and developments in competitive environments
Manage large data sets from disparate sources for data mining, analysis, and research projects
Develops and documents procedures to streamline processes and ensure compliance with company processes and procedures
No Visa candidates. Candidates must be authorized to work in U.S. and do not require sponsorship for employment

Finance & Accounting – experience in finance, economic and accounting principles and practices, the financial markets, financial statements, and valuation, analysis and reporting of financial data
Mathematics & Analytics – ability to understand, manipulate and solve problems using mathematics on large data sets
Computer Skills – advanced knowledge of Microsoft Office Suite, particularly Excel and PowerPoint
Problem Solving – identifying problems and reviewing related information to develop and evaluate options and implement solutions
Organizing, Planning & Prioritizing Work – developing specific goals and execution plans for the completion of tasks
Good Communication Skills – both written and verbal
Critical Thinking – using login and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems
Judgment & Decision Making – considering the relative costs and benefits of potential actions to choose the most appropriate course of action
Familiar with standard concepts, practices and procedures of the business
Maintaining confidentiality
Desired skills:
• Advanced MS Excel
• Know VBA. If also know SQL is a plus.
• Able to multitask and work independently
• Detail oriented
• Able to analyze and work on large data set using very complex excel formula.
• Has 2-3 years of work experience.