Sr. Analyst, Promo Reporting and Analytics

Full Time
Phoenix, AZ 85027
Posted
Job description
About the Team

It's no surprise people are passionate about the health and happiness of their pet and our Merchandising (buying) team is no different. When it comes to the products and solutions in our stores, our incredible teams of merchandising associates have everything covered – from head to tail! From keeping up with the top trends to developing new, innovative solutions, our buyers help ensure every pet parent can find exactly what their pet needs at PetSmart. Join our team and show your love for pets by creating products as special as pets themselves!


About the Location

Hybrid Position:
This position may be considered Hybrid based on PetSmart’s FlexSmart policy and business needs. A Hybrid work arrangement is considered to be a blend of onsite and remote work activity. Associates with a Hybrid work arrangement have a work space at Phoenix Home Office and can be required to come onsite between 1-5 days a week as determined by leadership and based on business needs.

About the Job

About the Pricing Team

The PetSmart Pricing team provides product and market analytics in support of promotional decision making that aligns with the company’s strategic and financial goals. The geographic scope of responsibility encompasses all PetSmart brick and mortar stores in the U.S. as well as the promotion activity for products sold on PetSmart.com. The Pricing team’s primary scope is focused on base price management, promotional efficiency and markdown optimization. The Pricing team is a highly analytical team and takes great pride in being subject matter experts across a wide array of analytical platforms including MicroStrategy, Power BI, Alteryx and direct SQL.


About the Sr. Analyst, Promo Reporting and Analytics Position


This position is a critical role that will help support the reporting/analytics needs of the pricing team whose responsibilities include:


  • Optimizing the reports needed on the Pricing Team to give actionable insights to drive the business
    • Promotional Optimization: Assist in the development, management & training of an all-encompassing promo optimization tool used to forecast and house all future promotional activity.
    • Post-Mortem Analysis: Develop & manage a dashboard analyzing each division’s promotional strategy, reporting out on actuals versus forecast, ultimately assigning a grade at several hierarchy levels.
    • Test & Measures: Assist in the execution of various store level tests submitted/requested from the merch team & aid in reporting out on results/recommendations.
  • Identify potential financial risks associated with the promotional strategy
  • Provide analytical support on an ad hoc basis to help drive business results as needed
  • Be able to work cross functionally within the organization (IT/Planning/Merchandising, etc) to help achieve company goals and objectives
  • Take initiative on optimizing current processes/tools/dashboards to maximize output and drive actions that will help support the company goals and objectives
  • Be a steward of change and creativity with problem solving
  • Actively create and lead special projects that drive growth opportunities

Minimum Qualifications:


Education:
BS degree in Finance, Business, Economics or Analytical Field (Statistics, Applied Mathematics, etc.) (MS preferred); or proven equivalent experience


Core Competencies

  • 3-5 years’ experience with data management and dashboard creation in various visualization tools (Excel, PBI, Tableau, etc.)
  • Solid understanding of SQL and Alteryx workflows
  • Bias for action and comfortable working in a rapidly changing retail environment
  • Ability to deal with ambiguity and propose creative solutions
  • Enjoy teaching others about Analytics and Research and enthusiastic about serving as a corporate authority (SME) in a technical discipline and being recognized as a world class expert

Technical Skills

  • Highly proficient in Excel and Microsoft Office Suite
  • Working knowledge of basic promotional principles (i.e. baseline, incrementality, discount structure, etc.)
  • Solid understanding of retail/CPG product hierarchies and database structures
  • Solid experience with SQL and MicroStrategy, Alteryx, Project Management/Technical Product Management a plus
  • Programming experience with at least one of R, Python or Spark is a plus

About the Culture


At PetSmart, we work hard to create a culture where every associate feels like they truly belong and we celebrate the unique stories, backgrounds, and experiences our associates share. These experiences not only bring new perspectives in shaping our Belonging culture but they’re core to PetSmart’s success.


Not sure if you meet 100% of the position requirements and whether you should apply? We’d still like to hear from you and encourage you to apply with us! You just may be the ideal candidate for this role, and if not this one, perhaps another position.

Our home office offers outstanding amenities in a fun and rewarding workplace including:

  • Pet friendly environment, bring your pets to work!
  • On-site Dog Park
  • “Top Dog” gym with equipment, fitness classes, massage therapists and personal trainers
  • “Sit & Stay” Café serving fresh breakfast and lunch options
  • On-site coffee bar
  • “Lil’ Paws” learning center and onsite daycare facility (associate paid)
  • Volunteer events with PetSmart Charities
  • Learn more about #LifeAtPetSmart here: https://www.lifeatpetsmart.com/life-at-petsmart/
  • Check out Associate stories and share in some celebrations at PetSmart: https://www.blog.lifeatpetsmart.com/
  • Explore PetSmart Benefits here: https://benefits.petsmart.com/
  • If you don't already live in the Phoenix area here's a guide to the area: Welcome to Phoenix Guide

johnandkristie.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, johnandkristie.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, johnandkristie.com is the ideal place to find your next job.

Intrested in this job?

Related Jobs

All Related Listed jobs