Senior Data Engineer Job Phoenix Arizona USA,IT/Tech

About the Team

It’s an exciting time in technology, and that buzz is felt throughout Pet Smart! 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 Pet Smart’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 Pet Smart, 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

Pet Smart 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

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.

Apply an understanding of business intelligence, data warehousing, data modeling, architectures, and terminology.

Develop successful relationships with external and internal partners.

Be accountable for the design, build, test, and deployment of full lifecycle reporting and analytic solutions.

Design and maintain ETL/ELT processes to ingest data from multiple sources (APIs, flat files, RDBMS, Web) using ETL/ELT and Python-based frameworks.

Champion efforts to ensure appropriate development best practices and assist with strategy and roadmap development.

With our Agile methodologies, work on features and stories, meet business expectations, influence outcomes, and maintain stated timelines.

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 Micro Strategy, Denodo, Alteryx, Snowflake, and Big Data.

Qualifications

Designing, architecting and deploying end-to-end BI solutions using Micro Strategy and Tableau enterprise tools, and performing application-level schema design, dimensional data modelling for analytical reporting, dashboard development, and security administration.

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.

Writing complex SQL queries and PL/SQL (stored procedures, functions), and performing query optimization for large-scale data warehouses.

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

About the Culture

At Pet Smart, Anything for Pets begins with our people. Every associate plays a vital role in creating meaningful experiences for…