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.
