Senior Data Engineer

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

Benefits offered by this job

Pet-friendly environment with dog park

On-site events & adoptions

Top Dog gym and wellness facilities

Job summary

PetSmart is seeking a Senior Data Engineer in Phoenix, AZ to design, develop, and deploy BI solutions. You will lead ETL/ELT processes, collaborate with architects and engineers, and ensure data quality for analytics across multiple sources using MicroStrategy, Snowflake, and other tools.

The role emphasizes BI reporting, data warehousing concepts, and partnership with stakeholders to drive business outcomes. Hybrid work model with four days in the office and one flexible remote day.

Qualifications

• Design and deploy end-to-end BI solutions using MicroStrategy/Tableau and data modelling for analytics.

Responsibilities

• Collaborate with architecture & engineering teams to create technical design documents.
• Apply BI/data warehousing concepts and terminology.
• Build strong relationships with internal/external partners.
• Own design, build, test, and deployment of BI reporting/analytics solutions.
• Design and maintain ETL/ELT processes using Python-based frameworks.
• Promote development best practices and contribute to roadmap strategy.
• Work in Agile with defined timelines and deliverables.
• Partner with business teams and vendors to implement solutions.

Skills

BI design

Data modeling

Dashboard development

Security administration

SQL

PL/SQL

Python

Automation

Education

Bachelor's Degree in Computer Science

Tools

MicroStrategy

Denodo

Alteryx

Snowflake

Job description

About the Team

It’s an exciting time in technology, and that buzz is felt throughout PetSmart! We are continuing to grow at a faster pace and we want to continue to provide best-in-class experiences for pets and pet parents.

OurTechnologyteam has 6 different departments: Information Security, Service Delivery, Business Enabling Systems, eCommerce & Marketing Technology, Data and Stores, Services & Supply Chain.

Whether it’s online or in our stores, the work that the IT team does is instrumental in PetSmart’s success. We have a strategic and actionable plan underway and are looking for associates who are just as excited about it as we are.

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

PetSmart LLC seeks a full-time Senior Data Engineer based in Phoenix, AZ. The Senior Data Engineer is responsible for creating sustainable reporting, analytic, and data solutions to meet business needs, create business value, and drive outcomes. This position designs, develops, and implements Business Intelligence (BI) solutions by utilizing our enterprise technologies and architecture.

Key Responsibilities

1. Collaborate with Information Architecture, Lead Engineers and business area teams to build detailed technical design documents, to meet business needs for complex projects, considering capabilities, risks, and system dependencies.
2. Apply an understanding of business intelligence, data warehousing, data modeling, architectures, and terminology.
3. Develop successful relationships with external and internal partners.
4. Be accountable for the design, build, test, and deployment of full lifecycle reporting and analytic solutions.
5. Design and maintain ETL/ELT processes to ingest data from multiple sources (APIs, flat files, RDBMS, Web) using ETL/ELT and Python-based frameworks.
6. Champion efforts to ensure appropriate development best practices and assist with strategy and roadmap development.
7. With our Agile methodologies, work on features and stories, meet business expectations, influence outcomes, and maintain stated timelines.
8. Partner with business teams and external third-party vendors to execute solutions.

Tools and technologies utilized in this position include SQL scripting (Netezza, SQL Server, and Snowflake); Software Development Life Cycle (SDLC) / Agile development to plan and organize work activities for team execution; and enterprise technologies and architecture, including MicroStrategy, Denodo, Alteryx, Snowflake, and Big Data.

Qualifications

1. Designing, architecting and deploying end-to-end BI solutions using MicroStrategy and Tableau enterprise tools, and performing application-level schema design, dimensional data modelling for analytical reporting, dashboard development, and security administration.
2. Collaborating with a company’s data/solution architects, lead engineers, business teams and stakeholders to capture and analyze business requirements and technical solutions to build detailed design documents that consider capabilities, risks, and system dependencies.
3. Writing complex SQL queries and PL/SQL (stored procedures, functions), and performing query optimization for large-scale data warehouses.
4. Python scripting, and experience automating data tasks, file manipulation, or system monitoring processes.

Must also have three (3) years of experience with designing and maintaining ETL/ELT processes to ingest data from multiple sources (APIs, flat files, RDBMS, Web) using ETL/ELT and Python-based frameworks. All experience may have been gained concurrently. Experience must have been acquired after completion of the Bachelor’s Degree program. Apply online at https://careers.petsmart.com.

About the Culture

At PetSmart, Anything for Pets begins with our people. Every associate plays a vital role in creating meaningful experiences for pets and their families, and we empower our teams with the tools, resources, and opportunities to grow and succeed.

We’re more than a workplace, we’re Team PetSmart. Together, we grow, collaborate, and challenge ourselves to be the best in all we do. Our culture is built on belonging and shared purpose, where every voice and experience matters. Guided by our values, we strive to do what’s right, lead responsibly, and bring our passion for pets to life every day. 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 might be the right fit for this role or another opportunity across Team PetSmart.

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.