Data Engineer II

Our Opportunity:

Chewy is seeking a Data Engineer II to join the growing Transportation Systems team. You will be a part of a team responsible for strategic system design and research initiatives centered around our transportation planning and execution. This includes building enterprise data pipelines that drive analytic solutions and creating data products for analytics and data scientist team members to improve their productivity. The Transportation team operates in a fast-paced environment where every day brings new challenges and opportunities. You will be responsible for building and implementing data products and technologies which will handle the growing business needs and play a key role in redefining what it means to be a world-class ecommerce organization.

What You’ll Do:

• Own the design, development, and maintenance of our end to end enterprise data pipelines
• Tackle complex data issues to provide insights needed to accomplish our business goals
• Create data products for analytics and data scientist team members to improve their productivity
• Assist in creating Proof of Concepts and advise, consult, mentor and coach other data and analytic professionals on data standards and practices
• Lead the evaluation, implementation and deployment of emerging tools and process for analytic data engineering to improve our productivity as a team
• Develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes
• Code, test, and document new or modified data systems to create robust and scalable applications for data analytics
• Partner with Business Analysts and Solutions Architects to develop technical architectures for strategic enterprise projects and initiatives
• Data cataloging & documentation of data sources
• Regularly meet with business partners and analytics teams to understand and solve data needs, short-term and medium-term
• Build trust with internal stakeholders to encourage data-driven decision-making
• Partner with data engineering to grow the value of our data products by onboarding new data from our backend and 3rd party systems

What You’ll Need:

• Bachelor of Science or Master's degree in Computer Science, Engineering, Information Systems or related field.
• 5+ years of experience in Data Engineering or Business Intelligence roles working with ETL, Data Modeling, and Data Architecture, developing modem data pipelines and applications for analytics (e.g., BI, reporting, dashboards) and advanced analytics (e.g., machine learning, deep learning) use cases.
• Expertise designing and implementing enterprise data pipelines using modern data engineering approach and tools: Spark, PySpark, Scala, Docker, Databricks, Glue, cloud-native EDW (Snowflake, Redshift), Kafka/Confluence, Presto/ Dremio /Athena
• Proficiency in AWS ecosystem
• Proficiency in Java, Python, SQL
• Mastery of data warehouse methodologies and techniques from transactional databases to dimensional data modeling, to wide denormalized data marts.
• Experience with writing and reviewing version-controlled code (GitHub).
• Experience with building statistical and predictive models from scratch.
• Experience effectively presenting insights and summarizing complex data to diverse audiences through visualizations.
• Familiarity with supply chain and logistics a plus
• Demonstrated experience working with and delivering to cross-functional stakeholders from multiple parts of the company (Finance, Engineering, Human Resources, Supply Chain etc.)
• Excellent written and oral communication skills
• This role requires 5% domestic travel
• Current permanent U.S. work authorization is required

Compensation & Benefits:

Our salary range for a Data Engineer II position is $115,500.00 - $183,500.00. The specific salary offered to a candidate may be influenced by a variety of factors including but not limited to the candidate’s relevant experience, education, and work location. In addition, this position is eligible for 401k and a new hire and annual equity grant.

We offer different types of insurance, such as medical/Rx, vision, dental, life, disability, hospital indemnity, critical illness, and accident. We offer parental leave, family services benefits, backup dependent care, flexible spending accounts, telemedicine, pet adoption reimbursement, employee assistance program, and many discounts including 10% off pet insurance and 20% off at Chewy.com.

Non-exempt hourly team members accrue paid time off (PTO) while salaried-exempt team members have unlimited PTO, subject to manager approval. Non-exempt hourly team members in Fulfillment Centers and Customer Service are also eligible for additional unplanned unpaid time off (UTO). Team members will receive six paid holidays per year. Team members may be eligible for paid sick and family leave in compliance with applicable state and local regulations.