Demand Planning Analyst

EGI offers a unique working environment which encourages growth, rewards achievements, and provides opportunities to individuals who want to make a difference. We are a tight-knit community of fun and energetic people working together in exciting ways to create innovative products and provide the ultimate customer experience. How do we have fun? Annual offsite Christmas party Offsite picnic Tickets to sporting events including Guardians & Browns games Ice Cream Trucks Hot Dog and Taco Trucks Annual Golf Outing Lunch with President & Senior Leadership Corn Hole Challenges After 5:00 pm gatherings Office baby and wedding celebrations Office lunches and pot lucks What perks do we offer at EGI? Eligible for yearly discretionary bonus and pay increase 4% Salary contribution to 401(k) 10 Paid Holidays per year Competitive Paid Time Off - 3 weeks after 1 year of employment Volunteer Time Off $10k of Basic Life Insurance and company paid Short Term Disability/Long Term Disability Tuition Assistance Employee Assistance Program Competitive rates for medical, dental, and vision

Description of Job:

The Demand Planning Analyst, reporting to the SO&P Manager, will facilitate the demand planning process and is responsible for management of the daily and weekly demand planning functions. The position will provide significant and detailed review of customer demand, item availability, forecast performance, and item trend analysis. In addition, it will include the preparation and distribution of vital reports for the organization that impact customer relationship management. An ideal candidate has proven experience in data analysis, demand or supply planning, and supply chain activities. The team member will be a critical voice on the supply chain team, providing key context and perspective for customer/item demand decision making.

Essential Duties & Responsibilities:

Works in coordination with team on the annual & monthly EGI forecast development. Executes various tasks related to alignment of the demand plan to the EGI forecast. •Coordinates with Supply Planning on the initial demand plan as well as updates/changes to the plan. •Assists in the monthly S&OP process, facilitates demand planning meetings and executes any new actions related to the demand plan. Provides short term demand plan updates in the weekly S&OE meeting. Manages the processes and guidelines related to lead-time management, inventory allocation, and demand management for customer orders and forecasts. Works closely with CSR's and Sales on demand planning and forecasting activities. Reviews item availability of all finished goods and provides/updates item status/availability reports. Works closely with Customer Fulfillment Specialist on specific customer and item allocation needs. Reviews Master Production Schedule (MPS), OEM Container Plans, Transfer Orders, etc. to determine item flow and availability timing. Communicates and provides feedback on item availability to EGI team members as requested. Provides/updates reports that analyzes customer item forecast to actual customer demand. Notifies Supply Planning of item quantity gaps and works together to align on any revisions to the supply plan. Performs root cause analysis of demand issues to determine best solution. Escalates complex demand issues to management for further discussion and resolution. Support product life-cycle/profile management

Education & Experience:

Bachelor's degree in Supply Chain Management, Business, Analytics, Communication, or related area of study ERP and MRP systems experience preferred but not required 2+ years of analytical experience Experience in demand planning and/or supply chain functions preferred

Job Knowledge, Skills & Abilities:

Attention to detail skills Analytical and problem-solving abilities Strong customer service orientation Ability to analyze vast data sets and produce clear reporting based on intended objective Proficiency in all Microsoft Office Programs; high level of proficiency in Excel, PowerPoint, and PowerBI Effective project management skills and the ability to prioritize and organize multiple assignments Ability to work independently as well as collaboratively across multiple departments Effective in making business decisions quickly and independently Strong written and oral communication skills Please be advised that Enerco Group Inc. is a smoking-free environment . All prospective employees will be subjected to a pre-employment nicotine/drug screen and background check. In addition, all candidates must be authorized to work in the United States, without sponsorship.

Job Type:

Full-time Pay:

$50,000.00 - $70,000.00 per year

Benefits:

401(k) 401(k) matching Dental insurance Health insurance Paid time off Vision insurance Application Question(s): Are you able to work on-site 4 days per week with the option to work 1 day remote after 90 days, as this is not a remote position? Are you a smoker or nicotine user? Are you comfortable managing and mining large amounts of data in Microsoft Excel? Explain your comfort level with pivot tables. Explain your experience with SQL Queries.

Education:

Bachelor's (Preferred)

Experience:

Analytics:

2 years (Preferred) Ability to

Commute:

Cleveland, OH 44135 (Required)

Work Location:

In person