Sales Analyst

CVG Sprague Devices; New Albany (OH); On-site; USD 65,000 - 90,000; Full time

Job summary

Commercial Vehicle Group, Inc in the United States is seeking a Sales Analyst to support pricing, cost recovery, and margin protection. The role emphasizes analyzing raw material changes, tariffs, supplier price increases, and other cost pressures, then supporting customer price recovery actions with detailed Excel models and Power BI dashboards.

The successful candidate will have strong analytical capabilities, advanced Excel skills, and experience with data visualization and ERP systems.

Qualifications

• Bachelor's degree in Business, Finance, Accounting, Economics, Supply Chain, Data Analytics, or a related field preferred.
• Experience analyzing pricing, cost, margin, or financial data strongly preferred.
• Manufacturing or automotive/commercial vehicle industry experience is beneficial but not required.
• Advanced Microsoft Excel skills, including PivotTables, lookups, complex formulas, data manipulation, and financial modeling.

Responsibilities

• Analyze cost increases associated with raw materials, tariffs, supplier pricing, freight, and other inflationary impacts.
• Develop supporting analysis for customer price increase and price recovery initiatives.
• Calculate the financial impact of cost changes and determine required customer recovery amounts.
• Track price recovery opportunities from identification through customer implementation.
• Compare requested versus realized price recovery and identify gaps requiring additional commercial action.
• Support Sales leadership and account teams with data and documentation needed for customer pricing discussions.
• Maintain historical pricing and recovery information to improve visibility to commercial performance.

Skills

Data analysis

Financial modeling

Analytical thinking

Excel

Cross-functional collaboration

Education

Bachelor's degree

Tools

Power BI

ERP systems

Job description

Position Summary

The Sales Analyst supports the Commercial and Sales organization by providing financial and data analysis focused on customer pricing, cost recovery, and margin protection. A primary responsibility is analyzing the impact of raw material changes, tariffs, supplier price increases, and other cost pressures, then supporting the development, tracking, and execution of customer price recovery actions.The successful candidate will have strong analytical capabilities, advanced Microsoft Excel skills, and experience using data visualization and analytical tools such as Power BI. Training will be provided on company products and navigation of applicable ERP systems.

Key Responsibilities

Price Recovery & Commercial Analysis

• Analyze cost increases associated with raw materials, tariffs, supplier pricing, freight, and other inflationary impacts.
• Develop supporting analysis for customer price increase and price recovery initiatives.
• Calculate the financial impact of cost changes and determine required customer recovery amounts.
• Track price recovery opportunities from identification through customer implementation.
• Compare requested versus realized price recovery and identify gaps requiring additional commercial action.
• Support Sales leadership and account teams with data and documentation needed for customer pricing discussions.
• Maintain historical pricing and recovery information to improve visibility to commercial performance.

Cost & Margin Analytics

• Analyze customer, product, and program profitability using available commercial and operational data.
• Evaluate the impact of supplier and commodity cost changes on product margins.
• Identify margin erosion associated with unrecovered material, tariff, or supplier cost increases.
• Conduct pricing, volume, mix, and margin analyses to support commercial decision-making.
• Develop scenario analyses to evaluate the financial impact of proposed customer pricing actions.

Reporting & Data Analytics

• Develop and maintain Excel models, dashboards, and analytical tools supporting pricing and recovery activities.
• Build and maintain Power BI dashboards that provide visibility to price recovery status, trends, financial exposure, and commercial performance.
• Extract and analyze data from company ERP and other business systems.
• Validate information across multiple data sources and investigate data discrepancies.
• Translate complex datasets into clear, actionable information for Sales and business leadership.
• Support recurring commercial reporting and ad hoc analytical requests.

Cross-Functional Support

• Partner with Sales, Purchasing, Finance, Operations, Supply Chain, and other functions to validate cost changes and quantify customer recovery requirements.
• Work with Purchasing and Supply Chain teams to understand supplier-driven cost increases.
• Partner with Finance to ensure pricing and recovery assumptions are supported by appropriate financial analysis.
• Support Sales teams in preparing fact-based analyses for customer discussions and negotiations.
• Develop working knowledge of company products, customers, manufacturing operations, and ERP processes.

Education & Experience

• Bachelor's degree in Business, Finance, Accounting, Economics, Supply Chain, Data Analytics, or a related field preferred.
• Relevant analytical experience in Sales, Finance, Purchasing, Supply Chain, Commercial Operations, or a related function preferred.
• Manufacturing or automotive/commercial vehicle industry experience is beneficial but not required.
• Experience analyzing pricing, cost, margin, or financial data strongly preferred.

Required Skills

• Advanced Microsoft Excel skills, including PivotTables, lookups, complex formulas, data manipulation, and financial modeling.
• Proficiency with Microsoft Power BI or similar business intelligence and data visualization tools.
• Strong quantitative and analytical problem-solving abilities.
• Ability to work with large datasets from multiple sources.
• Strong attention to detail and commitment to data accuracy.
• Ability to identify trends, exceptions, and financial risks within complex datasets.
• Ability to translate analysis into clear business recommendations.
• Strong written and verbal communication skills
• Ability to work effectively across Sales, Finance, Purchasing, Supply Chain, and Operations
• Ability and willingness to learn company products and ERP systems.

CVG IS AN EQUAL OPPORTUNITY EMPLOYER

Commercial Vehicle Group, Inc (CVG) is an equal employment opportunity employer such that all qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity/expression, national origin, disability, or protected veteran status.

Visa Sponsorship

At this time, we are not providing sponsorship for this role. Applicants must be authorized to work in the country of the job posting location on a full-time basis.

No Unauthorize