Demand Planner

Demand PlannerSprings Window Fashions is hiring for a Demand Planner based in our Madison, WI area Corporate Headquarters.This is a hybrid role with in-office days Monday, Tuesday & Wednesday and remote on Thursday & Friday. Fully remote is not an option.Springs Window Fashions is a leader in the custom window treatment industry since 1939. Headquartered in Middleton WI, we have over 6,000 associates with locations in North America, Europe, and Asia. Our custom window treatments are available under the Bali, Graber, SunSetter and Mecho brands in nearly every major retailer, in thousands of designer showrooms, and showcased in large commercial buildings.Our company has made significant investments to become a leader in product innovation. As North America's premier window covering company, we're committed to creating a "Best Experience" for our consumers, channel partners and associates. We are bringing new innovations to the market at an accelerated pace and have a variety of offerings to consumers who want to improve their home dcor.Job ResponsibilitiesForecasting & Demand Planning (30%)Develop and maintain an accurate statistical forecast at multiple levels of aggregation over a rolling 24 month time horizon for both custom made-to-order and stock products by analyzing historical trends, secondary data (i.e. POS), and input from business partnersIdentify and correct statistical modeling issues driven by system parameter and variable settings within the forecasting software related to history, trending, seasonality, etc.Perform ongoing analysis and monitoring of actual performance to forecasted plan, identify significant variances, take corrective actions, and document key assumptionsAchieve a consensus demand plan by facilitating a collaborative planning process with sales, product, marketing, purchasing, production planning, and other sources to: - Adjust for significant new or lost account distribution - Incorporate known and assumed promotional activity with the proper sales lift and timing - Properly reflect and maintain product life cycles for new product rollouts, refreshes, and phase-outs while considering store counts, planograms, and cannibalization - Analyze, interpret, and incorporate key demand drivers and market intelligence - As requested, provide input to purchasing and production planning to develop inventory strategies on existing, new, and phase-out itemsSupport strategic forecast initiatives designed to improve the quality of the forecast and close the identified gapsSeek out, develop, share, and implement Demand Planning best practicesSystem & Data Management (20%)Use and maintain the Demand Planning software (Anaplan) as the primary forecasting system / toolManage history used for forecasting and ensure it is identified with the proper attributes, correctly dated, and adjusted for known events with outliers removedMaintain accurate average selling prices and adjust for expected future changesUpdate data tables in Access and SharePoint to establish relationships and hierarchies in the data structure for customer, product, and brandS&OP Process (Monthly) (20%)Support the S&OP cycle by completing critical forecasting duties (detailed above) and distributing relevant forecast information (i.e. reporting, charts, etc.) to sales, product, and purchasing for review and discussion in consensus meetingsOrganize and lead consensus meetings for assigned account and product groups to identify required changes in the demand plan to achieve consensus driven by discussion of key initiatives, significant business events, changes in product / marketing plans, and forecasting performanceProperly reflect discussed changes in the demand plan, follow up on action items, and confirm consensus of sales and product with the new planPublish the consensus demand plan along with a clear and concise explanation of forecast changes between cycles, key business event drivers, action plans, and assumptions (or change in assumptions) to be used in the main S&OP meeting (Demand Review)Report out monthly on MAPE and bias performanceAttend the Demand Review meeting and if requested, provide commentary on current information and identified gaps reflected in the plan to Senior Leadership in attendanceAnalysis & Reporting (30%)Provide timely and accurate response to demand and forecast related inquiries from all areas of the organization, including day-to-day resolution of critical issues affecting the Supply ChainIdentify the impact of promotional activity, marketing, and industry dynamics to provide recommendations or make revisions to the demand planDevelop critical planning tools, key reports, and provide analytical support to Senior Leadership to make decisions, develop and execute key initiatives, and project short term and long term performanceUnderstand, evaluate, and comment on projected revenue driven by the demand planMay assist in offering insight and analysis into demand volume and mix changesMay assist in annual development of the sales budget and related documentationMay perform other administrative and reporting functions related to the demand planning processComplete special projects and ad-hoc requests as assignedRequirementsEducation and ExperienceBachelors Degree in Business, Accounting, Finance, or Economics1+ years related experience in Planning / ForecastingPreference given to candidates with: an undergraduate degree in business, accounting, finance or economics with a concentration in supply chain management, sales, or statistics1+ years of experience in any analytical role within a large retailer and / or manufacturing environment (forecasting, supply chain, retail planning, accounting, finance, or other relevant analytical role)A Masters of Business Administration degree is a plusCPF, ACPF, CPF-C, APICS, or other forecasting / supply chain / analytical Certification is a plusKnowledge, Skills and AbilitiesWorking knowledge of Anaplan software (SCM module) or other forecasting softwareHigh Proficiency in Microsoft Office, especially Excel (Pivot tables, Vlook ups, etc.)Excel skills related to Microsoft BI (i.e. PowerPivot, PowerQuery, PowerView, etc.) and macro writing CertificationAny experience in the window coverings industry is a plusHow We Work to Deliver a Best Experience: Our CultureOur Core Value: We do the right thing, alwaysOur Seven Cultural BehaviorsEmpowerment - We trust our people.Ownership - We take 100% responsibility for our roles actions, and results.Leadership - We all lead by example and talk direct with respect (DWR).One Team - We are One Springs Team.Customer First - We consider our customers' needs before every decision.Continuous Innovation - We are constantly learning, innovating, and improving.Speed - We define priorities and operate with a sense of urgency and eligibility.