Sales Forecasting Analyst

Please note this role is required onsite and we are not offering any sponsorship in this role. Thus, if you are an individual who is temporarily work authorized and will require future sponsorship (such as an international student), you are not currently eligible for this role. Any misrepresentations of your status will be immediate grounds for terminating your application and/or employment

Position summary:

The Sales Forecasting Analyst serves as a key strategic partner to Sales Leadership, responsible for transforming complex business data into actionable insights while creating scalable, efficient business processes across the commercial organization.

This role goes beyond traditional reporting and analytics. The successful candidate will lead process improvement initiatives, identify automation opportunities, develop data-driven solutions, and implement tools that increase organizational efficiency. Acting as an extension of Sales Leadership, this individual will independently assess business challenges, create streamlined processes, leverage technology solutions, and drive adoption across cross-functional teams.

The ideal candidate thrives in ambiguity, is highly analytical, process-oriented, and possesses the technical aptitude to automate repetitive work through advanced Excel tools, database management, Power BI, SQL, Python, macros, and other business intelligence platforms.

Job Family: Engineer/Technical

Competencies:

• Collaborates : Builds partnerships and works collaboratively with others to meet shared objectives. For example, finds many ways to add value to the team; probes to draw out richer input from others; is a valued resource who goes out of the way to help others.

• Communicates Effectively : Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences. For example, pays attention to others’ insights, advice or instruction, grasping the main elements. Promptly shares relevant information with the right amount of detail.

• Nimble Learning : Learns through experimentation when tackling new problems, using both successes and failures as learning fodder. For example, experiments to find the best possible solution and gains insight from test cases. Makes use of new concepts and principles when addressing problems. Learns from mistakes to avoid repeating them.

• Situational Adaptability : Adapts approach and demeanor in real time to match the shifting demands of different situations. For example, sees even subtle cues to adapt; deploys a wide range of behaviors to stay effective. Exemplifies flexibility and resourcefulness; responds deftly to a variety of challenges and situations.

Essential Responsibilities:

Data Analysis

• Perform data mining, trend analysis, statistical analysis, and business forecasting.

• Translate complex data into actionable business recommendations.

• Support leadership decision-making through data-driven insights.

• Assist with forecasting, budgeting, planning and capacity assessments

• Conduct business, customer, tariff, and market related analysis

.Business Process Improvement

• Analyze existing 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.

• Partners 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.

Automation & System Development

• · Identify opportunities to reduce manual work through automation.

• Develop tools utilizing 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.

Strategic Support

• Support special projects and strategic initiatives for commercial leadership

• Conduct business, customer, tariff, and market0related analysis.

• Serve as a trusted resource for solving complex operational and analytical challenges.

Education & Experience:

• Bachelor's degree required in Business, Data Analytics, Information Systems, Mathematics, Statistics, Engineering, Education, Supply Chain, Finance, or a related field.

• 1 – 3 years pf 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.

• Experience working with data, reporting, process improvement, or systems administration preferred.

• Automotive industry experience is a plus but not required.

Non-Essential Responsibilities:

• Other duties as assigned by Management.

Other Knowledge, Skills & Abilities:

• Technical Skills

• 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 utilize business intelligence and reporting tools.

• Familiarity with SQL, Python, Power BI, VBA, macros, or other automation tools preferred.

• Ability to identify opportunities for automation and implement practical solutions.

• Ideal Candidate Characteristics

• Is naturally curious and enjoys solving complex business problems.

• Can quickly learn new processes, systems, and business functions.

• Demonstrates initiative and does not wait for constant direction or coaching.

• Is highly organized, detail-oriented, and process-driven.

• Looks for ways to improve efficiency rather than simply maintain existing processes.

• Is comfortable challenging the status quo and proposing better solutions.

• Can take ownership of projects from concept through implementation.

• Effectively communicates complex information to both technical and non-technical audiences.

• Thrives in a fast-paced environment where priorities and business needs evolve.

Supervision Received :

Supervision Received

Specific Direction : Follows established work procedures. Receives periodic checks for performance. Refers unique questions/conditions to immediate supervisor.

X

General Direction: Plans and arranges own work. Uses a wide range of procedures to accomplish assigned objectives.

Limited Direction: Works from overall policies, goals and budgetary limits. Virtually self-supervising with direct accountability for final results.

Supervisory Responsibilities:

• Indirectly responsible to manage data from other departments

Physical Requirements:

Average Daily Physical Requirements

None

.25 hour - 2 hours

2.5 hours - 5.5 hours

5.5 hour +

Work in stationary position

X

Move about work area

X

Use hands/fingers to handle or feel

X

Reach with hands and arms

X

Ascend/Descend (stairs/ladder/etc.)

X

Bend, stoop, kneel, crouch, or crawl

X

Communicate with various parties

X

Detect flavors or smells

X

Move containers up to 30 pounds

X

Visual acuity

X

Read and understand written word

X

Drive/Travel

X

Operate computer and general office machines

X

Operate Machines:

X

Other:

X

Environmental Conditions:

Average Daily Environmental Conditions

None

.25 hour - 2 hours

2.5 hours - 5.5 hours

5.5 hour +

Normal office environment: No exposure to extreme heat, cold, noise or chemicals or hazardous equipment.

X

Plant environment: exposure to dust, oil, various chemicals, and extreme noise.

X

Travel: Limited exposure to outside elements.

X

Other:

X

FLSA Classification Justification:

Computer Employee Exemption

Salary range meets FLSA requirements for exempt employee.

Yes

Yes

Primary duties consist of the following:

Yes

Yes

Yes

Yes