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…