Senior Data Engineer – Google Cloud

Ontrac Solutions

United States

Remote

USD 140,000 - 180,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Fully remote work
Competitive compensation

Job summary

Ontrac Solutions is seeking a Senior Data Engineer with deep Google Cloud experience to design and build production data pipelines on GCP for enterprise clients. The role focuses on migrating legacy estates to BigQuery and collaborating directly with customer engineering and analytics teams from discovery to hand-off.

The ideal candidate has multiple years delivering GCP data platforms for several customers, including data modeling, ELT, and orchestration with Airflow, Dataflow, or Dataproc.

Qualifications

  • 6+ years in data engineering with 3+ years on GCP production workloads.
  • Strong hands-on BigQuery data modeling, partitioning, clustering, and ELT in SQL.
  • Built and operated batch and streaming pipelines with Dataflow and/or Dataproc; Pub/Sub as source.
  • Orchestrated production workflows with Cloud Composer (Airflow) including retries and alerts.
  • Proficient in Python and advanced SQL.
  • Provisioned GCP data infra with Terraform and deployed via Git-based CI/CD.
  • Delivered migration into BigQuery from on-prem/legacy platforms with validation and cut-over.
  • Client-facing sessions: requirements gathering, designs, and handoffs.

Responsibilities

  • Assess the client’s data estate and design a target-state GCP data architecture.
  • Build ingestion, transformation, and orchestration pipelines into BigQuery via Terraform/CI-CD.
  • Migrate historical data with reconciliation ensuring parity.
  • Tune BigQuery models/queries for cost and performance and set up monitoring.
  • Provide runbooks and knowledge-transfer to enable client ownership.

Skills

Data engineering
GCP (BigQuery)
Python
SQL
Dataflow / Dataproc
Cloud Composer (Airflow)
Terraform
Pub/Sub
CI/CD
Client-facing

Tools

Dataflow
Dataproc
Pub/Sub
Cloud Composer
Terraform
Looker/LookML

Job description

ABOUT ONTRAC SOLUTIONS

Ontrac Solutions is a leading technology consulting firm, specializing in cutting-edge solutions that drive business transformation. We partner with organizations to modernize their infrastructure, streamline processes, and deliver tangible results. By creating value beyond the hype, we help businesses modernize technology and build new strategies that fuel growth. Our team is committed to innovation, collaboration, and excellence, empowering our clients to succeed in an evolving digital landscape.

OVERVIEW

Ontrac is seeking a Senior Data Engineer with deep, hands-on Google Cloud experience to support our client in delivering Google Cloud data platform engagements for enterprise customers. This is a consulting-delivery role: you will design and build production data pipelines on GCP, migrate legacy warehouses and Hadoop estates into BigQuery, and work directly with customer engineering and analytics teams from discovery through hand-off. The ideal candidate has spent several years shipping GCP data platforms for multiple customers, not maintaining a single internal stack.

ENGAGEMENT
  • Duration: 6 months, with possible extension
  • Location: United States or Canada, fully remote.
  • We are not able to provide sponsorship for this role.
REQUIRED QUALIFICATIONS
  • 6+ years in data engineering, including 3+ years delivering production workloads on Google Cloud Platform
  • Deep hands-on BigQuery experience: data modeling, partitioning and clustering, cost and performance tuning, and ELT in SQL
  • Built and operated batch and streaming pipelines with Dataflow (Apache Beam) and/or Dataproc (Spark / PySpark), with Pub/Sub as a streaming source
  • Orchestrated production workflows with Cloud Composer (Apache Airflow), including dependency management, retries, and alerting
  • Strong Python and advanced SQL
  • Provisioned GCP data infrastructure with Terraform and deployed through Git-based CI/CD
  • Delivered at least one migration into BigQuery from an on-prem or legacy platform (Hadoop/Hive, Teradata, Netezza, Oracle, DB2, SQL Server, or another cloud warehouse), including data validation and cut-over
  • Client-facing experience: running requirements sessions, presenting designs, and handing off documented solutions to customer teams
USEFUL QUALIFICATIONS
  • Google Cloud Professional Data Engineer certification (or a current Associate Cloud Engineer / Professional Cloud Architect)
  • Databricks certification or production Databricks-on-GCP experience
  • Looker / LookML modeling, or Looker Studio dashboard delivery
  • Serverless integration work on Cloud Run or Cloud Functions (API ingestion, event handlers)
  • Data governance on GCP: Dataplex, Data Catalog, IAM and column-level security, DLP
  • Feeding GenAI use cases from the warehouse: BigQuery ML, Vertex AI, embeddings or RAG data preparation
  • BigQuery Migration Service / SQL translation, Datastream, or Database Migration Service used on a real migration
  • Prior experience at a Google Cloud partner or in Google Cloud Professional Services
SCOPE AND DELIVERY EXPECTATIONS
  • Assess the customer’s current data estate and produce a target-state GCP data architecture and migration plan
  • Build ingestion, transformation, and orchestration pipelines (batch and streaming) into BigQuery, deployed entirely through Terraform and CI/CD
  • Migrate historical data and workloads with documented reconciliation proving row- and aggregate-level parity
  • Tune BigQuery models and queries for cost and performance, and leave the customer with monitoring and alerting on pipeline health
  • Deliver runbooks, architecture documentation, and knowledge-transfer sessions so the customer team can own the platform after hand-off
WHAT WE OFFER
  • Competitive Compensation: Compensation will be commensurate with experience.
  • Remote Work: Fully remote engagement from anywhere in the United States or Canada.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer – Google Cloud
Senior Data Engineer – Google Cloud

Ontrac Solutions • Chicago (IL)

Remote
USD 120,000 - 180,000
Senior Data Engineer – Google Cloud
Senior Data Engineer – Google Cloud

Ontrac Solutions • California

Hybrid
USD 140,000 - 180,000
Competitive compensation
Fully remote
Senior Data Engineer – Google Cloud (Fully Remote)
Senior Data Engineer – Google Cloud (Fully Remote)

Ontrac Solutions • United States

Remote
USD 120,000 - 180,000
Senior Data Engineer - Google Cloud (Remote)
Senior Data Engineer - Google Cloud (Remote)

Ontrac Solutions • United States

Remote
USD 120,000 - 180,000
Senior Data Engineer — Remote GCP Data Platform Expert
Senior Data Engineer — Remote GCP Data Platform Expert

Ontrac Solutions • California

Hybrid
USD 140,000 - 180,000
Competitive compensation
Fully remote
Senior Data Engineer - GCP & BigQuery Pipelines
Senior Data Engineer - GCP & BigQuery Pipelines

Ontrac Solutions • Chicago (IL)

Remote
USD 120,000 - 180,000
Senior Data Engineer: GCP & BigQuery Pipelines (Remote)
Senior Data Engineer: GCP & BigQuery Pipelines (Remote)

Ontrac Solutions • United States

Remote
USD 140,000 - 180,000
Fully remote work
Competitive compensation
GCP Data Engineer
GCP Data Engineer

Arkhya Tech. Inc. • Concord (CA)

On-site
USD 140,000 - 190,000
Customer Engineer, Data & Analytics
Customer Engineer, Data & Analytics

Premier Cloud • Austin (TX)

Hybrid
USD 120,000 - 180,000
Flexible remote work options
Premium equipment
Senior Data Engineer 3468
Senior Data Engineer 3468

Ready • United States

Remote
USD 130,000 - 170,000