Lead Reporting Analyst-Ops & Services

About the Team

There are a lot of activities that happen in our stores so we have a strong cross-functional team focused on doing Anything for Pets by supporting the store teams through effective communications, processes and initiatives. The Store Strategy & Operations department leads the way to support all store activities and define business-driving strategies. The Workforce, Insights & Planning team owns labor optimization and reporting needs.

The Operations & Innovation team owns merchandise execution, process improvement, compliance, store technology and innovation. And the Strategy team leads all the business-driving efforts for Salon, Pets Hotel, Pet Training and In-store customer experience. These teams work diligently to ensure our associates, pets and pet parents are supported, while operating efficiently to drive the business.

Collaborative Work Environment:At Pet Smart, teamwork and connection are core to how we thrive. This role is based at our Phoenix Home Office, with an expectation of working a minimum of four days in the office each week. In a standard work week, associates may work up to one remote “flex day” (with leader approval). Our hybrid approach is designed to foster strong collaboration while also supporting flexibility and individual success.

SUMMARY

The Lead Analyst position within the Store Operations Reporting Solutions team is responsible for developing data-driven insights by solving complex data problems across several source-systems and leading in the design, delivery and innovation of best-in-class reporting distribution to 1,650+ stores, home office executives and business leaders. This position will require cross-functional collaboration throughout the organization, both at the Home-Office and throughout the Field, as the primary touchpoint of end-to-end delivery of robust systems/datasets that ultimately produce actionable, standardized and visually appealing reporting.

In addition, the ideal candidate will identify, define, communicate, analyze, prioritize, test, and refine the reporting requirements and lead, with Director alignment, the IT/IS workflows and final product delivery to the business.

The role will be the ‘primary/lead’ for our various internal stakeholders - business partners and IT/IS teams - to ensure successful translation of those requirements into solutions. The candidate should possess the ability to work independently or on a cross-functional team, in a fast-changing environment while participating in a variety of projects, serving as the business lead for prioritized, data solutions.

ESSENTIAL DUTIES AND RESPONSIBILITIES include, but are not limited to:

Business Intelligence (BI) Development (40%)

• Seek out, communicate and lead technical solutions with the enterprise data warehouse team(s);
  Identify gaps between business requirements and current reporting/data solutions and recommend options.
• Create, modify and improve the enterprise, BI metric portfolio; continuous improvement will require ‘full discovery’ of root, system issues, complex mapping of systems/tables and business introduction to advanced, metric builds (smart metrics in Micro Strategy).
• Leverage & extract big data, articulate global architecture/mapping, and have a passion for learning/performing data queries that translate to big data engineering – design, code, test (SQL, Python, R, etc)
• Primary business operator – complex business questions will drive the candidate to continuously maintain, re-design and elevate BI reporting tools such as Micro Strategy, Tableau, Thoughtspot, etc;
  Microstrategy preferred
• Steer complex reporting discovery into…