Demand Planning Analyst

Senior Demand Planning AnalystAt 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.This is a HYBRID position, 1-2 day in office per week. Our office is located in Bolingbrook, ILThe 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.Demand Planning and ForecastingDevelop 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 AnalysisDevelop 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 AnalysisAnalyze 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 InsightsAnalyze 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 SupportBuild 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 ModernizationActively 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.3+ 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 InformationSalary starting at $80,000/yr, based on skills and experiencePaid time off that includes Unlimited Vacation Time, Annual Sick Days, Mental Health Days, and HolidaysDental, Vision, and Health Insurance401(k) with a company match programPaid Parental Leave