Senior Data Engineer

Senior Data EngineerPetSmart 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. Specific duties include: 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 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.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 educationPaid Volunteer Opportunities to spend time doing good for causes close to heartPrint Center and Business Services, Dry Cleaning, Mother's Rooms, Sustainable Infrastructure & morePetSmart 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.