Senior Sales & Operations Planning Analyst
Design activities of sales, operations, supply, and finance planning, including setting up and running dynamic Sales and Operations Planning (S&OP) processes covering all existing plants and new plant additions of Saco AEI Polymer worldwide. Design sales planning process for budgeting and forecasting for new and recurring business to set yearly budget projections by the Business Development Managers (BDMs).Use advanced forecasting techniques to develop models built through validation and testing to analyze historical data, identity patterns, incorporate different markets factors/trends and account for customer insights.Conduct simulations using stochastic time series models (such as Winters Method, Moving Average Method, Decomposition Method, and Box-Jenkins ARIMA model) in Minitab to analyze historical sales data of finished goods. Developing, testing, and refining statistical predictive econometric models of key pipe and wire products, using statistical computing software such as R. Use probabilistic theory and applied regressions techniques, integratemacroeconomic variables with microeconomic factors to forecast market trends accurately.Using statistical inference tests (ANOVA, Chi-square, F-test, T-test) to assess the performance of the forecasting models. Using statistical benchmarking techniques, incorporate visual dashboards where BDMs can track sales of their customers against yearly budgets and rolling 4-month forecast. Implementing and optimizing the customer relationship management (CRM) tool to have the design aspects that will help facilitate a proactive budgeting and forecasting process. Develop flows to carry out operational planning of capacity analysis and set up of master scheduling of production lines, against the sales projections output part of the budgeting and forecasting process. Set up the CRM tool (Salesforce) to extract yearly budget and 4-month rolling forecasts to aggregate demand projections by products by individual production lines across all sites into ERP to identify capacity constraints. Determine order period cycles of products per production lines at all sites to match the optimal forecasting cycles. Develop processes to derive material requirements of the sales projections of the sales and budgeting process. Implementing a process to convert the quantitative and qualitative insights from Operations and Supply teams across all sites to actionable proactive measures. Design processes that will translate sales projections to a set of financial statements revolving around revenue, profitability, cash-flow and required investment in labor, capital goods and inventory.Initiate the efforts of the organization to develop an environment, social, and governance (ESG) strategy to obtain a recognized independent 3rd party sustainability rating.Conduct research on best practices and benchmarks in ESG reporting amongst customers, suppliers, and competitors. Implement technical planning platform to establish a process to calculate organization-wide Scope 1-3 greenhouse gas (GHG) emissions to establish an internal carbon footprint of the organization, against which key performance indicators (KPIs) can be identified to measure sustainability performance. Support existing planning activities, includingmaintaining existing capacity planning charts against yearly sales budgets and translating the finished goods needs to raw material requirements, with reactive accountancy of demand variations in-between the year that changes projections. Manage safety stock levels based on yearly sales budgets, with reactive accountancy of demand variations in-between the year that changes projections.Work from home flexible but must reside within commuting distance of SACO AEI Polymers Sheboygan, WI, headquarters. Limited (10%) domestic and (5%) international travel required.
Requirements:
Master's degree in Economics, Applied Economics, Supply Chain Management, Data Science, or Statistics.
Two yearsof experience in data analysis in a manufacturing or production setting involving pricing analysis, cost analysis, statistical benchmarking, demand forecasting, sourcing analysis, process evaluation analysis or life-cycle analysis of raw materials. Experience must include use ofERP software (such as QAD, SAP or Oracle), CRM software (such as Salesforce), statistical programming (such as R or Minitab), lean manufacturing strategies (such as JIT), and inventory management strategies (such as OEE, EOQ, or ABC Analysis).
