Senior Data Engineer – Google Cloud

Ontrac Solutions•Chicago, IL
•Remote

About The Position

Ontrac Solutions is seeking a Senior Data Engineer with deep, hands-on Google Cloud experience to support a client delivering Google Cloud data platform engagements for enterprise customers. This consulting-delivery role involves designing and building production data pipelines on GCP, migrating legacy warehouses and Hadoop estates into BigQuery, and working directly with customer engineering and analytics teams from discovery through hand-off. The ideal candidate has shipped GCP data platforms for multiple customers rather than maintained a single internal stack. The engagement is for six months, with a possible extension, and is fully remote from the United States or Canada. Sponsorship is not available. The contractor is expected to assess the customer's current data estate; produce a target-state GCP architecture and migration plan; build batch and streaming ingestion, transformation, and orchestration pipelines into BigQuery using Terraform and CI/CD; migrate historical data and workloads with documented reconciliation; tune BigQuery for cost and performance; establish pipeline monitoring and alerting; and provide runbooks, architecture documentation, and knowledge-transfer sessions for customer hand-off.

Requirements

  • At least 6 years of data engineering experience, including at least 3 years delivering production workloads on Google Cloud Platform.
  • Deep hands-on BigQuery experience, including data modeling, partitioning and clustering, cost and performance tuning, and ELT in SQL.
  • Experience building and operating batch and streaming pipelines with Dataflow (Apache Beam) and/or Dataproc (Spark/PySpark), with Pub/Sub as a streaming source.
  • Experience orchestrating production workflows with Cloud Composer (Apache Airflow), including dependency management, retries, and alerting.
  • Strong Python and advanced SQL skills.
  • Experience provisioning GCP data infrastructure with Terraform and deploying through Git-based CI/CD.
  • At least one migration into BigQuery from an on-premises or legacy platform, including data validation and cut-over.
  • Client-facing experience running requirements sessions, presenting designs, and handing off documented solutions to customer teams.

Nice To Haves

  • Google Cloud Professional Data Engineer certification, or a current Associate Cloud Engineer or Professional Cloud Architect certification.
  • Databricks certification or production Databricks-on-GCP experience.
  • Looker/LookML modeling or Looker Studio dashboard delivery experience.
  • Serverless integration experience with Cloud Run or Cloud Functions, such as API ingestion or event handlers.
  • GCP data governance experience with Dataplex, Data Catalog, IAM and column-level security, or DLP.
  • Experience feeding GenAI use cases from a warehouse, including BigQuery ML, Vertex AI, embeddings, or RAG data preparation.
  • Hands-on use of BigQuery Migration Service or SQL translation, Datastream, or Database Migration Service on a real migration.
  • Prior experience at a Google Cloud partner or in Google Cloud Professional Services.

Responsibilities

  • Assess the customer's current data estate and produce a target-state GCP data architecture and migration plan.
  • Build batch and streaming ingestion, transformation, and orchestration pipelines into BigQuery, deployed through Terraform and CI/CD.
  • Migrate historical data and workloads, documenting reconciliation to demonstrate row- and aggregate-level parity.
  • Tune BigQuery models and queries for cost and performance, and provide monitoring and alerting on pipeline health.
  • Deliver runbooks and architecture documentation, and conduct knowledge-transfer sessions so the customer team can own the platform after hand-off.
  • Run requirements sessions, present designs, and hand off documented solutions to customer teams.

Benefits

  • Competitive compensation commensurate with experience.
  • Fully remote engagement from anywhere in the United States or Canada.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service