PetSmart Charities
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.
About the Location Collaborative & Flexible Work Environment: We believe in fostering growth, teamwork and creativity in a dynamic workplace. This role is based at PetSmart’s Phoenix Home Office, where associates currently enjoy the benefits of in-person collaboration while having the flexibility to work remotely one day per week (a “flex workday” with leader approval), and an expected four days in the office. At PetSmart, you’ll be part of an engaging and supportive environment designed to help you and our teams thrive.
Senior Data Engineer Responsible for working with Solution Architects and business area teams to build detailed technical design and specification documents, to meet business needs, considering capabilities, risks, and system dependencies regarding ETL integrations. Executes the build, test, and deployment of full lifecycle solutions – for Application Integration & Data Analytics (data integration) for ETL solutions. Builds implementation plans and coordinating deployment with platform teams. Ensures appropriate development best practices. Works on multiple concurrent projects, meeting business expectations, influencing outcomes, and maintaining stated timelines. Supports existing ETL integrations, triaging, and troubleshooting alongside Level 1 support teams and coding and deploying fixes as needed. Mentors/coaches less experienced engineers.
Qualifications This position requires a Bachelor’s degree or equivalent in Computer Science, Data Science, or a related field and 5 years related (progressive, post-baccalaureate) experience. Must also have 24 months of demonstrated experience with each of the following:
Developing ETL flows per design specifications using Informatica Power Center Designer 10.4, Workflow Manager, and Netezza and Snowflake Databases to extract and load data;
Gathering requirements to perform requirement analysis, design, development, and system testing, and creating detailed design Confluence Pages;
Creating reusable components and PL/SQL Stored Procedures to improve reusability and reduce turnaround time, and scheduling and monitoring ETL flows using Tidal jobs;
Creating unit test cases, testing developed code, and ensuring that output is as per given requirements by scheduling workflows and validating data using SQL scripts in Snowflake/ Microsoft SQL Server Management Studio;
Resolving bugs in JIRA during SIT and User testing cycles to find root cause.
Benefits and Culture 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.
Pet friendly environment, bring your pets to work!
On-site Dog Park
“Top Dog” gym with equipment, fitness classes, massage therapists and personal trainers
“Sit & Stay” Café serving fresh breakfast and lunch options
On-site coffee bar
“Lil’ Paws” learning center and onsite daycare facility (associate paid)
Volunteer events with PetSmart Charities
Learn more about life at PetSmart: https://www.lifeatpetsmart.com/life-at-petsmart/
Explore PetSmart Benefits here: https://benefits.petsmart.com/
If you don't already live in the Phoenix area here's a guide to the area: Welcome to Phoenix Guide
Job Details
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Information Technology
Full-time, position located in Phoenix, AZ. Please apply online at https://careers.petsmart.com.
#J-18808-Ljbffr
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.
About the Location Collaborative & Flexible Work Environment: We believe in fostering growth, teamwork and creativity in a dynamic workplace. This role is based at PetSmart’s Phoenix Home Office, where associates currently enjoy the benefits of in-person collaboration while having the flexibility to work remotely one day per week (a “flex workday” with leader approval), and an expected four days in the office. At PetSmart, you’ll be part of an engaging and supportive environment designed to help you and our teams thrive.
Senior Data Engineer Responsible for working with Solution Architects and business area teams to build detailed technical design and specification documents, to meet business needs, considering capabilities, risks, and system dependencies regarding ETL integrations. Executes the build, test, and deployment of full lifecycle solutions – for Application Integration & Data Analytics (data integration) for ETL solutions. Builds implementation plans and coordinating deployment with platform teams. Ensures appropriate development best practices. Works on multiple concurrent projects, meeting business expectations, influencing outcomes, and maintaining stated timelines. Supports existing ETL integrations, triaging, and troubleshooting alongside Level 1 support teams and coding and deploying fixes as needed. Mentors/coaches less experienced engineers.
Qualifications This position requires a Bachelor’s degree or equivalent in Computer Science, Data Science, or a related field and 5 years related (progressive, post-baccalaureate) experience. Must also have 24 months of demonstrated experience with each of the following:
Developing ETL flows per design specifications using Informatica Power Center Designer 10.4, Workflow Manager, and Netezza and Snowflake Databases to extract and load data;
Gathering requirements to perform requirement analysis, design, development, and system testing, and creating detailed design Confluence Pages;
Creating reusable components and PL/SQL Stored Procedures to improve reusability and reduce turnaround time, and scheduling and monitoring ETL flows using Tidal jobs;
Creating unit test cases, testing developed code, and ensuring that output is as per given requirements by scheduling workflows and validating data using SQL scripts in Snowflake/ Microsoft SQL Server Management Studio;
Resolving bugs in JIRA during SIT and User testing cycles to find root cause.
Benefits and Culture 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.
Pet friendly environment, bring your pets to work!
On-site Dog Park
“Top Dog” gym with equipment, fitness classes, massage therapists and personal trainers
“Sit & Stay” Café serving fresh breakfast and lunch options
On-site coffee bar
“Lil’ Paws” learning center and onsite daycare facility (associate paid)
Volunteer events with PetSmart Charities
Learn more about life at PetSmart: https://www.lifeatpetsmart.com/life-at-petsmart/
Explore PetSmart Benefits here: https://benefits.petsmart.com/
If you don't already live in the Phoenix area here's a guide to the area: Welcome to Phoenix Guide
Job Details
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Information Technology
Full-time, position located in Phoenix, AZ. Please apply online at https://careers.petsmart.com.
#J-18808-Ljbffr