Staff Data Engineer at Route

We are Route

Buying stuff online can get messy once you hit that “order” button. Managing dozens carrier tracking links, dealing with lost or damaged packages, and resolving issues with customer support can feel like a wild goose chase. That’s why we created the Route  — to make the post-purchase experience for consumers like you, and the brands you love, as seamless as possible. 

Route is on a mission to connect the world’s commerce. Through our network of millions of Route App users and thousands of merchants, we’re making it easier than ever for consumers to track, insure, and discover their favorite products in one place — which connects the world’s best direct-to-consumer brands to happy, repeat customers.

Since Route launched in 2018, we’ve been on a journey to build innovative products that empower our customers, all while fostering a people-first, values-driven company culture. We’re looking for talented people across the ecommerce space to join us on the next steps of this adventure.

Don’t just take our word for it! Discover what life at Route has to offer.

The team

The Route Engineering team develops next-generation technologies that change how millions of consumers see, share, and discover the world's most innovative brands and products. Route Engineers have backgrounds in distributed systems design and development, large-scale data storage and processing systems, UI design, mobile, and much more — but what unites this talented team is a passion for the Route mission to connect the world's commerce through our suite of transformational products.

The Data Engineering team (DAENGR). The Data Engineering team is responsible for collecting, processing, gathering, and normalizing data for the entire organization. We rely on great business relationships with multiple departments, excellent problem solving skills in the face of ambiguous processes, and aligning the business with the data they are able to expose.

The opportunity

Are you ready to make a significant impact on the development of large-scale data infrastructures and the business as a whole? We're seeking a dynamic candidate who thrives in a fast-paced environment and is passionate about data engineering and architecture. In this role, you'll work across various levels of our organization to create and manage data pathways, develop self-service mechanisms, and act as the platform owner for all our data systems.

Your expertise in data ingestion and engineering best practices will be crucial as you leverage multiple data systems such as Snowflake, Databricks, RDS, S3, and more. If you're a data wizard with a proven track record in managing complex data environments and are excited about driving innovation and efficiency, we want you on our team!

What you’ll do

• Build new data pipelines from multiple systems such as Salesforce, Zendesk, Stripe, internal production systems, S3, etc.
• Coordinate with engineering teams to ensure a complete, end-to-end lifecycle of data for existing and new products.
• Design and implement database migrations and tooling from Snowflake to Databricks.
• Establish data integration patterns for ingress and egress.
• Support analysts with their data requests.
• Expand the foundation for a company-wide data retention policy.
• Champion and help develop data democratization at scale.
• Meet with multiple business units to determine and prioritize their data needs.

What we’re looking for

• 5+ years of relevant experience in data engineering
• Experience in data ingress/egress from multiple systems (partner endpoints/APIs as well as internal endpoints)
• Experience with Spark, Python, SQL, AWS (S3, RDS, Airflow, etc.)
• Experience with building out a DBT infrastructure, Snowflake and Databricks 
• Experience with Terraform is a plus

Equal opportunity for all

Route is an Equal Opportunity Employer. We embrace diversity and equal opportunity in a serious way. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.

Total Rewards

We know our team works best when everyone feels happy, healthy, and supported. We offer to pay 100% of your health insurance premiums on a $0 deductible plan for you and your family, remote or hybrid work arrangements, unlimited PTO, 401k matching, formalized growth opportunities, learning & development, DEI programs & events, and so much more.

Pay Transparency

Salary for this role: $160,000 - $172,000 

The cash compensation above includes base salary, and is not reflective of potential commission for employees in eligible roles, or annual bonus targets under Route’s bonus plan for eligible roles. In addition to cash compensation, all Route employees are eligible to participate in Routes equity incentive plan to receive stock options per the terms of the agreement. Some roles may also be eligible for overtime pay. Individual compensation packages are based on a few different factors unique to each candidate, including their career level, skills, experience, specific geographic location qualifications and other job-related reasons.