Senior Financial Analyst: Variable Pay & Forecasting

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

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