Operations Planning Analyst

About the role

Under the direction of the Director - Supply Chain, the Operations Planning Analyst will provide strong problem-solving skills, process improvement, and analytical support (Excel/Access/modeling) to the Supply Chain department. This position will be responsible for: inventory flow forecasting through supply chain, maintenance of analytical tools and databases, supporting supply chain processes, analytical support for company initiatives, and strategic supply chain cost modeling.

Major Activities

• Assist with DC Forecasting and Planning (Weekly, Monthly, Yearly)
  • Develop DC flow and inventory forecasting models that utilize available information from merchandise planning systems.
  • Provide DC management with information needed to plan for space and labor requirements.
  • Support monthly and yearly budgeting process with flow and inventory projections.
• Timely and accurate reporting and analysis.
• Reporting and Analysis Tools - Support and Development
  • Design, development, and maintenance of analytical models and productivity tools (Excel and Access) to support business process efficiency.
  • Prepare reports showing actual performance against departmental goals and objectives and do necessary research to explain variances.
  • Utilize expertise in Excel, Access, and other tools to facilitate department reporting requirements.
• Supply Chain – Process Improvement
  • Identify and manage Supply Chain opportunities through analysis, study, and project design.
  • Work with cross-functional teams to enable more efficient flow of product through the Supply Chain.
  • Support projects by providing data, Supply Chain modeling, and analytical expertise.
• Other duties as assigned

Minimum Education

High School Degree

Minimum Special Certifications or Technical Skills

• Advanced Microsoft Excel (i.e. macro's, modeling, data management)
• Advanced Microsoft Access (i.e. creating databases, tables, forms, queries, reports, macros and general use)

Minimum Type of Experience the Job Requires

• 2-5 years of industry experience
• Minimum 2 years experience in an analyst role working with Excel and Access
• Outstanding process management and data handling skills

Preferred Education

Bachelor's Degree in Engineering, Logistics or Finance

Preferred Special Certifications or Technical Skills

Merchandise planning systems, forecasting methods, VBA, Micro strategy, ODBC, SQL, Alteryx, Tableau, any supply chain modeling tools

Preferred Type of Experience the Job Requires

• Supply chain and finance experience
• Retail and forecasting knowledge and experience
• General knowledge of inventory forecasting, inventory management, project management, total supply chain costs, finance, and logistics