Strategic Forecasting Analyst - Supply Chain

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

Support Center - Irving

Under the direction of the Director - Supply Chain, the Operations Planning Analyst will provide strong problem-solving skills, process improvement, and analytical support to the Supply Chain department. This position will be responsible for: inventory flow forecasting through supply chain, maintenance of analytical tools and models, 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 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, Alteryx, Google Big Query 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 proficiency in Alteryx and Google Big Query

Minimum Type Of Experience The Job Requires

• 2-5 years of industry experience
• Minimum 2 years experience in an analyst role working with Excel
• 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, 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

Applicants in the U.S. must satisfy federal, state, and local legal requirements of the job.

At The Michaels Companies Inc., our purpose is to fuel the joy of creativity and celebration. As the leading destination for creating and celebrating in North America, we operate over 1,300 stores in 49 states and Canada and online at Michaels.comandMichaels.ca.The Michaels Companies, Inc. also owns Artistree, a manufacturer of custom and specialty framing merchandise. Founded in 1973 and headquartered in Irving, Texas, Michaels is the best place for all things creative. For more information, please visitwww.michaels.com.

Michaels offers a range of benefits to support team members and their families. Depending on position and eligibility, team members may have access to a 401(k) with employer match, an Employee Assistance Program, medical, dental, and vision coverage, telemedicine services, flexible spending accounts, commuter benefits, tuition assistance, adoption assistance, and various voluntary insurance options. All team members enjoy everyday perks such as employee discounts and access to partner discount programs. For a summary of benefits, visit the Michaels Benefits at a Glance page. For additional information regarding benefits, visit MIKBenefits.com

Michaels is an Equal Opportunity Employer. We are here for all Team Members and all customers to create, innovate and be better together.

Michaels is committed to the full inclusion of all qualified individuals. In keeping with this commitment, Michaels will assure that people with disabilities are provided reasonable accommodations. Accordingly, if a reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the job, and/or to receive all other benefits and privileges of employment, please contact Customer Care at 1-800-642-4235 (1800-MICHAEL).

EEOC Know Your Rights Poster in English

EEOC Know Your Rights Poster in Spanish

EEOC Poster Optimized for Screen Readers

Federal FMLA Poster

Federal EPPAC Poster