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, research initiatives, and financial data cataloging 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 scientists 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 an extraordinary ecommerce organization.

What You’ll Do:

• Be responsible for the design, development, and maintenance of our end to end enterprise data pipelines
• Solve complex data issues to provide insights needed to accomplish our business goal.
• Create data products for analytics and data scientist 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
• Actively contribute to team discussions and initiatives, valuing different perspectives and fostering a collaborative work atmosphere.
• 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 collaborators 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 or equivalent experience in Computer Science, Engineering, Information Systems or related field.
• Current permanent U.S. work authorization is required
• 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 communicating insights and summarizing complex data to diverse audiences through visualizations.
• To be a self-starter with the ability to take initiative and drive projects forward independently.
• Familiarity with supply chain and logistics a plus
• Demonstrated experience working with and delivering to collaborators 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

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.