Senior Data Engineer

Talentify; Phoenix (AZ); Hybrid; USD 120,000 - 180,000; Full time

Job summary

PetSmart is seeking a Senior Data Engineer in Phoenix, AZ to design and implement BI solutions that drive business value. You will collaborate on architectures, develop end-to-end data pipelines, and ensure robust reporting across multiple sources.

The role requires strong SQL, Python, ETL/ELT skills and experience with MicroStrategy and Tableau, plus hands-on work with Snowflake, Denodo, and Alteryx. A Bachelor’s degree and 5+ years in BI are required.

Qualifications

• Bachelor’s degree or equivalent in Engineering, Computer Science, MIS, or related field.
• Five (5) years of related progressive experience after completing the Bachelor’s Degree.
• Five (5) years of experience with end-to-end BI solutions using MicroStrategy and Tableau and with data warehousing.
• Three (3) years of experience designing and maintaining ETL/ELT processes using ETL/ELT and Python-based frameworks.

Responsibilities

• Collaborate with information architecture, lead engineers and business area teams to build detailed technical design documents.
• Apply understanding of business intelligence, data warehousing, data modeling, architectures, and terminology.
• Develop relationships with internal and external partners.
• Design, build, test, and deploy full lifecycle reporting and analytic solutions.
• Design and maintain ETL/ELT processes to ingest data from multiple sources.
• Contribute to development best practices and roadmap strategies.
• Work within Agile methodologies to deliver features and stories on time.
• Partner with business teams and external vendors to implement solutions.

Skills

SQL

Python

ETL/ELT

MicroStrategy

Tableau

Education

Bachelor's degree

Tools

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.

Our Technology team 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.

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. The Senior Data Engineer is responsible for designing, developing, and implementing Business Intelligence (BI) solutions by utilizing our enterprise technologies and architecture. Specific duties include:

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

This position requires a Bachelor’s degree or equivalent in Engineering, Computer Science, Computer Engineering, MIS, or related field and five (5) years of related progressive, post-baccalaureate experience. Must also have five (5) years of experience with each of the following:

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

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.

<