Data Engineer

OnTrac; Chantilly (VA); Remote; USD 105,000 - 157,000; Full time

Benefits offered by this job

Medical, dental and vision insurance

Life and disability coverage

401(k) with company match

Flex vacation with accrued hours

Floating holidays

Sick leave

Paid company holidays

Pregnancy/Parental leave

Job summary

OnTrac is hiring a Data Engineer to design, build, and maintain scalable data pipelines and analytics on Google Cloud Platform.

You will integrate on-premises systems, cloud servers, and SaaS data via APIs and SFTP to create reliable datasets for reporting, insights, and ML/AI use cases.

Qualifications

• At least 5 years hands-on experience building production data pipelines on GCP.
• Strong SQL and Python skills for data extraction, transformation, integration and automation.
• Hands-on experience with BigQuery and Cloud Storage and related GCP services.
• Experience integrating data from on-premises, cloud and SaaS via APIs and SFTP.
• Knowledge of data modeling, ETL/ELT, incremental loading and data quality practices.
• Familiarity with access controls, service accounts, secrets management and secure connectivity.
• Experience with version control, automated deployments and production troubleshooting.
• Excellent communication with technical and business stakeholders.
• Experience with Airflow or Cloud Composer preferred; IaC and CI/CD a plus.
• Experience with forecasting, optimization or ML model deployment is desirable.

Responsibilities

• Design, develop and maintain ETL/ELT pipelines ingesting data from databases, APIs and scheduled SFTP transfers.
• Build and manage GCP data infrastructure meeting performance, scalability and security requirements.
• Integrate data across on-premises and cloud environments supporting batch and incremental loads.
• Develop well-structured data models and curated analytics datasets.
• Implement data quality checks, pipeline monitoring and robust error handling.
• Automate repetitive tasks, optimize SQL/pipeline performance and manage cloud costs.
• Collaborate with stakeholders to translate requirements into practical data solutions.
• Enable analysis of key business metrics and support reporting and ML workflows.
• Develop and operationalize forecasting and route optimization models with business teams.
• Maintain comprehensive documentation for pipelines, architecture and operations.

Skills

GCP pipelines

SQL

Python

BigQuery

Cloud Storage

GCP orchestration

REST APIs

SFTP

data modeling

ETL/ELT

data quality

CI/CD

Airflow/Composer

IaC

ML forecasting

Job description

OnTrac is hiring a Data Engineer!

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.

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 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.