Demand Planning Analyst

American Plastics is a privately owned injected molded plastics company that designs and manufactures workhorse items in the United States, utilizing green processes and superior engineering. American Plastics is a growing company, with a recent acquisition tripling the company size and expanding the production footprint to Missouri, Ohio, Arizona and South Carolina. We are expanding our Engineering capabilities and require analytical expertise in product costing, packaging costing and pricing data to determine the pricing strategy that will aid in the company’s growth strategy.

• Lead Sales & Operations Planning (S&OP) Sales Forecast Reviews, ensuring accuracy and timely updates for decision-making ?
• Enhance the annual sales budget process by proactively refining and optimizing sales forecasts, ensuring accurate and data-driven inputs are prepared in advance ?
• Lead S&OP Production Forecast Reviews, ensuring accuracy and timely updates for inventory control ?
• Enhance the annual production budget process by proactively refining and optimizing production forecasts, ensuring accurate and data driven inputs are prepared in advance ?
• Manage the Product Costing Quotation process, including all aspects of DocuSign document management for approvals ?
• Monitor and improve capacity reporting for all product families, ensuring optimal clarity and management regarding tooling capacity ?
• Collaborate with sales, finance, and operations teams to quickly identify and resolve capacity or demand allocation issues ?
• Take full ownership of and improve operations-based Power BI models including Sales Forecast Model, Production Forecast Model, Daily Production Tracking Model, Spend Tracking Model,
• Customer Forecast Models, and Capacity Forecast Model ?
• Develop strategic SQL-driven data practices to support ad hoc business intelligence needs, leveraging advanced query design and database optimization for rapid insight generation ?
• Lead high-level meetings with senior leadership and department managers, presenting data-driven insights while facilitating well-organized discussions that drive informed decision-making ?
• Maintain and update the company-wide weekly business cadence call spreadsheet, delivering actionable insights for leadership ? Provide supplemental analysis and data-driven insights upon request to support the sales and finance teams ?
• Oversee the management of electronic document usage plans to ensure smooth operations and compliance ?
• Explore and implement opportunities to further automate processes, enhancing efficiency to support data-driven decision-making Develop advanced reports in Power BI and integrate new data sources, improving visibility and insights across key business areas

Skills/Key Competencies: ?

• Advanced Excel skills with the ability to manage complex datasets and sophisticated analyses ?
• Proficient in Power BI with a proven track record of creating, maintaining, and improving business intelligence models and dashboards ?
• Working knowledge of SQL for querying databases and generating reports ?
• Exceptional communication and leadership skills with the ability to lead high-level meetings and foster cross-departmental collaboration ?
• Proficient in accounting and product costing, understanding key financial metrics and driving cost efficiencies ?
• Solid understanding of operations and manufacturing, with the ability to support and enhance the production process through data analysis ?
• Ability to work autonomously, demonstrating strong initiative and self-direction while managing multiple tasks and priorities effectively ?
• A focus on efficiency in both individual work and team processes, continuously seeking ways to streamline operations ? Demonstrates honesty and integrity in all aspects of work, maintaining transparency, ethical standards, and accountability ? Ambitious and growth-oriented, with a proactive approach to personal and professional development

Requirements ?

• Bachelor’s degree in finance, accounting, business, or data analytics ?
• 1-3 years of experience in a similar role, with a focus on forecasting, financial analysis, and data management ?
• Demonstrated expertise in Power BI, Excel, and SQL ?
• Experience working with S&OP processes, capacity planning, and sales forecasting ?
• A results-oriented mindset with the ability to manage multiple tasks and projects simultaneously, meeting deadlines while translating data into actionable business insights.

If you are interested in joining the American Plastics team and want to work in a fast-paced, progressive environment, we want to hear from you. We offer a competitive salary & benefits package including medical/dental, 401K, paid vacation.