Route

Route

Route is an all-in-one post-purchase platform revolutionizing ecommerce with visual tracking, package protection, and carbon-neutral shipping.

Air Freight & Logistics
251-1K
Founded 2018
$12M raised

Description

  • Build and maintain ELT pipelines that ingest data from source systems.
  • Co-own the mapping and migration of source data into the new 3NF enterprise data warehouse while preserving data integrity.
  • Develop automated unit tests, data tests, observability processes, and monitoring dashboards for pipeline health and data quality.
  • Build data and AI-powered tools that improve the productivity of the data engineering team and expand self-service access to data.
  • Automate deployment of shared staging and production infrastructure for new pipelines and maintain dbt and CI template dependencies.
  • Support the migration from Snowflake to Databricks, including reporting services and ingest/egress jobs.
  • Coordinate with engineering, analytics, product, and business teams to define, prioritize, and deliver data requirements.
  • Champion data democratization and help establish company-wide data retention and self-service data access foundations.
  • Monitor and support the uptime, security, and consistency of Route’s data lifecycle.

Requirements

  • 5+ years of formal, professional data engineering experience.
  • 4+ years of SQL experience, including complex transformations, window functions, and query optimization.
  • 3+ years of Python experience in data pipeline development, scripting, testing, and package management with Poetry.
  • 2+ years of experience with AWS data services such as S3, RDS, DMS, and DynamoDB.
  • 1+ year of experience using Databricks as a primary development platform.
  • Experience using Terraform and GoLang.
  • Preferred experience with PagerDuty, Grafana, and Tableau.
  • Understanding of third normal form (3NF) data modeling and when to apply it.
  • Knowledge and application of data theory.
  • Working knowledge of data security practices and least-privilege access standards.
  • Experience with data access controls in cloud environments, including IAM roles and catalog permissions.

Benefits

  • Route pays 95% to 100% of health insurance premiums for employees and their families.
  • Remote or hybrid work arrangements are available.
  • Unlimited PTO is offered.
  • 401(k) matching is included.
  • Formal growth opportunities plus learning and development support are provided.
  • DEI programs and events are part of the employee offering.
  • Employees are eligible to participate in the equity incentive plan and receive stock options.
  • The role has a salary range of $138,000 to $146,000, with potential bonus eligibility for some roles.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Head of Data Engineering & Platform, Real-World Data (RWD)

Natera 1K-5K Pharmaceuticals

Natera is hiring a Head of Data Engineering & Platform for Real-World Data to lead the strategy, development, and delivery of a healthcare data platform that supports clinical, research, analytics, and business needs.

Agile AWS CI/CD Machine Learning PostgreSQL Python REST API Snowflake SQL
1 hour, 36 minutes ago

Senior Data Engineer

Knak 51-250 Internet Software & Services

Knak is hiring its first Data Engineer to architect the governed Snowflake data layer that powers company-wide self-serve analytics, AI agents, and department-specific data access.

AWS Databricks dbt GCP Git LinkedIn Ads Looker Mixpanel Mode MySQL Pandas Python Salesforce Snowflake SQL Tableau
2 hours, 17 minutes ago

SAP BW Lead

Lingaro 5K-10K IT Services

SAP BW Lead for Poland’s CC Data Engineering & Management team at SAP, responsible for leading SAP BW-related data engineering work in a full-time remote role.

3 hours, 30 minutes ago

Senior Data Engineer

Egen.ai IT Services

Egen is seeking a Senior Data Engineer to build scalable, client-facing data platforms and API integrations on Google Cloud, with a focus on healthcare data solutions.

Apache Airflow AWS dbt GCP JSON Python REST API Salesforce SQL
4 hours, 10 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers