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