Operations Planning Analyst

The Michael's Companies; Irving (TX); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

401(k) match

Employee Assistance Program

Medical, dental, and vision coverage

Tuition assistance

Employee discounts

Job summary

The Michaels Companies in Irving, TX is seeking an Operations Planning Analyst to support the Supply Chain with forecasting, planning, and analytical modeling. You will develop inventory and flow models, assist with budgeting, and deliver timely reports to drive space, labor, and process improvements.

Ideal candidates have 2–5 years in analysis with advanced Excel and proficiency in Alteryx and BigQuery. Join a team focused on optimizing supply chain efficiency and cost management.

Qualifications

• Advanced Microsoft Excel (macros, modeling, data management).
• Advanced proficiency in Alteryx and Google BigQuery.
• 2-5 years of industry experience in an analyst role 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 from merchandising data.
• Provide DC management with space and labor planning information.
• Support monthly and yearly budgeting with flow and inventory projections.
• Produce timely reports and analyze performance versus goals.
• Design and maintain analytical models and productivity tools.
• Utilize Excel, Alteryx, and Google BigQuery for reporting needs.
• Identify supply chain opportunities through analysis and project design.
• Collaborate with cross-functional teams to improve product flow.

Skills

Excel macros

Excel modeling

Alteryx

BigQuery

SQL

Tableau

VBA

Education

High School Diploma

Bachelor’s Degree in Engineering, Logistics or Finance

Tools

SQL

Tableau

ODBC

Job description

## Operations Planning AnalystApplylocations: Irving-Irving Corporate Office-3939 West John Carpenter Freewaytime type: Full timeposted on: Posted Todayjob requisition id: R00319489Support 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.* - 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.com and Michaels.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).*