Job Description
Job Description
Responsibilities :
Commissions and Spiffs Analysis :
- Track and validate all payroll changes (new hires, terminations, promotions, and transfers) to ensure these changes are accurately factored into the monthly commission calculations.
- Assist in preparing monthly commission statements, including those generated via our automated system or manually in Excel.
- Support the processing, reporting, and analysis of commission payroll for monthly payouts, working with management to confirm accuracy and make adjustments as needed.
- Research compensation issues or disputes and provide analysis to facilitate resolution.
- Prepare monthly commission reconciliations and assist with other ad hoc reporting / analysis
- Assist with annual commission contract and schedule administration.
Corporate Reporting and Analysis :
Assist with the implementation and automation of consolidated monthly reporting, including commentary in BI tools / systems, to provide post-close insights on notable variances and financial / non-financial KPIs.Compile, analyze, and report financial, sales, and statistical data (such as sales, expenses, operating working capital, performance flash reporting, cash forecasting, capital expenditures, and operating statistics) from multiple systems.Collaborate with department managers and senior staff to provide quantitative financial analysis of operational and financial data in support of strategic growth, including the creation of dashboards and ongoing reporting for future use.Demonstrate the ability to conduct analysis and complete tasks with limited supervision, maintaining a solutions-oriented attitude when tackling new projects.Other Tasks and Responsibilities :
Take the initiative to collaborate with various business segments to identify ways the finance department can further support business needs, implementing related projects and reports as necessary for ongoing support.Partner with management to plan and improve systems and processes, including expanding current BI tools for streamlined reporting.Serve as a backup for other analyst responsibilities as directed by finance management.Collaborate with the Director of Finance and various department managers on complex projects.Work cooperatively with others and comply with all company policies and procedures. Perform other duties as assigned.Requirements :
Bachelor degree in Finance, Accounting or Business AnalyticsMinimum 2 years’ experience of working knowledge of sales incentive compensation principles and related operational execution2 or more years of experience as a Staff Accountant or Financial Analyst, a plusAdvanced software skills in Microsoft Office, highly advanced skills in ExcelRequired experience building interactive dashboards and reports in Tableau to support business decision-making and / or actionable insightsPreferred experience with SAP and other similar data analytics ERPsPreferred experience with any Sales Commissions Management softwareDetail oriented with strong analytical problem solving abilityAbility to work as a team player and work in a deadline based environment