Demand Planning Analyst; Forecasting, Data Points/Analytical, POWERBI, Hybrid Malvern, PA

Saint--gobain; Malvern (Chester County); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health and Wellbeing

401(k) with company match

Paid time off

Life Insurance

Employee discounts

Job summary

Saint-Gobain seeks a Demand Planning Analyst in Malvern, PA to support demand planning and sales forecasting for the SPG. You will collaborate with Senior Demand Planner to generate consensus forecasts and disaggregate to SKU/plant level inside SAP APO Demand Planning and ECC.

You will develop forecasts at multiple levels, analyze drivers with Power BI, and contribute to the S&OP process. The role offers a hybrid work model and opportunities to influence planning through data visualization and

Qualifications

• Bachelor’s degree in supply chain, information systems, or related field.
• Minimum 3–5 years in a supply chain environment focused on demand planning.
• Proficiency in statistics, forecasting, and analysis.
• Strong analytical, organizational, decision making, and presentation skills.

Responsibilities

• Develop demand forecasts at multiple levels of aggregation.
• Assist Senior Demand Planner with monthly collaborative consensus forecast meetings with sales, product management, finance.
• Maintain baseline / statistical forecasts, collect forecast drivers and highlight changes for stakeholders.
• Review historical sales trends, develop forecast data, and evaluate forecast results.
• Track Forecast KPI’s including bias, accuracy and forecast value add.

Skills

Power BI

Forecasting

Data analysis

Excel

SAP MRP

ERP planning

Communication

Root cause analysis

Presentation

Power Query

Education

Bachelor’s degree in Supply Chain, Information Systems, or related field

Tools

Power BI

SAP MRP

ERP planning software

Excel

Job description

Demand Planning Analyst; Forecasting, Data Points/Analytical, POWERBI, Hybrid Malvern, PA

The Demand Planning Analyst is responsible for supporting all demand planning and sales forecasting activities for the CertainTeed Siding Products Group (SPG). This position will be tasked with supporting the monthly demand planning (sales forecast) process, working in concert with the Senior Demand Planner. This covers the generation of the consensus sales forecast at an aggregate level, and its disaggregation to the most detailed level (SKU and plant). The Demand Planning Analyst drives the creation and maintenance of the sales forecast by combining inputs from customers, Sales, Product Management, historical data, and other relevant sources. The Demand Planner also supports the broader S&OP process through various reporting, analysis, and data visualization responsibilities.

Demand Planning

• Develop demand forecasts (operational forecasts) at multiple levels of aggregation for multiple time horizons.
• Assist Senior Demand Planner with facilitation of monthly collaborative consensus sales forecast meeting with sales, product management, finance.
• Maintain baseline / statistical forecasts, collecting forecast drivers and highlighting changes and drivers in the plan to key stakeholders. Interact with sales and product management to understand demand forecast drivers.
• Review historical sales trends, research and highlight demand drivers, prepare forecast data, develop statistical forecast models, and evaluate forecast results.
• Collect, analyze, and interpret data related to market conditions, demand drivers, and key sales forecast assumptions.
• Track Forecast KPI’s including bias, accuracy and forecast value add. Use these KPI’s to drive improvements.
• Coordinate cross-functional research activities to reconcile significant variances and refine the forecast model to reflect updated sales and product management assumptions.
• Use and maintain the Demand Planning software/files as the primary forecasting system tool.
• Collect and summarize input from Sales and Product Management regarding market insights and planned-event impacts to build into forecast.
• Ensure that consensus sales forecast is accurately disaggregated to SKU/plant level inside of SAP APO Demand
• Planning and SAP ECC.
• Address demand-related queries and issues in a timely manner

Analysis

• Work with internal stakeholders to develop and enhance reporting, analysis, and data visualization tools such as Power BI, Power Query, QlikView
• Support Planning Analyst in his/her regular responsibilities as needed and to cover vacations
• Support Planning Manager and Planning Director with ad hoc reporting and data requests
• Support all aspects of S&OP Process with data analysis and reporting as needed, in the areas of:
• Demand
• Network optimization and utilization
• Perfect Order performance
• Root cause analysis

A team ready to welcome you

Employees have the flexibility to choose the benefits that best fit their individual needs:

• Health and Wellbeing – Supporting your wellbeing, to thrive in life and work.
• Medical, Prescription Drug, Vision, and Dental Insurance
• Healthcare Saving Account and Flexible Spending Account options
• LiveWell Wellness Program
• Employee Assistance Program (EAP)
• Paid Time Off and Paid Parental Leave
• Retirement and Protection - Helping to make the future life you want a reality.
• 401(k) with Company Match, Retirement Accumulation Plan (RAP), Cash Balance Pension Plan
• Company-provided Life Insurance, AD&D, Short-Term Disability
• Voluntary employee and dependent life insurance, Long-Term Disability, Critical Illness, and Accident Insurance

Additional Benefits – Helping shape the experience and impact you want

• Group Legal
• Identity Theft Protection
• Auto and Home Insurance
• Pet Insurance and Discounts
• Back-up Child & Elder Care
• PerkSpot Employee Discount Program

To make sure nothing is forgotten

• Bachelor’s Degree in Supply Chain, Information Systems, or related field
• Minimum 3 to 5 years of experience in a Supply Chain environment focused on demand planning and analysis
• Demonstrated proficiency in statistics, forecasting, and analysis
• Strong analytical, organizational, decision making, and presentation skills
• Ability to identify issues, lead root cause analysis, and develop corrective action plans
• Change management and conflict management skills
• Strong influencer with good written and oral communication skills, including online and in-person meeting management
• Ability to draw conclusions from large data sets, and present them to others to enable decision-making
• Flexible, curious, and open-minded
• Proficient in Microsoft Office Suite, specifically Excel, Power BI, Access
• SAP MRP, ERP planning software experience

Legal Statement

Saint-Gobain provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Saint-Gobain is an equal opportunity employer of individuals with disabilities and supports the hiring of veterans.