Staff Data Engineer

Route; San Francisco (CA); Remote; USD 187,000 - 199,000; Full time

Job summary

Join a forward-thinking company as a Staff Data Engineer, where you'll play a crucial role in enhancing data infrastructure. You'll maintain and optimize data pipelines, ensuring seamless data flow, while collaborating with cross-functional teams to deliver robust data solutions. This innovative firm values a people-first culture and offers a supportive environment where your contributions directly impact the post-purchase experience of millions of consumers. If you're passionate about data engineering and eager to drive change in the e-commerce landscape, this opportunity is perfect for you.

Benefits

100% health insurance premiums covered

Unlimited PTO

401k matching

Learning & development opportunities

DEI programs & events

Qualifications

• 5+ years of experience in data engineering or related field.
• Expertise in Snowflake, Databricks, and Spark for data processing.

Responsibilities

• Maintain and optimize data ingestion pipelines for reliability.
• Design and develop new data integration solutions.

Skills

Data Engineering

Python

Problem-solving

Communication

Real-time data processing

Education

Bachelor's Degree in a related field

Tools

Snowflake

Databricks

DBT

Spark

Snaplogic

Airflow

Terraform

AWS

Job description

Lehi, Utah, United States; New York, New York, United States; Remote; San Francisco, California, United States; Santa Monica, California, United States

Buying stuff online can get messy once you hit that “order” button. Managing dozens of 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.

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 opportunity

We are looking for a Staff Data Engineer to play a pivotal role in maintaining and expanding our data infrastructure. This role is highly autonomous and requires a seasoned engineer with strong technical skills who can hit the ground running. You will be responsible for ensuring the continuous and reliable ingestion of data while designing and implementing new data integrations to support our growing business needs.

What you’ll do

• Own and maintain the reliability of existing data ingestion pipelines, ensuring uninterrupted data flow.
• Design, develop, and optimize new data ingestion and integration pipelines.
• Work cross-functionally with data analysts, product managers, back-end and front-end engineering teams, and business stakeholders to deliver robust data solutions.
• Leverage Snowflake, Databricks, DBT, and Spark to build scalable and high-performance data processing solutions.
• Implement and maintain Snaplogic, Airflow, and Terraform for ETL orchestration, workflow automation, and infrastructure as code.
• Ensure high availability, scalability, and security of data infrastructure using the AWS suite.
• Troubleshoot and optimize performance across the data pipeline stack.
• Stay ahead of industry trends and continuously improve data engineering best practices.

What we’re looking for

• 5+ years of experience in data engineering or a similar field.
• Expertise in Snowflake, DBT, Databricks, and Spark for data processing and analytics.
• Strong programming skills in Python for data pipeline development and automation.
• Experience with Snaplogic, Airflow, or similar ETL orchestration tools.
• Proficiency in cloud infrastructure and data services within the AWS ecosystem.
• Hands-on experience with Terraform for infrastructure as code.
• Strong problem-solving skills with the ability to work independently in a fast-paced environment.
• Excellent communication skills and ability to collaborate across teams.
• Partner with Data Analysts to enhance analytics and provide guidance on queries that impact multiple departments.
• Familiarity with real-time data processing architectures.
• Knowledge of data governance, security, and compliance best practices.
• Experience with AI agents to interact with a database.
• Experience in the e-commerce or post-purchase space 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

UT: $176,000 – $186,000

LA: $179,520 – $189,720

SF: $187,440 – $198,090

NYC: $183,920 – $194,370

Salary for this role: List base salary (and variable if applicable) only.

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.