Senior Data Engineer
About The Position
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. This position designs, develops, and implements 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.
Requirements
- 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.
- Five (5) years of experience with 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.
- Five (5) years of experience 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.
- Five (5) years of experience writing complex SQL queries and PL/SQL (stored procedures, functions), and performing query optimization for large-scale data warehouses.
- Five (5) years of experience with Python scripting, and experience automating data tasks, file manipulation, or system monitoring processes.
- 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.
- Experience must have been acquired after completion of the Bachelor’s Degree program.
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.
Benefits
- Paid Volunteer Opportunities
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
