Lead Reporting Analyst-Ops & Services

PetSmart; Phoenix (AZ); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Pet-friendly culture

Job summary

PetSmart is seeking a Lead Analyst for Store Operations Reporting Solutions at our Phoenix office. You will develop data-driven insights across multiple source-systems and lead the design, delivery and innovation of reporting to 1,650+ stores and executives.

You will guide IT/IS workflows, define reporting requirements, and partner with business leaders to translate needs into actionable data solutions while maintaining high-quality data standards.

Qualifications

• Bachelor's degree in Analytics, Systems, Business, Finance, Statistics, Economics or related field required.
• 7+ years of experience in finance or analytical reporting preferred.
• Experience translating business needs into data-driven reporting solutions.
• Retail/Store Operations experience is a plus.

Responsibilities

• Lead BI development using enterprise data warehouse and BI tools to deliver standardized reporting for 1,650+ stores and executives.
• Define, measure, analyze, improve and control a portfolio of store operations reporting using DMAIC methodology.
• Collaborate with Home-Office and Field Partners to translate requirements into end-to-end data solutions.
• Oversee IT/IS workflows for reporting delivery and ensure data quality and visualization standards.

Skills

Analytical thinking

Financial acumen

Problem solving

Attention to detail

Multitasking

Communication

Education

Bachelor's degree in Analytics, Systems, Business, Finance, Statistics, Economics or related field

Tools

MicroStrategy

Tableau

ThoughtSpot

SQL

Python

R

ETL

Excel

Word

PowerPoint

SharePoint

Access

Job description

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

lead 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.

About The Location

Collaborative Work Environment

At PetSmart, 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.

About The Job

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

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

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%)

• Define, Measure, Analyze, Implement and Control (DMAIC) a portfolio of Store Operations 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.

Additional Job Considerations

• This role requires collaboration, teamwork, and face-to-face interaction with colleagues, leaders, and/or clients.
• Being in the office ensures access to leaders, cross-functional partners, and resources necessary to make timely decisions and drive results.
• On‑site presence in accordance with our FlexSmart policy supports our culture of innovation, mentorship, and engagement, which is integral to our success in developing the best team.
• This is not intended to be an all-inclusive, exhaustive list of all essential job functions for this position. PetSmart retains the right to change or assign other required job duties to this position.

About The Culture

Our associates are the heart of Team PetSmart. Together, we’re building the best team in retail through our values-based culture, connection, and teamwork. Our goal is to create a culture where associates learn and grow together, thrive as effective teams and challenge each other to be the best they can be.

• 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

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.