Lead Data Engineer

Key Skills

API, AWS, Data pipelines, ETL/ELT technologies, Looker, PowerBI, Python Programming, R Programming, RESTful

Job Description

Position Purpose:

As a Ld. Data Engineer, at Petco, you will execute on new Data Engineering products and features in collaboration with Data Science, and Business teams.

Scope:

This role focuses on managing, supporting delivery and strategic initiatives such as data ingestion, integration, transformation, reporting and analytics. Broadly, it will work with every functional area of data engineering, data science teams & multiple Business partners.

Essential Job Functions:

The incumbent must be able to perform all the following duties and responsibilities with or without a reasonable accommodation.

• Lead the data strategy, and own the vision and roadmap of data products at Petco to enable decision making and self-service for business and analytics teams
• Solid experience in emerging and traditional data stack components such as: batch and real time data ingestion, ETL, ELT, orchestration tools, on-prem and cloud DW, Python, structured, semi and unstructured databases.
• Collaborate closely with the Data Engineering and Product team to execute on the set roadmap of data ingestion, integration and data transformation.
• Work cross-functionally with enterprise-wide stakeholders including (but not limited to) Analytics, Data Science, FP&A, Accounting, merchandising, pricing teams.
• Build a continuous monitoring process and tools to track the data management, data quality, and execute cleaning activities.
• Track the overall data transformation initiative and provide feedback or suggestions from a risk management perspective.
• Design, provide training and mentor/coach other team members.
• Work with stakeholders to ensure that data related business requirements for protecting sensitive data are clearly defined, communicated, and well understood and considered as part of operational prioritisation and planning
• Ensure the safe storage and transmission of data in line with privacy and compliance laws, data regulations, and internal company policies

This position will be in a fast-paced and entrepreneurial environment where you will be handling multiple concurrent projects while working independently and in teams. An ideal candidate will possess strong problem solving and conceptual thinking abilities in addition to communication, interpersonal and leadership skills.

Supervisory Responsibility

Position will manage a team of Data Engineers, Integration & QA engineers.

Education and Experience

• Bachelor’s or Advanced degree in Information Systems, Information Management, Engineering, or related field
• 5+ years of experience in data management, data warehousing and handling data engineering
• 3+ years of experience in Lead engineer role managing set of engineers including hiring and performance evaluations.
• 3+ years managing big data technology stack and restful APIs.
• Strong knowledge of designing data pipelines and understanding details around orchestration, integration, data transformations.
• Excellent communication skills, both verbal and written, and the ability to build trust- based relationships with business partnersTechnical knowledge in BI tools such as MicroStrategy, Looker.
• Proven record of handling, managing, collaborating and delivering data products on time and meeting quality standards.