Data Engineer

OnTrac is hiring a Data Engineer!

Are you eager to join a dynamic and expanding company where you can both learn and make a meaningful impact? If you possess a strong sense of empathy, enjoy assisting others, thrive in a fast-paced environment, and excel at problem-solving, we encourage you to apply today to connect with a recruiter!

Founded in 1986, OnTrac has evolved into the leading provider of same-day and next-day delivery services in the U.S. for premier e-commerce and product-supply businesses, including five of the largest retailers in the U.S.

Location:

REMOTE: This position may be performed remotely in states where the company is authorized to employ individuals.

Compensation:

The expected starting base pay range for this position is $104,800 - $131,000, with full potential base salary range over a successful candidate’s tenure in the position of $104,800 - $157,200. Actual compensation will be determined based on experience, skills, internal equity, and other job-related factors.

This position may also be eligible for bonus, commission, or other incentive compensation in accordance with the terms of the applicable plan.

Employment Logistics:

We are seeking a Data Engineer to design, build, and maintain scalable data pipelines and analytics solutions on Google Cloud Platform (GCP). This role will integrate data from on-premises systems, cloud-hosted servers, and SaaS applications through APIs and SFTP file transfers, creating reliable datasets that support reporting, business insights, and ML / AI.

Unpacking the Benefits:

Employees are eligible for a comprehensive benefits package which may include:

• Medical, dental, and vision insurance
• Life and short- and long-term disability coverage
• 401(k) retirement savings plan with company match
• Flex vacation in states other than CA, CO, IL, MA, MT, and NE, with accruals up to 96 hours for first year of employment with tenure-based increases up to 160 hours
• Two (2) floating holidays per year
• Paid sick leave*
• Six (6) paid company holidays
• Two (2) weeks paid pregnancy disability leave, four (4) weeks paid parental bonding leave
• Additional wellness and employee assistance programs

Benefits eligibility and offerings are subject to the terms and conditions of the applicable plans and company policies.

The Must-Haves:

• At least 5 years of relevant, hands-on experience building and supporting production data pipelines on GCP.
• Demonstrated strong SQL and Python skills for data extraction, transformation, integration, and automation.
• Hands-on experience with BigQuery and Cloud Storage along with relevant GCP orchestration and data processing services.
• Experience integrating data from on-premises databases, cloud-hosted systems, REST APIs, and SFTP file transfers.
• Understanding of data modeling, ETL/ELT patterns, incremental loading, and data quality practices.
• Familiarity with access controls, service accounts, secrets management and secure connectivity across on-premises and cloud environments.
• Experience with version control, automated deployments, and production troubleshooting.
• Strong communication skills and the ability to work with technical and business stakeholders.
• Experience with workflow orchestration tools such as Apache Airflow or Cloud Composer is preferred.
• Familiarity with infrastructure as code and CI/CD practices is a plus.
• Experience with forecasting, optimization methods, and deploying or monitoring machine learning models is desirable.

Your Mission in Motion:

A summary of key responsibilities for the role is outlined below. Additional duties may be assigned as needed to support business objectives.

• Design, develop, and maintain ETL/ELT pipelines that ingest and transform data from databases, APIs, and scheduled SFTP file deliveries.
• Build and manage GCP data infrastructure that meet business requirements for performance, scalability, availability, and security.
• Integrate data across on-premises and cloud environments, supporting both scheduled batch processing and incremental data loads.
• Develop well-structured data models and curated datasets for analytics, reporting, and downstream applications.
• Implement data quality checks, pipeline monitoring, error handling, and recovery processes to ensure accurate and timely data delivery.
• Improve existing data processes by automating manual tasks, optimizing SQL and pipeline performance, and managing cloud resource costs.
• Collaborate with business, product, analytics, and leadership teams to translate requirements into practical data solutions and resolve technical issues.
• Enable analysis of key business metrics, including operational efficiency and customer acquisition.
• Develop and operationalize machine learning models for forecasting and route optimization in collaboration with business and analytics teams.
• Maintain documentation for data pipelines, architecture, source integrations, and operational procedures.

Paving your way to your success:

• You are hands-on, highly technical expert in assembling large, complex sets of data that meet business requirements.
• You Identify, design, and implement internal process improvements and redesign infrastructure for greater scalability, optimized data delivery, and automating manual processes.
• You build infrastructure required for optimal extraction, transformation and loading of data from various data sources using Google and SQL technologies.
• You build analytical tools utilizing data pipelines to, provide actionable insight into key business performance metrics, operational efficiency and customer acquisition.
• You work with stakeholders including Executive, Product, Data and Design teams supporting data infrastructure needs and assist with data-related technical issues.
• You build models for forecasting and optimizing routes.

Disclosures:

• *Washington state employees are eligible for up to 56 hours of paid sick leave annually. 
• The salary range above represents the national range for this position. The salary range may be inclusive of several career levels at OnTrac, and the actual base offered may vary depending on several factors including, but not limited to: geographic location, candidate experience and qualifications, job-related skills and competencies, market alignment, and financial considerations.  
• Compensation decisions are made based on the specific circumstances of each hire to ensure fair and competitive pay. 
• This job posting is anticipated to remain open for at least 30 days from the date of posting.

If you are excited to be part of our team and grow with our OnTrac family, we invite you to apply!

OnTrac is proud to be an Equal Opportunity Employer

Lasership, Inc. dba OnTrac Final Mile with its affiliates, including OnTrac Logistics, Inc. (collectively, "OnTrac" or the "Company") is an equal opportunity employer. We value diversity and welcome applications from individuals of all backgrounds, abilities, and experiences. We do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or age. Join us in our commitment to creating a diverse and inclusive workplace. If you are excited to be part of our team and contribute to our talent acquisition efforts, we invite you to apply.