Analyst, Business Intelligence - Stores & Services

Petco; San Diego (CA); On-site; USD 64,000 - 106,000; Full time

Job summary

Petco is seeking an analytical BI professional to bridge data and retail business partners, building dashboards, reports, and visualizations that drive strategic decisions across our retail operations.

You will translate raw data into clear narratives using BI platforms, monitor key metrics, and spot opportunities to improve performance. Collaboration with leadership and analytics teams is essential.

Qualifications

• Education: Bachelor’s degree in Mathematics, Statistics, Business Analytics, Computer Science, Information Systems, Finance, or a related quantitative/business field.
• Experience: 1–2+ years in Business Intelligence, Data Analytics, or a similar data-driven role
• Industry Experience: Prior experience or strong interest in retail operations, e-commerce, and key retail performance metrics.

Responsibilities

• Dashboard Development, Data Preparation & Retail Analysis
• Data Visualization & Reporting: Develop visually compelling, user-friendly dashboards with BI platforms (Looker, MicroStrategy; Power BI or Tableau also valued)
• UI/UX & Report Design: Create intuitive reporting layouts for fast business decisions
• Data Processing & SQL Queries: Write SQL to profile, extract, and structure data for dashboards
• Quality Assurance: Ensure data accuracy and credibility in reporting
• Performance Tuning: Troubleshoot dashboard performance for a seamless user experience
• Report Maintenance: Schedule and streamline reporting cadences
• Legacy Report Optimization: Modernize legacy reports into automated dashboards
• Stakeholder Communication: Translate data into clear briefs for leadership
• Ad-Hoc Analysis & Leadership Support: Provide data-driven insights for priority inquiries
• Insight Presentation: Present trends and dashboard configurations to cross-functional stakeholders
• Cross-Functional Collaboration: Work with Analytics/Data Science teams to include predictive metrics

Skills

Analytical Mindset

Communication

Time Management

Education

Bachelor's degree in Mathematics, Statistics, Business Analytics, Computer Science, Information Systems, Finance

Tools

Looker

MicroStrategy

Power BI

Tableau

SQL

Excel

Job description

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

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.
• Report Maintenance & Streamlining: 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, automated, or interactive dashboard solutions.
• Stakeholder Communication & Business Analytics Knowledge: Support senior leadership and business stakeholders by conducting objective, data-driven analyses to answer key business questions. Assist in responding to high-priority inquiries by compiling accurate findings into clear, well-structured briefs and summary reports.
• Ad-Hoc Analysis & Leadership Support: Support senior leadership and business stakeholders by conducting objective, data-driven analyses to answer key business questions. Assist in responding to high-priority inquiries by compiling accurate findings into clear, well-structured briefs and summary reports.
• Insight Presentation: Translate data findings into clear, digestible summaries. Present trends and dashboard configurations to cross-functional stakeholders across the business.
• Cross-Functional Collaboration: Collaborate with broader Analytics and Data Science teams to incorporate predictive metrics and model outputs into core operational dashboards.

Qualifications & Skills

Experience & Education

Education: Bachelor’s degree in Mathematics, Statistics, Business Analytics, Computer Science, Information Systems, Finance, or a related quantitative/business field.

Experience: 1–2+ years of hands‑on experience in Business Intelligence, Data Analytics, or a similar data‑driven role

Industry Experience: Prior experience or a strong interest in retail operations, e-commerce, and key retail performance metrics.

Technical Skills

BI Platforms: Hands-on development experience or strong familiarity with modern BI tools (Looker and MicroStrategy preferred, Power BI or Tableau as alternatives).

SQL: Proficiency in SQL for data extraction, querying, profiling, and backend validation.

Spreadsheets: Strong proficiency in Microsoft Excel or Google Sheets for rapid data modeling and analysis.

Scripting (Beneficial): Familiarity with scripting languages (such as Python, JavaScript/Apps Script, or VBA) for task automation is a valuable advantage.

Soft Skills & Competencies

Analytical Mindset & Intellectual Curiosity: A genuine passion for exploring data, asking probing questions, and discovering underlying retail trends.

Communication: Excellent verbal and written communication skills; ability to explain technical layouts to non-technical stakeholders and craft clear, executive-ready performance summaries.

Time Management: Strong organizational skills with the ability to manage multiple priorities and deliver quality work in a fast‑paced retail environment.

#CORP

Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Salary Range

Salary Range: $63,800.00 - $105,600.00

Hourly or Salary Range will be reflected above. For a more detailed overview of Petco Total Rewards, including health and financial benefits, 401K, incentives, and PTO - see https://careers.petco.com/us/en/key-benefits

Petco Animal Supplies, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or any other protected classification.

To translate this webpage to Spanish or other languages on your internet browser, click the translate button to the right of your browser address bar. Additional instructions can be found here: Google Chrome Help .

Para traducir esta página web al español u otros idiomas en su navegador de Internet, haga clic en el botón de traducción a la derecha de la barra de direcciones de su navegador. Puede encontrar instrucciones adicionales aquí: Google Chrome Ayuda.