Pricing Forecast Analyst
About The Position
The Pricing Forecast Analyst analyzes and recommends pricing and promotions strategies and tactics. The role uses strong analytical and mathematical skills and experience manipulating large data sets through internal data warehouse systems. The analyst collaborates with Category Management, Merchandise Planning, Finance, Inventory, and Pricing partners to support strategic pricing across the company. The analyst conducts business analysis to support pricing initiatives, improve existing methodologies, and develop metrics and analytics for pricing strategy. The role also generates and validates promotional offer forecasts, supports promotion hindsight analysis and reporting, and works with Pricing Advisors on pre-season promotion strategies intended to optimize sales and gross margin in alignment with company goals.
Requirements
- Bachelor of Science in Business, Mathematics, Statistics, or Finance.
- At least 2 years of experience 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 an internal data warehouse system.
- Proven leadership and collaboration skills to build cross-functional relationships.
Nice To Haves
- Retail experience as a pricing expert, planner, or analyst.
- Experience using internal data warehouse systems to pull data metrics for analysis.
- Power BI dashboard-building experience.
- SQL experience.
Responsibilities
- Conduct analysis to support pricing initiatives, strengthen existing methodologies, and develop metrics and analytics for pricing strategy and tactics.
- Gather data and manipulate large data sets to create robust business analyses.
- Analyze issues, develop insights, and formulate data-based hypotheses.
- Present findings to Pricing partners.
- Assist in creating weekly, quarterly, and annual reports.
- 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 aligned with company goals and intended to optimize sales and gross margin.
- Use the internal Discount Optimization Tool and other data sources to analyze historical performance, develop reports, and generate 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 coverage, depending on position and eligibility.
- Dental coverage, depending on position and eligibility.
- Vision coverage, depending on position and eligibility.
- Telemedicine services.
- Flexible spending accounts.
- Commuter benefits.
- Tuition assistance.
- Adoption assistance.
- Voluntary insurance options.
- Employee discounts.
- Partner discount programs.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
