Data Engineer

OnTrac

. Design, develop, and maintain ETL/ELT pipelines ingesting and transforming data from databases, APIs, and scheduled SFTP file deliveries .

Posted 11/5/2026full-timeRemote • United StatesMid-LevelSenior💰 $104,800 - $131,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining ETL/ELT pipelines on GCP, with strong skills in SQL and Python for data transformation and integration. Capable of collaborating with cross-functional teams to deliver actionable insights and optimize data processes.

Highest-signal resume keywords

GCP Data Infrastructure ManagementSQL and Python ProficiencyETL/ELT Pipeline DevelopmentBigQuery and Cloud Storage ExperienceData Modeling and Quality Practices

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL/ELT Pipeline DevelopmentSQLPythonData ModelingData Quality PracticesIncremental LoadingMachine Learning Model DeploymentData IntegrationAutomationPerformance Optimization

Soft Skills

Strong Communication SkillsCollaboration with Stakeholders

Tools & Technologies

GCPBigQueryCloud StorageApache AirflowCloud ComposerVersion ControlCI/CD Practices

Industry Keywords

Data PipelinesData TransformationOperational EfficiencyCustomer Acquisition MetricsInfrastructure as Code

Tech Stack

Tools & technologies

AirflowApacheBigQueryCloudETLGoogle Cloud PlatformPythonSQL

About the role

Key responsibilities & impact

Design, develop, and maintain ETL/ELT pipelines ingesting and transforming data from databases, APIs, and scheduled SFTP file deliveries
Build and manage GCP data infrastructure for performance, scalability, availability, and security
Integrate data across on-premises and cloud environments for scheduled batch processing and incremental data loads
Develop structured data models and curated datasets for analytics, reporting, and downstream applications
Implement data quality checks, pipeline monitoring, error handling, and recovery processes
Automate manual tasks, optimize SQL and pipeline performance, and manage cloud resource costs
Collaborate with business, product, analytics, leadership, executive, data, and design teams to translate requirements into data solutions and resolve technical issues
Enable analysis of operational efficiency and customer acquisition metrics
Develop and operationalize machine learning models for forecasting and route optimization
Maintain documentation for pipelines, architecture, source integrations, and operational procedures
Identify and implement internal process improvements and scalable infrastructure redesigns
Build analytical tools using data pipelines to provide actionable business insights

Requirements

What you’ll need

At least 5 years of relevant, hands-on experience building and supporting 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 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 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

Benefits

Comp & perks

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
Bonus, commission, or other incentive compensation may be available in accordance with the applicable plan