Senior Data Engineer
Role details
Job location
Tech stack
Job description
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 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, 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., 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
Requirements
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