Senior Accounting Financial Analyst (Variable Compensation)

Wesco; Annville (Lebanon County); On-site; USD 90,000 - 130,000; Full time

Job summary

Wesco seeks a Senior Accounting Financial Analyst to prepare and coordinate forward-looking financial projections, forecasts, and reports while supporting strategic decision-making. This role includes calculating and documenting variable pay programs, such as sales commissions, from multiple systems.

The ideal candidate will gather data, conduct profitability analyses across business lines, assist in annual budgeting, monitor performance, and collaborate with finance and sales to ensure accurate

Qualifications

• Bachelor's degree in Accounting, Finance, or business-related field.
• 3 years financial analysis experience including discounted cash flow.
• 1 year data query extraction and analytics experience.
• 1 year profit and loss and balance sheet forecasting and management experience.
• Experience managing variable compensation programs, including data preparation, validation, and calculation of commissions.
• Strong mathematical skills with ability to analyze numerical data and perform complex calculations.
• Strong communication and presentation skills.
• Proficiency with Microsoft Office Suite - High proficiency in Excel.
• Strong teamwork, collaboration, and problem-solving skills.
• Managing and organizing large amounts of data.
• Ability to prioritize and handle multiple projects and deadlines.
• Ability to analyze financial data and prepare financial reports, statements, and projections.
• Report writing utilizing Hyperion and Oracle.
• Short and long-term budgeting and forecasting, rolling budgets, and product-line profitability analysis is preferred.

Responsibilities

• Gather data from multiple sources to support a complex and dynamic variable pay program.
• Respond to inquiries from Finance, sales leaders, or managers regarding data used to calculate commissions.
• Interact with sales managers and sales employees to help them understand reports.
• Develop and manage profitability analysis across multiple lines of business.
• Enhance and maintain standardized approaches in analyzing, evaluating, and obtaining approvals for financial support of RFPs, bids, and proposed contracts.
• Evaluate actual performance on contracts vs. proposed.
• Coordinate across functions and business units to obtain information and input on key assumptions and variables.
• Support development of unit's annual budget, and tracks and analyzes variances throughout year.
• Monitor progress toward objectives.
• Identify issues and suggest courses of action, make recommendations for improving operations and resource allocation.
• Perform additional strategic analytical functions.
• Conduct detail end of period review of financials to ensure proper reporting.
• Monitor sales and margins to ensure appropriate billing margin is earned.
• May provide direction and support to more junior analysts.

Skills

Financial analysis

Data extraction

Forecasting

Communication

Presentation

Teamwork

Data management

Problem solving

Attention to detail

Data analytics

Education

Bachelor's degree in Accounting/Finance

Tools

Excel

Hyperion

Oracle

Job description

Description

As a Senior Accounting Financial Analyst, you will prepare, coordinate, and document forward-looking financial projects, including forecasts and reports, while providing analytical support to drive strategic decision-making. You will also manage the calculation and documentation of variable pay programs, such as sales commissions, by extracting and organizing data from various systems. This role combines financial analysis and compensation processing to ensure accurate reporting and impactful business insights.

Responsibilities:

• Gather and prepare data from multiple sources to support a complex and dynamic variable pay program for the assigned BU, while also assisting in developing a strategic plan to optimize and enhance program effectiveness.
• Respond to complex inquiries from Finance, sales leaders, or managers regarding the data used to calculate commissions, assessing whether the calculations align with the intent of the plan. Adjust information if discrepancies are identified to ensure sales compensation is accurate and effectively track results.
• Interact with sales managers and sales employees to help them understand the reports they are receiving and regarding transactions and variable pay programs.
• Develop and manage profitability analysis across multiple lines of business.
• Enhance and maintain standardized approaches in analyzing, evaluating, and obtaining approvals for financial support of RFP's, bids, and proposed contracts.
• Evaluate actual performance on contracts vs. proposed.
• Coordinate across functions and business units to obtain information and garner input on key assumptions and variables.
• Support development of unit's annual budget, and tracks and analyzes variances throughout year.
• Monitor progress toward objectives.
• Identify issues and suggests courses of action, makes recommendations for improving operations, and resource allocation.
• Perform additional strategic analytical functions.
• Conduct detail end of period review of financials to ensure proper reporting.
• Monitor sales and margins to ensure appropriate billing margin is earned.
• May provide direction and support to more junior analysts.

Qualifications:

• Bachelors' Degree - Accounting, Finance, or business related required
• 3 years required of financial analysis experience; including discounted cash flow
• 1 year required of data query extraction and analytics experience
• 1 year required of profit and loss and balance sheet forecasting and management experience
• Experience in managing and analyzing variable compensation programs, including data preparation, validation, and calculation of commissions
• Strong mathematical skills with the ability to analyze numerical data, perform complex calculations, and ensure accuracy in variable compensation structures
• Strong communication and presentation skills with ability to translate complex analytical data into easily understandable format
• Proficiency with Microsoft Office Suite - High proficiency in Excel
• Strong teamwork, collaboration, and problem-solving skills
• Managing and organizing large amounts of data
• Ability to prioritize and handle multiple projects and deadlines
• Ability to analyze financial data and prepare financial reports, statements, and projections
• Report writing utilizing Hyperion and Oracle
• Short and long-term budgeting and forecasting, rolling budgets, and product-line profitability analysis is preferred

#LI-RA1