Sr Demand Planning Analyst

Amsive LLC; Bolingbrook (IL); Hybrid; USD 77,000 - 94,000; Full time

Benefits offered by this job

401(k) with company match

Unlimited vacation time

Health, dental, vision insurance

Paid parental leave

Hybrid work model

Job summary

Amsive LLC in the United States seeks a Senior Demand Planning Analyst to translate demand signals, financial data, and operational inputs into actionable insights that drive capacity utilization, profitability, and performance. You will partner with Sales, Operations, Finance, and Technology to create accurate forecasts and scalable decision-support capabilities.

The ideal candidate is data-driven, curious about AI and automation, and eager to modernize forecasting tools to improve accuracy and

Qualifications

• Bachelor's degree in Supply Chain, Operations Management, Industrial Engineering, Finance, Economics, Statistics, Data Analytics, Business, or related field.
• 2+ years of experience in demand planning, supply planning, manufacturing analytics, operations finance, capacity planning, or similar analytical role.
• Advanced Microsoft Excel with complex formulas, pivot tables, and scenario modeling.
• Experience with BI/visualization tools such as Power BI, Tableau, Dataroma, or similar.
• Familiarity with AI-enabled productivity and analytical tools.
• Strong written and verbal communication with cross-functional teams.
• Analytical thinker with problem-solving capabilities.
• Ability to manage multiple priorities in a fast-paced environment.

Responsibilities

• Develop and maintain short-, mid-, and long-range demand forecasts by customer, product, facility, or other segments.
• Consolidate historical demand with sales, forecasts, seasonality, trends, and inputs into an integrated plan.
• Analyze forecast accuracy, bias, variability, and key demand drivers.
• Identify changes in demand patterns and communicate implications.
• Create capacity models across facilities, lines, equipment, and shifts.
• Evaluate capacity against forecasted demand and identify constraints and risks.
• Assess impact of growth, new opportunities, mix changes, downtime, and staffing on capacity.
• Run scenario analyses for overtime, shifts, investments, outsourcing, and scheduling.
• Build dashboards providing leadership visibility into utilization and bottlenecks.
• Analyze labor performance metrics and identify productivity opportunities.
• Support workforce planning and staffing risk analysis.
• Analyze profitability by customer, product, and facility; identify margin improvements.
• Support pricing, contracts, and business reviews with data-driven insights.
• Develop standard metrics and ensure consistency across departments.
• Perform root-cause analysis on variances and risks.
• Identify emerging trends and opportunities before impact.

Skills

Data analysis

Excel

Power BI

Tableau

Dataroma

AI-enabled tools

Communication

Problem solving

Prioritization

Education

Bachelor's degree in related field

Tools

Power BI

Tableau

Dataroma

Job description

Who We Are

At Amsive, we're more than just a performance marketing agency; we're a team that thrives on collaboration and innovation. We offer a supportive environment where personal growth is just as important as professional development. We're a team of passionate individuals ready to tackle challenges, learn from one another, and drive results. We believe in empowering our team members, providing them with the tools they need to succeed, and trusting them to lead the way. With decades of expertise and a commitment to integrated solutions, we don't meet the industry standard; we're setting it.

If you're looking for a place where your work matters, a career path you can grow on your terms, and a team that's as invested in your success as you are, Amsive is for you. We offer a unique blend of flexibility, growth opportunities, and a culture that values each individual. Join us, and be part of the team ready to welcome, support, and grow with you.

*We regret to inform you that currently, Amsive DOES NOT provide sponsorship opportunities.

This is a HYBRID position, 1-2 day in office per week. Our office is located in Bolingbrook, IL

What we are looking for:

The Senior Demand Planning Analyst is a highly analytical role responsible for translating demand signals, operational data, and financial information into actionable insights that improve capacity utilization, labor efficiency, profitability, and overall business performance.

This position will partner closely with Sales, Operations, Finance, Supply Chain, Manufacturing, and Technology teams to develop demand forecasts, evaluate production capacity, identify operational constraints, and support fact-based decision-making across the organization.

The ideal candidate is intellectually curious, highly proficient in data analysis, and motivated to modernize how the organization uses information. This individual should have a strong desire to learn and apply artificial intelligence, automation, advanced analytics, and modern data tools to improve forecasting accuracy, increase organizational speed, and create scalable decision-support capabilities.

What you will be doing:

Demand Panning and Forecasting

• Develop and maintain short-, medium-, and long-range demand forecasts by customer, product, facility, production line, or other relevant business segment.
• Consolidate historical demand, sales pipeline information, customer forecasts, seasonality, market trends, and operational inputs into an integrated demand plan.
• Analyze forecast accuracy, bias, variability, and key demand drivers.
• Identify significant changes in demand patterns and communicate potential operational and financial implications.

Capacity Analysis

• Develop detailed capacity models across facilities, production lines, equipment, labor groups, and shifts.
• Compare forecasted demand against available production capacity to identify constraints, excess capacity, and potential service risks.
• Evaluate the impact of customer growth, new business opportunities, product mix changes, equipment downtime, staffing changes, and productivity assumptions.
• Perform scenario analysis to support decisions related to overtime, shift structures, capital investments, outsourcing, facility utilization, and production scheduling.
• Create forward-looking capacity dashboards that provide leadership with visibility into anticipated utilization and bottlenecks.

Labor Efficiency and Productivity Analysis

• Analyze labor performance, including labor hours, units per labor hour, earned versus actual hours, overtime, staffing levels, and utilization.
• Identify productivity trends, labor inefficiencies, and performance gaps across facilities, shifts, departments, and production lines.
• Evaluate the impact of product mix, run size, setup time, downtime, training, absenteeism, and staffing levels on labor performance.
• Support workforce planning by identifying future labor needs, productivity opportunities, and potential staffing risks.

Profitability and Financial Insights

• Analyze customer, product, job, facility, and production-line profitability.
• Identify margin improvement opportunities and areas of financial underperformance.
• Support customer pricing, contract evaluations, business reviews, and new-business assessments with fact-based financial and operational analysis.
• Partner with Finance to improve cost-to-serve, contribution margin, and unit-economic models.

Analytics, reporting and Decision Support

• Build and maintain dashboards, models, and recurring reporting that provide clear visibility into demand, capacity, labor, productivity, service, and profitability.
• Convert complex data into concise insights and recommendations for operational and executive leadership.
• Develop standardized performance metrics and ensure consistent definitions across departments.
• Perform root-cause analysis on operational and financial performance variances.
• Identify emerging trends, risks, and opportunities before they materially affect business results.

AI, Automation and Data Modernization

• Actively learn and apply artificial intelligence, machine learning, automation, and advanced analytics to demand planning and operational decision-making.
• Identify opportunities to automate manual reporting, recurring analysis, data preparation, and forecasting processes.
• Experiment with AI-enabled tools to improve forecast accuracy, detect anomalies, summarize performance drivers, and accelerate decision-making.
• Promote responsible, secure, and practical use of AI and modern data tools.

Who you are:

• Bachelor’s degree in Supply Chain, Operations Management, Industrial Engineering, Finance, Economics, Statistics, Data Analytics, Business, or a related field.
• 2+ years of experience in demand planning, supply planning, manufacturing analytics, operations finance, capacity planning, or a similar analytical role.
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, scenario modeling, and data analysis.
• Experience using business-intelligence or visualization tools such as Power BI, Tableau, Dataroma, or a similar platform.
• Familiarity with AI-enabled productivity and analytical tools.
• Excellent written and verbal communication skills with the ability to influence and collaborate with stakeholders at all levels.
• Analytical thinker with strong problem-solving skills and the ability to draw insights from complex data.
• Ability to manage multiple priorities in a fast-paced and evolving environment.

Additional Information

• Salary starting at $80,000/yr, based on skills and experience
• Paid time off that includes Unlimited Vacation Time, Annual Sick Days, Mental Health Days, and Holidays
• Dental, Vision, and Health Insurance
• 401(k) with a company match program
• Paid Parental Leave

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Amsive is proud to be an Equal Opportunity Employer. We are committed to building a supportive and inclusive environment for all employees. It is Amsive’s continuing policy to provide equal employment opportunity and not to discriminate on the basis of race, color, religion, pregnancy or childbirth, marital status, national origin, ancestry or citizenship status, age, disability, sex, sexual orientation, gender identity, veteran status or any other characteristic protected by applicable federal, state or local laws. This policy applies to all aspects of employment, including (but not limited to) application for employment, recruiting, hiring, compensation, benefits, promotions and transfers, training, layoffs, rehires, termination of employment and all other terms and conditions of employment.

All offers of employment with Amsive are contingent upon the successful completion of background checks, which may include criminal history and reference verification, conducted in compliance with applicable state, federal, and local laws.

As part of the Company’s equal employment opportunity policy, Amsive will also take affirmative action as called for by applicable laws and Executive Orders to ensure that minority group individuals, females, disabled veterans, recently separated veterans, other protected veterans, Armed Forces service medal veterans, and qualified disabled persons are introduced into our workforce and considered for promotional opportunities.