Data Engineer II

Chewy Chewy · Retail · Boston, MA

Data Engineer II at Chewy, focused on building and maintaining data pipelines and foundational datasets for partner fulfillment technology. The role involves using SQL, Python, Airflow, and AWS services to transform partner data into operational insights, ensuring data quality and reliability within a rapidly scaling data ecosystem.

What you'd actually do

  1. Build and maintain batch data pipelines and workflow orchestration using Airflow, AWS services, SQL, and Python.
  2. Develop and enhance datasets supporting partner fulfillment operations, inventory visibility, shipments, returns, and operational reporting.
  3. Work within established data architecture and orchestration patterns to extend ingestion pipelines and operational workflows.
  4. Monitor, solve, and optimize Airflow DAGs and data pipelines to improve reliability, observability, and operational performance.
  5. Implement data quality checks, validation logic, and alerting to ensure trustworthy downstream datasets.

Skills

Required

  • SQL
  • Python
  • Airflow
  • AWS services
  • ETL/ELT pipelines
  • Data modeling
  • Pipeline monitoring
  • Operational fixing
  • Problem-solving
  • Communication
  • Collaboration

Nice to have

  • e-commerce
  • logistics
  • supply chain
  • fulfillment
  • operational data environments
  • Spark
  • Glue
  • EMR
  • Great Expectations
  • Datadog

What the JD emphasized

  • strong SQL skills
  • Working knowledge of Python
  • Hands-on experience with workflow orchestration tools such as Airflow
  • Experience building or supporting production ETL/ELT pipelines
  • Familiarity with AWS data technologies
  • Understanding of data modeling fundamentals, pipeline monitoring, and operational fixing
  • Strong problem-solving skills
  • willingness to learn in a fast-moving operational environment
  • Strong communication and collaboration skills