Sales Analyst

Trim Systems Operating Corp; New Albany (IN); On-site; USD 60,000 - 85,000; Full time

Job summary

Commercial Vehicle Group, Inc (CVG) is seeking a Sales Analyst to support pricing, cost recovery, and margin protection. The role focuses on analyzing raw material changes, tariffs, and supplier price increases, then supporting customer price recovery actions.

Proficiency in Excel and Power BI is required, with training provided on ERP systems. The ideal candidate will have strong analytical capabilities and experience deriving actionable insights from large datasets, enabling informed

Qualifications

• Bachelor's degree in Business, Finance, Accounting, Economics, Supply Chain, Data Analytics, or related field.
• Experience analyzing pricing, cost, margin, or financial data.
• Advanced Excel skills (PivotTables, lookups, complex formulas, data manipulation).
• Experience with Power BI or similar BI tools.

Responsibilities

• Price Recovery & Commercial Analysis: Analyze cost increases and develop analysis for price recovery initiatives and customer pricing discussions.
• Cost & Margin Analytics: Evaluate profitability and margin impact from supplier and material cost changes.
• Reporting & Data Analytics: Build Excel models and Power BI dashboards; translate data into actionable insights for sales and leadership.
• Cross-Functional Support: Collaborate with Sales, Purchasing, Finance, Operations and Supply Chain to validate cost changes and recovery requirements.

Skills

Advanced Excel

Power BI

Data visualization

Analytical thinking

Data accuracy

Communication

Education

Bachelor's degree in Business/Finance/Accounting/Economics/Supply Chain/Data Analytics

Tools

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.