Analyst, Business Intelligence - Stores

Want to help pets live their best lives?

We’re proud to be where the pets go and where the pet people go. If you want to make a real difference, create an exciting career path, feel welcome to be your whole self and nurture your wellbeing, Petco is the place for you.

Our core values capture that spirit as we work to improve lives by doing what’s right for pets and people.

• Pet First – Protect & Empower. All pets should Live their Best Life. We put the needs of pets and pet parents at the center of everything we do.

• Foster the Fun – Connect & Bond. Our Passion for pets brings us together! We celebrate the journey of pet parenthood through distinct experiences, products, and services.

• Let’s Go! Own & Commit. We are stronger as One Petco team. We bring our unique superpowers and champion authenticity in everyone to drive success.

About Petco:

We’re proud to be "where the pets go" to find everything they need to live their best lives for more than 60 years — from their favorite meals and toys, to trusted supplies and expert support from people who get it, because we live it. We believe in the universal truths of pet parenthood — the boundless boops, missing slippers, late night zoomies and everything in between. And we’re here for it. Every tail wag, every vet visit, every step of the way. We are 29,000+ strong and together we nurture the pet-human bond in more than 1,500 Petco stores across the U.S., Mexico and Puerto Rico, 250+ Vetco Total Care hospitals, hundreds of preventive care clinics and eight distribution centers. In 1999, we founded Petco Love. Together, we support thousands of local animal welfare groups nationwide and have helped find homes for approximately 7 million animals through in-store adoption events.

Enterprise Analytics & Data Science Department

The Enterprise Analytics & Data Science department is responsible for leveraging strategic insights, customer analytics, data science, and market intel to understand customer behavior trends, product relationships, competitive positioning, and marketing opportunities to maximize financial performance and deliver exceptional customer experience.

The Business Intelligence team translates raw data into clear, actionable reporting and analytics. We develop efficient reporting solutions that help business leaders make timely, data-backed decisions with confidence.

About the Role

Are you an analytical problem-solver looking to accelerate your career in retail analytics and data visualization? In this role, you will bridge the gap between complex datasets and retail business partners, developing intuitive dashboards, reports, and data visualizations that drive strategic decision-making across our retail operations.

The ideal candidate has a strong eye for data visualization, solid SQL skills, and a genuine curiosity for understanding retail performance. You will partner closely with business leaders to translate raw data into clear, compelling visual narratives using modern BI platforms, helping the team monitor key metrics and spot operational opportunities.

Key Responsibilities

Dashboard Development, Data Preparation & Retail Analysis

Data Visualization & Reporting: Develop visually compelling, user-friendly, and high-performance dashboards. Our preferred BI platforms are MicroStrategy or Looker, though proficiency in Power BI or Tableau is highly valued.

UI/UX & Report Design: Apply clean visualization and design principles to ensure reporting layouts are intuitive, clear, and optimized for fast business decision-making.

Data Processing & SQL Queries: Write efficient SQL queries to profile, extract, filter, and structure raw data from cloud databases for seamless dashboard integration.

Quality Assurance & Credibility: Embed rigorous quality check standards into development workflows, ensuring high data accuracy and building total user trust in business reporting.

Performance Tuning: Troubleshoot and resolve basic performance issues in dashboards to guarantee a seamless, fast, and reliable end user experience.

Reporting Efficiencies: Maintain and optimize scheduled reporting cadences. Help streamline delivery processes using built-in BI tool scheduling or spreadsheet-based functions.

Legacy Report Optimization: Work to modernize legacy Excel spreadsheets or manual reporting processes, transitioning them into more sustainable, auto