Sr Analyst-Operational Reporting

PetSmart Store Support Group, Inc.; Phoenix (AZ); Hybrid; USD 110,000 - 140,000; Full time

Job summary

PetSmart is seeking a Sr. BI Developer to support Store Operations & Services from the Phoenix Home Office. You will deliver data-driven insights, translate requirements into BI solutions, and partner with IS and business teams to drive operational efficiencies across the store network.

The role requires cross-functional collaboration, strong analytical skills, and experience with BI tools such as MicroStrategy, Tableau, and ThoughtSpot. A hybrid work model with in-office presence is expected.

Qualifications

• Bachelor's degree in Business, Finance, Statistics, Economics, or related field and 3+ years in finance or analytical reporting.
• Retail experience preferred.
• Strong analytical, problem-solving and communication skills.

Responsibilities

• Define, measure, analyze, implement and control a portfolio of Store Operations reporting.
• Influence leaders and align with directors to improve delivery and operations.
• Lead user acceptance testing for BI reporting metrics and resolve data errors.
• Translate business needs into reporting solutions via data stack, ETL and outputs.
• Develop enterprise-ready reporting with cross-functional IS and business teams.
• Create visualizations and UI applications from standard data.
• Collaborate on roadmap and vision for reporting solutions.

Skills

DMAIC

SQL

Python

R

Data Visualization

Analytical thinking

Communication

BI reporting

Education

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

Tools

MicroStrategy

Tableau

ThoughtSpot

Excel

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

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 the Phoenix Home Office - visa sponsorship is not available for this role

Summary

The Sr. BI Developer, serving the Store Operations & Services teams, is responsible for providing data-driven insights through strong analytical and critical-thinking skills, with a focus on delivering actionable business recommendations that drive operational efficiencies across the store network. This position requires cross-functional collaboration throughout the organization, both at the Home Office and in the Field, to compile and synthesize robust datasets and produce actionable, standardized reporting. The role identifies, defines, analyzes, prioritizes, tests, and refines reporting requirements and partners with cross-functional IS and business teams (Store Operations & Services) to deliver the final product.

The role works directly with internal stakeholders, including business partners and IS teams, to translate requirements into solutions. The candidate must be able to work independently or on a cross-functional team in a fast-changing environment while participating in a variety of projects, serving as an analytical partner, and providing data-driven solutions.

Essential Duties & Responsibilities

Reporting & Analytics

• Define, Measure, Analyze, Implement and Control (DMAIC) a portfolio of Store Operations reporting focused on understanding, supporting, and improving relationships with internal Home Office and Field partners and external customers.
• Influence business leaders, with Director alignment, to accept and better understand delivery, technology, and alternative views that elevate operations.
• Lead user acceptance testing by comprehending, driving, and validating BI reporting metrics, attributes, and objects; clearly communicate data or object errors requiring correction by IS partners; and follow through to resolution, including root-cause evaluation.
• Translate business needs into reporting solutions through the data stack, data storage, and ETL processes; fully comprehend and roadmap final data outputs with team support.
• Translate technical specifications for business users and business requirements for technical teams.
• Lead dotted-line IS team builds to deliver enterprise-ready reporting solutions.
• Engage and collaborate on the development of a vision and roadmap that continuously advances reporting solutions.
• Understand and apply IT terminology and a team-based approach to end-to-end reporting solutions, including big data, ETL, mapping and architecture, and report development.
• Turn standard data into visualizations and elevated user-interface applications.
• Resolve issues quickly and accept responsibility for resolution.

Business Intelligence (BI) Development

• Seek, communicate, and partner on technical solutions with enterprise data warehouse teams; research gaps between business requirements and current reporting or data solutions and recommend options.
• Develop the acumen and technical capabilities to modify and improve the enterprise BI metric portfolio and perform full discovery of root system issues and complex system and table mappings.
• Leverage and extract big data; develop knowledge of global architecture and mapping; and perform data queries that translate into big-data engineering activities, including design, coding, and testing using SQL, Python, R, or similar tools.
• Maintain, redesign, and elevate BI reporting tools such as MicroStrategy, Tableau, and ThoughtSpot; MicroStrategy experience is preferred.
• Steer complex reporting discovery into insightful reporting solutions and business processes; clarify results and persuade leaders and partners to act, adopt, and become comfortable with new information.

Production / Project Management

• Support the Director and, at times, VPs or SVPs on key projects, analysis, modeling, report development, and ad hoc work that may require independent or cross-functional execution.
• Serve as the point person for week-to-week progress, testing, and delivery by dotted-line IT partners; translate directed strategy into action in IT delivery.
• Develop a detailed understanding of business operations and apply organizational knowledge gained through manager and partner interactions to current and future deliverables, data enhancements, and reporting.
• Manage time, prioritize work, and multitask across multiple assignments.

Supervisory Responsibilities

• No direct supervisory responsibility.

Education & Experience

• Bachelor's degree from a four-year college or university in Business, Finance, Statistics, Economics, or a related field and three or more years of related experience in finance or analytical reporting; or an equivalent combination of education and experience.
• Retail experience preferred.

Knowledge, Skills & Abilities

• Strong business and financial acumen, including the ability to interpret and use key financial and statistical data.
• Ability to synthesize multiple datasets in varying formats into a coherent story and effectively communicate to multiple organizational levels.
• Excellent problem-solving, analytical, and critical-thinking skills.
• Outstanding organizational skills and attention to detail.
• Ability to multitask in a fast-paced, dynamic environment.
• Proficiency with Microsoft Office Suite, including intermediate to advanced experience with Excel, Word, PowerPoint, SharePoint, and Access.
• Strong working knowledge of MicroStrategy, business intelligence tools, and/or other advanced programming applications used for data definition and manipulation.
• Ability to work independently and collaboratively on cross-functional teams.
• Ability to translate between technical specifications and business requirements.

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.

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

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