Data Engineer

Job Description

Roadie, a UPS company, is a leading logistics and delivery platform that helps businesses tackle the complexities of modern retail with unmatched delivery coverage, flexibility and visibility. Reaching 97% of U.S. households across more than 30,000 zip codes — from urban hubs to rural communities — Roadie provides seamless, scalable solutions that meet a variety of delivery needs.

With a network of more than 310,000 independent drivers nationwide, Roadie offers flexible delivery solutions that make complex logistics challenges easy, including solutions for local same-day delivery, delivery of big and bulky items, ship-from-store and DC-to-door.

Roadie is hiring a Data Engineer who’s passionate about making data-driven decisions to join our growing Data Engineering team. This role will focus on building, maintaining, and scaling our data pipelines/platform and CI/CD processes to support streaming architecture. You will work closely with our Product team and other stakeholders to create useful, easy-to-consume data for reporting and analytics, as well as have the opportunity to help develop strategy for long term Data Platform architecture. Our data is dynamic across many teams, so a collaborative and communicative spirit is essential to ensuring you’re successful in this role. The ideal candidate has deep technical experience, thrives in a fast-paced environment and wants to do more than write code.

What You'll Do

• Build efficient, high quality, integrated and increasingly real-time ETL/ELT pipelines to organize, collect, standardize and integrate data that facilitate more complete, accurate and consistent data for insights and reporting
• Partner with engineering, data science, and business stakeholders to build data insights and help them to achieve their business goals
• Deliver data capabilities and new data products to accelerate investments in data and democratize data across the enterprise
• Provide production support for data tools and data needs across the business
• Research and implement cutting edge solutions to solve challenges related to ETL/ELT, data processing, and analytics
• Participate in an on-call rotation to ensure the reliability, availability, and performance of production data pipelines and systems

Roadie’s Technology Stack

• Python, Ruby on Rails, Golang
• Postgres, Redshift, Redis, Kafka
• AWS
• Docker/Kubernetes/Helm/Terraform
• Github/CircleCI/ArgoCD
• Airflow/Apache Pinot/Trino
• dbt/Superset/Redash/Lightdash

What You Bring

• Bachelor’s degree in Computer Science, Data Analytics or related field
• 5+ years of experience working with data systems, data warehouse solutions, and ETL/ELT
• 4+ years of experience building data infrastructure and platforms using streaming frameworks such as Kafka/Kinesis/Flink/Spark Structured Streaming, etc.
• 4+ years of experience with PostgreSQL, as well as MPP databases such as Redshift
• 4+ years of experience with one or more language/framework such as Python/Scala/Spark/PySpark
• 4+ years of experience with scaling production systems, ideally in a start-up environment
• 3+ years of experience using CI/CD tools to build and deploy projects
• 3+ years of experience working with DevOps tools such as Docker, Kubernetes, AKS, Helm, Terraform, etc to own end-to-end deployment of Data Engineering projects
• 3+ years of experience developing and optimizing dbt models, implementing best practices, and ensuring data quality through testing and documentation. Proficient in version control (Git) and integrating dbt with modern data warehouses (e.g., Snowflake, BigQuery, Redshift, PostgreSQL).
• 3+ years of experience working with workflow management tools such as Airflow/Luigi/Dagster
• Experience implementing data quality checks using dbt tests, custom SQL validations, and data profiling tools. Proficient in designing automated testing frameworks to ensure data accuracy, consistency, and reliability across pipelines.
• Experience with OLAP datastores such as Clickhouse, Apache Pinot, Druid
• Experience with cloud-based architectures on AWS, GCE, or similar
• Experience with various data visualization tools such as Redash/Superset/Tableau/Lightdash/Power BI
• Experience participating in on-call rotations for data or infrastructure systems

Bonus

• Experience working with Databricks/Qubole/Snowflake or similar platforms using Spark/PySpark/Scala
• Application and front end development experience
• Experience with AWS Zero-ETL
• Experience with Dask/Polars/DuckDB at production scale

Why Roadie?

• Competitive compensation packages
• 100% covered health insurance premiums for yourself
• 401k with company match
• Tuition and student loan repayment assistance (that’s right - Roadie will contribute directly to your existing student loans!)
• Flexible work schedule with unlimited PTO
• Monthly 3-day weekends
• Monthly WFH stipend
• Paid sabbatical leave- tenured team members are given time to rest, relax, and explore
• The technology you need to get the job done