Sales Forecasting Analyst

ADAC•Grand Rapids, MI

7d•$67,000 - $95,000•Onsite

About The Position

The Sales Forecasting Analyst is an onsite strategic partner to Sales Leadership who transforms business data into actionable insights and develops scalable, efficient processes across the commercial organization. The role includes analyzing business challenges, identifying automation and process-improvement opportunities, implementing technology solutions, and driving adoption across cross-functional teams. The analyst supports forecasting, budgeting, planning, capacity assessment, and strategic decision-making; maintains large commercial datasets; and develops dashboards, KPI reporting, and executive presentations. The position collaborates with Sales, Finance, Program Management, Engineering, Capacity Management, Purchasing, and IT. It requires a bachelor's degree in a relevant field and 1–3 years of relevant experience, although equivalent combinations of education, technical training, internships, co-op experience, and demonstrated analytical capabilities may be considered. Automotive industry experience is a plus but not required. The role follows established work procedures, receives periodic performance checks, and refers unique questions or conditions to the immediate supervisor. No sponsorship is offered.

Requirements

Bachelor's degree in Business, Data Analytics, Information Systems, Mathematics, Statistics, Engineering, Education, Supply Chain, Finance, or a related field.
1–3 years of experience in analytics, operations, process improvement, process coordination, business administration, supply chain, sales support, or related business functions; equivalent combinations of education, technical training, internships, co-op experience, and demonstrated analytical capabilities will be considered.
Advanced proficiency in Microsoft Excel, including complex formulas, Pivot Tables, Power Query, and data analysis tools.
Experience working with large datasets and maintaining data accuracy.
Ability to learn and use business intelligence and reporting tools.
Ability to identify automation opportunities and implement practical solutions.
Strong analytical, organizational, detail-oriented, and process-driven approach.
Ability to learn new processes, systems, and business functions quickly, take initiative, and own projects from concept through implementation.
Ability to communicate complex information to technical and non-technical audiences.
Ability to adapt in a fast-paced environment with evolving priorities.
Must be eligible to work without future sponsorship; the employer does not offer sponsorship for this role.
Must work onsite.

Nice To Haves

Experience working with data, reporting, process improvement, or systems administration.
Familiarity with SQL, Python, Power BI, VBA, macros, or other automation tools.
Automotive industry experience.

Responsibilities

Perform data mining, trend analysis, statistical analysis, and business forecasting.
Translate complex data into actionable business recommendations and support leadership decision-making with data-driven insights.
Assist with forecasting, budgeting, planning, and capacity assessments.
Conduct business, customer, tariff, and market-related analysis.
Analyze business processes and identify opportunities for simplification, automation, and efficiency gains.
Design, document, implement, and maintain standardized business processes across commercial functions.
Lead continuous improvement initiatives from concept through rollout.
Partner with Sales, Finance, Program Management, Engineering, Capacity Management, Purchasing, and IT to improve workflows and data accuracy.
Create process documentation, training materials, and standard operating procedures.
Drive adoption of new processes and tools across the organization.
Manage and maintain large datasets supporting sales forecasting, customer demand, pricing, tariffs, market intelligence, and strategic planning.
Develop and maintain dashboards, KPI reporting, and executive-level presentations.
Identify opportunities to reduce manual work through automation.
Develop tools using advanced Excel, Power Query, Power BI, SQL, Python, VBA/macros, and other business applications.
Collaborate with IT to implement scalable business system solutions.
Create automated reporting solutions and data management tools.
Improve data integrity and governance across commercial databases.
Support special projects and strategic initiatives for commercial leadership.
Serve as a trusted resource for solving complex operational and analytical challenges.
Indirectly manage data from other departments.
Perform other duties as assigned by Management.