Operations Planning Analyst

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

Benefits offered by this job

401(k) with employer match

Employee Assistance Program

Medical, dental, and vision coverage

Employee discounts

Job summary

Michaels in Irving, TX is seeking an Operations Planning Analyst to support Supply Chain with forecasting, analytics, and process improvement. You will develop inventory flow forecasts, maintain analytical tools, and model supply chain costs to support company initiatives.

The role requires advanced Excel, Alteryx, and Google BigQuery skills; 2-5 years of experience in an analyst role; a Bachelor’s degree is preferred. You will collaborate across functions to optimize product flow and planning.

Qualifications

• Advanced Microsoft Excel (macros, modeling, data management).
• Advanced proficiency in Alteryx and Google BigQuery.
• 2-5 years of industry experience; 2+ years in an analyst role using Excel.
• Outstanding process management and data handling skills.
• Bachelor’s degree preferred; strong cross-functional collaboration.

Responsibilities

• Assist with DC Forecasting and Planning (Weekly, Monthly, Yearly).
• Develop DC flow and inventory forecasting models using available data.
• 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 BigQuery to support department reporting.
• Identify and manage Supply Chain opportunities; work with cross-functional teams.
• Support projects with data, modeling, and analytical expertise.
• Other duties as assigned.

Skills

Problem solving

Process improvement

Analytical thinking

Cross-functional collaboration

Education

Bachelor’s Degree in Engineering, Logistics or Finance

High School Degree

Tools

Excel

Alteryx

Google BigQuery

VBA

SQL

Tableau

ODBC

Job description

Support Center - IrvingUnder 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.
• - Utilise 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 visit www.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