Ecommerce Demand Planner & S&OP Analyst

Woodstream Corporation; Lancaster (Lancaster County); On-site; USD 60,000 - 82,000; Full time

Benefits offered by this job

401k with Company Match

Health Insurance

Parental Leave

Adoption Assistance

Life & Disability Insurance

Paid Vacation

Pet Insurance

Job summary

Woodstream Corporation in Lancaster, PA is hiring a Demand Planning Analyst to forecast demand and optimize inventory across Amazon, ecommerce, and DI channels. You’ll analyze data, monitor trends, and communicate risks and opportunities to leadership.

The role emphasizes cross-functional teamwork, process improvements, and delivering accurate weekly forecasts with a focus on bias reduction and actionable insights.

Qualifications

• 1-3+ years of planning experience preferred.
• Understanding of Amazon tools a plus.
• Experience with combining, cleaning, and analyzing data.
• Excellent analytical, problem-solving, and communication skills.
• Strong PC skills with demonstrated knowledge of Excel, Access, and PowerBi.
• Bachelor’s degree required. Focus in Marketing, Math or Business preferred.
• Ability to work individually and under minimal supervision, but keeps supervisor updated on key news.
• Ability to manage multiple projects and priorities. Supports others with their assignments.
• Excellent verbal, written, and formal presentation skills.

Responsibilities

• Develop SKU level sales forecast for Amazon, ecommerce, professional, and DI channels using historical data and current trends.
• Measured primarily on improvements in forecast accuracy and reduction in forecast bias.
• Analyze key metrics such as traffic, conversion rates, and sales velocity to identify trends and adjust demand plans accordingly.
• Maintain a collaborative cross-functional process with sales and operations teams to ensure any changes in item presence, promotions/stock ups, price, competition, etc. are accounted for.
• Manage and maintain POS reporting for ecommerce and Amazon accounts.
• Serve as a key member of the team to own operational deliverables, such as reporting including the narrative development for what is and will happen.
• Identify opportunities for process improvement.
• Analyze and troubleshoot demand related issues in a timely and accurate manner.
• Collaborate and develop weekly/monthly business reviews with key stakeholders.
• Responsible for the design/build and deployment of the key processes within demand planning.
• Work with sales and operations to minimize slow moving inventory.

Skills

Forecasting

Data analysis

Cross-functional collaboration

Excel

Power BI

Amazon tools

Education

Bachelor's degree in Marketing/Business/Math

Tools

Power BI

Access

Job description

Woodstream Corporation in Lancaster, PA is hiring a Demand Planning Analyst to forecast demand and optimize inventory across Amazon, ecommerce, and DI channels. You’ll analyze data, monitor trends, and communicate risks and opportunities to leadership.

The role emphasizes cross-functional teamwork, process improvements, and delivering accurate weekly forecasts with a focus on bias reduction and actionable insights.