Pricing Forecast Analyst

Support Center - Irving
The Pricing Forecast Analyst will drive the analysis and recommendation of the Pricing and Promotions strategy and tactics. Exceptionally strong analytical and math skills are required, along with experience manipulating large data sets using internal data warehouse system. Proven leadership and collaboration skills are required to create strong cross functional relationships with Category Management, Merchandise Planning, Finance, and Inventory. Leading in efforts to drive strategic pricing across the company.
Analysis
Conduct analysis to support pricing initiatives, adding rigor to existing methodologies and developing key metrics and analytics to support pricing strategy and tactics.
Gather data and perform analyses manipulating large data sets to create thoughtful, robust business analyses.
Analyze issues, develop insights, and formulate data-based hypotheses.
Present findings to Pricing partners.
Assist in creation of weekly/quarterly/annual reporting.
Promotion Pricing Analysis:
Utilize internal tools and processes to generate and validate Promotional offer forecasts on a regular and ad-hoc basis.
Assist Promotional offer hindsight analysis and reporting
Work with Pricing Advisors to develop pre-season promotion strategies to optimize sales and gross margin in alignment with company goals.
Utilize internal Discount Optimization Tool for historical performance and other data sources to develop reports and strategic insights to improve promotion performance.
Other duties as assigned
Preferred Special Certifications or technical skills
Experience with utilizing internal data warehouse systems to pull data metrics for analysis.
PowerBI dashboard building and SQL
Preferred Type of experience the job requires
Retail experience as a pricing expert, planner, or analyst preferred.
Minimum Education
BS in Business, Mathematics, Statistics, or Finance
Minimum Special Certifications or technical skills
Intermediate to advanced Excel skills including vlookups, pivot tables, comfort with writing formulas, etc.
Minimum Type of experience the job requires
Minimum 2 years in Business
Analyst role in an analytical function
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).
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