Pricing Forecast Analyst

Michaels Stores • Irving, TX

6d

About The Position

The Pricing Forecast Analyst drives the analysis and recommendation of pricing and promotions strategies and tactics. The role requires strong analytical and mathematical skills, experience manipulating large data sets using internal data warehouse systems, and leadership and collaboration skills to build cross-functional relationships with Category Management, Merchandise Planning, Finance, and Inventory. The position contributes to strategic pricing efforts across the company.

The analyst conducts analyses to support pricing initiatives, strengthens existing methodologies, and develops metrics and analytics for pricing strategy and tactics. The role also generates and validates promotional offer forecasts, supports promotional hindsight analysis and reporting, and works with Pricing Advisors on pre-season promotion strategies aligned with company goals. It uses the internal Discount Optimization Tool and other data sources to assess historical performance and develop insights to improve promotion performance. The position may also perform other duties as assigned.

Requirements

• Bachelor of Science in Business, Mathematics, Statistics, or Finance.
• At least 2 years in a business analyst role in an analytical function.
• Intermediate to advanced Excel skills, including VLOOKUPs, pivot tables, and writing formulas.
• Strong analytical and mathematical skills.
• Experience manipulating large data sets using internal data warehouse systems.
• Proven leadership and collaboration skills to create strong cross-functional relationships.

Nice To Haves

• Experience using internal data warehouse systems to pull data metrics for analysis.
• Power BI dashboard-building skills.
• SQL skills.
• Retail experience as a pricing expert, planner, or analyst.

Responsibilities

• Conduct analysis to support pricing initiatives, add rigor to existing methodologies, and develop metrics and analytics supporting pricing strategy and tactics.
• Gather data and manipulate large data sets to produce robust business analyses.
• Analyze issues, develop insights, and formulate data-based hypotheses.
• Present findings to Pricing partners.
• Assist in creating weekly, quarterly, and annual reporting.
• Use internal tools and processes to generate and validate promotional offer forecasts on a regular and ad-hoc basis.
• Assist with promotional offer hindsight analysis and reporting.
• Work with Pricing Advisors to develop pre-season promotion strategies that optimize sales and gross margin in alignment with company goals.
• Use the internal Discount Optimization Tool and other data sources to analyze historical performance and develop reports and strategic insights to improve promotion performance.
• Perform other duties as assigned.

Benefits

• 401(k) with employer match, depending on position and eligibility.
• Employee Assistance Program.
• Medical, dental, and vision coverage, depending on position and eligibility.
• Telemedicine services.
• Flexible spending accounts.
• Commuter benefits.
• Tuition assistance.
• Adoption assistance.
• Voluntary insurance options.
• Employee discounts and partner discount programs.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level