Lead Analyst, Store Reporting Solutions

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, PetsHotel, 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 & Flexible Work Environment: We believe in fostering growth, teamwork and creativity in a dynamic workplace. This role is based at PetSmart’s Phoenix Home Office, where associates currently enjoy the benefits of in-person collaboration while having the flexibility to work remotely one day per week (a “flex workday” with leader approval), and an expected four days in the office. At PetSmart, you’ll be part of an engaging and supportive environment designed to help you and our teams thrive.

SUMMARY

The Lead Analyst position within the Store 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.

This job is onsite in our Phoenix Home Office - visa sponsorship is not available for this role

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 MicroStrategy).
• 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 MicroStrategy, Tableau, Thoughtspot, etc; Microstrategy preferred
• Steer complex reporting discovery into insightful reporting solutions and business processes; clarify results and persuade leaders and partners to action, adopt and feel comfortable with new information.

Reporting & Analytics (40%)

• D efine, M easure, A nalyze, I mplement and C ontrol (DMAIC) a portfolio of store reporting, focused on understanding, supporting and improving overall relationships with our internal (Home-Office & Field Partners) and external customer(s).
• Influence business leaders to accept and better understand delivery, technology and alternative views that elevate operations.
• User Acceptance Testing: Comprehend, drive and validate BI-reporting metrics, attributes and objects; clearly communicate data and/or object errors that need to be corrected by IS partners – follow through to resolution – will require root cause evaluation.
• Ability to take business needs then persuade & elevate IT operations via the usual data stack, data storage, and translation of that data to reporting (ETL) – IT owns all data; the candidate will fully comprehend, then roadmap that final, data output.
• Capacity to translate technical specifications back down to business users and vice versa.
• Lead dotted-line, IS Team builds in order to deliver enterprise-ready reporting solutions.
• Be Passionate about “Learning Agility;” Engage and collaborate on the development of a vision and roadmap to continuously take reporting solutions to the next level.
• Ability to understand and apply IT lingo and a team-approach to solutioning end-to-end reporting (Big Data, ETL, Mapping/Architecture and report build)
• Have a strong desire to turn standard data into visualizations and elevated user-interface applications
• Resolve issues quickly and accept responsibility for the resolution.
• Builds strong relationships with Home-Office and Field partners, while actively communicating with the teams to identify and build analytical capabilities, maintaining best practices to develop and support high quality data standards and analysis.
• Ability to manage time, prioritize work, multi-task across many assignments

Production/Project Management (20%)

• Supports Director, and often times VPs/SVP, on key projects, analysis, and modeling/report development including ad-hoc work that may require working independently or cross-functionally.
• Point-person for week-to-week progress, testing and delivery of our dotted-line IT partners; take leadership strategy and drive action in the IT delivery.
• Gain understanding of the business operations in detail; then, apply organizational knowledge, through manager and partner learnings/interactions, to current and future deliverables, data enhancements and reporting.

SUPERVISORY RESPONSIBILITIES

No direct supervisory responsibility.

BUDGET RESPONSIBILITY

This position has no budget responsibility.

EDUCATION and/or EXPERIENCE

Bachelor's degree from a four-year college or university in Analytics, Systems, Business, Finance, Statistics, Economics or related field and +7 years related experience working in finance or analytical reporting; or equivalent combination of education and experience.

Retail experience preferred.

TECHNICAL SKILLS

• Must demonstrate strong business and financial acumen, including the ability to interpret and utilize key financial and statistical data
• Must be able to synthesize multiple data sets, of varying formats, into a coherent story and effectively communicate to various levels of the organization
• Must possess excellent problem-solving, analytical and critical thinking skills.
• Must possess outstanding organizational skills, including attention to detail
• Must be able to multi-task in a fast paced, dynamic environment
• Must be proficient in using the Microsoft Office Suite including intermediate to advanced experience with Excel, Word, PowerPoint, SharePoint, and Access.
• Must have strong working knowledge of MicroStrategy and/or Business Intelligence (BI) and/or other advanced programming applications used for data definition and manipulation.

CERTIFICATES, LICENSES, REGISTRATIONS

None required.

PHYSICAL DEMANDS and WORK ENVIRONMENT

The physical demands and work environment are characteristic of those found in a typical business office environment. Reasonable accommodations may be made for individuals with disabilities to perform essential functions.

At PetSmart, we work hard to create a culture where 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 #Life A tPetSmart here:
• Check out Associate stories and share in some celebrations at PetSmart:
• Explore PetSmart Benefits here:
• If you don't already live in the Phoenix area here's a guide to the area:

PetSmart provides an equal opportunity for all associates and job applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other legally protected characteristics.