Inventory & Strategic Forecasting Analyst

Michaels Stores; Irving (TX); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

401(k) with employer match

Medical, dental, and vision coverage

Telemedicine services

Flexible spending accounts

Employee discounts

Job summary

The Michaels Companies Inc. in Irving, Texas, is seeking an Operations Planning Analyst to support the Supply Chain with inventory flow forecasting, model maintenance, and cost modeling.

You will contribute to budgeting, reporting, and process improvements using Excel, Alteryx, and Google BigQuery. You will develop forecasting models for DCs, provide data-driven insights to space and labor planning, and collaborate with cross-functional teams to optimize product flow and efficiency across the

Qualifications

• Advanced Microsoft Excel (i.e. macros, modeling, data management)
• Advanced proficiency in Alteryx and Google Big Query
• 2-5 years of industry experience
• Minimum 2 years experience in an analyst role working with Excel
• Outstanding process management and data handling skills

Responsibilities

• Assist with DC Forecasting and Planning (Weekly, Monthly, Yearly)
• Develop DC flow and inventory forecasting models using information from merchandising planning systems
• Provide DC management with information to plan space and labor requirements
• Support monthly and yearly budgeting with flow and inventory projections
• Timely and accurate reporting and analysis
• Design, development, and maintenance of analytical models and productivity tools
• Prepare reports showing actual performance vs goals and explain variances
• Utilize Excel, Alteryx, Google Big Query and other tools to facilitate reporting
• Identify and manage Supply Chain opportunities through analysis and project design
• Work with cross-functional teams to enable more efficient product flow through the Supply Chain
• Support projects by providing data, modeling, and analytical expertise

Job description

The Michaels Companies Inc. in Irving, Texas, is seeking an Operations Planning Analyst to support the Supply Chain with inventory flow forecasting, model maintenance, and cost modeling.

You will contribute to budgeting, reporting, and process improvements using Excel, Alteryx, and Google BigQuery. You will develop forecasting models for DCs, provide data-driven insights to space and labor planning, and collaborate with cross-functional teams to optimize product flow and efficiency across the