Sales Analyst

Matthews Professional Employment, Inc.; Libertyville (IL); On-site; USD 90,000 - 110,000; Full time

Job summary

Matthews Professional Employment, Inc. in Libertyville, IL seeks a detail-oriented Sales Analyst / Financial Analyst to partner with sales leadership and finance to analyze performance and develop reports that support informed business decisions.

Responsibilities include analyzing sales results, preparing forecasts and dashboards, supporting budgeting, and improving reporting tools. Requires 5+ years in analytics, a finance-related degree, advanced Excel and experience with ERP or Power BI.

Qualifications

• 5+ years of experience in sales analysis, financial analysis, business analytics, or a related role.
• Bachelor's degree in Finance, Accounting, Business Administration, or a related field preferred.
• Advanced Microsoft Excel skills, including PivotTables, XLOOKUP, and complex formulas.
• Experience analyzing sales, financial, and operational data.
• Ability to develop reports, interpret trends, and present findings to management.
• Experience with ERP systems, Power BI, or other reporting tools preferred.
• Manufacturing or distribution industry experience preferred.

Responsibilities

• Analyze sales results, revenue, profitability, customer performance, and business trends
• Prepare financial reports, sales forecasts, performance dashboards, and management summaries
• Identify trends, risks, and opportunities to improve profitability and business performance
• Support budgeting, forecasting, and financial planning activities
• Partner with sales leadership and finance to evaluate results and support strategic decisions
• Develop, maintain, and improve Excel-based reporting tools and analytical models
• Review sales and financial data for accuracy, consistency, and completeness
• Recommend process improvements to increase reporting efficiency and support operational goals
• Assist with special projects and additional analysis as business needs evolve

Skills

Advanced Excel

PivotTables

XLOOKUP

Complex formulas

Reporting tools

Power BI

ERP systems

Education

Bachelor's degree in Finance, Accounting, Business Administration

Tools

Power BI

ERP systems

Job description

Job Description

Job Description

Applicants must currently reside within commuting distance of Libertyville, IL, including nearby areas of Illinois and Wisconsin. Relocation assistance is not available.

Sales Analyst / Financial Analyst

We are seeking a detail-oriented Sales Analyst / Financial Analyst for a growing manufacturing organization in the Libertyville, IL area. This position will partner with sales leadership and finance to analyze business performance, track financial and sales trends, and develop reports that support informed business decisions.

Requirements of the Sales Analyst / Financial Analyst

• 5+ years of experience in sales analysis, financial analysis, business analytics, or a related role
• Bachelor's degree in Finance, Accounting, Business Administration, or a related field preferred
• Advanced Microsoft Excel skills, including PivotTables, XLOOKUP, and complex formulas
• Experience analyzing sales, financial, and operational data
• Ability to develop reports, interpret trends, and present findings to management
• Experience with ERP systems, Power BI, or other reporting tools preferred
• Manufacturing or distribution industry experience preferred

Responsibilities of the Sales Analyst / Financial Analyst

• Analyze sales results, revenue, profitability, customer performance, and business trends
• Prepare financial reports, sales forecasts, performance dashboards, and management summaries
• Identify trends, risks, and opportunities to improve profitability and business performance
• Support budgeting, forecasting, and financial planning activities
• Partner with sales leadership and finance to evaluate results and support strategic decisions
• Develop, maintain, and improve Excel-based reporting tools and analytical models
• Review sales and financial data for accuracy, consistency, and completeness
• Recommend process improvements to increase reporting efficiency and support operational goals
• Assist with special projects and additional analysis as business needs evolve

Full-Time, DIRECT HIRE

Pay is $90,000 - $110,000 annually, based on experience

If you have an open application with Matthews Professional Employment, Inc., please express your interest in this position to your consultant

Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person.