Sr Merch Corporate Planning Analyst

PetSmart • Phoenix, AZ

1d • Hybrid

About The Position

The Senior Merch Corporate Planning Analyst enables data-driven merchandising decisions by developing scalable analytics solutions, forecasting models, and reporting frameworks. This role combines advanced analytics, data automation, and merchandise planning expertise to deliver insights that improve merchandising performance, operational efficiency, and strategic planning.
The position partners closely with Merchandise Planning & Allocation, Buying, Pricing, Finance, Supply Chain, Marketing, Digital, and Store Operations to translate business needs into actionable analytics and technical solutions. The ideal candidate brings strong analytical and technical skills, a deep understanding of retail performance metrics, and the ability to communicate insights clearly to both technical and non-technical stakeholders.

Requirements

• Bachelor’s degree in Business, Finance, Data Science, Computer Science, Mathematics, or related field
• 2+ years of relevant experience in analytics, data engineering, merchandising analytics, or financial planning
• or 5+ years of equivalent professional experience
• Strong analytical and problem-solving skills with the ability to translate business needs into analytical solutions
• Advanced SQL for data querying and modeling
• Experience with data visualization tools (Tableau, Power BI, Strategy/MicroStrategy)
• Familiarity with Python for data analysis and automation
• Experience with Snowflake or cloud data platforms
• Knowledge of data modeling, data governance, and data security best practices
• Experience with Excel, PowerPoint, and analytics tools
• Excellent communication and presentation skills with the ability to influence business partners
• Ability to explain technical concepts to non-technical stakeholders
• Strong organizational skills with the ability to manage multiple priorities in a fast-paced environment
• Self-directed, proactive, and detail-oriented

Nice To Haves

• Retail industry experience preferred
• Familiarity with Alteryx, Jira, Confluence, or similar platforms a plus

Responsibilities

• Conduct advanced analyses to evaluate merchandise performance, identify trends, and measure the effectiveness of strategic initiatives across sales, margin, inventory, pricing, promotions, and digital channels.
• Develop forecasting models and analytical frameworks that support merchandise financial planning and corporate initiative planning.
• Provide data-driven recommendations to key stakeholders to improve financial outcomes and operational efficiency.
• Perform complex data mining and ad-hoc analysis to answer strategic business questions.
• Design, build, and maintain scalable data pipelines, datasets, and analytical tools that support merchandising insights and reporting.
• Develop scripts, applications, and automations that streamline data workflows and improve operational processes.
• Optimize data structures and models to support reporting, forecasting, and analytics.
• Develop and maintain standardized dashboards, reports, and visualizations to improve visibility into business performance.
• Translate analytical findings into clear insights and recommendations for stakeholders at multiple levels of the organization.
• Partner cross-functionally with merchandising, finance, supply chain, marketing, and digital teams to align analytics solutions with business needs.
• Identify opportunities to improve data quality, reporting processes, and analytical capabilities.
• Maintain documentation for data models, workflows, and tools to ensure scalability and long-term maintainability.

Benefits

• Pet-friendly environment, bring your pets to work and enjoy the on-site dog park!
• On-Site Events & Adoptions, enjoy community-building opportunities, including pet adoption days, seasonal celebrations, family events, art events, & holiday festivals
• “Top Dog” gym with equipment, fitness classes, massage therapists, personal trainers, and wellness spaces
• “Sit & Stay” Café serving fresh breakfast and lunch options, snacks, & more
• “Lil Paws” NAEYC-accredited onsite childcare facility providing high-quality early education
• Paid Volunteer Opportunities to spend time doing good for causes close to heart
• Print Center and Business Services, Dry Cleaning, Mother's Rooms, Sustainable Infrastructure & more

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees