Staff Data Engineer

Ontrac Solutions Inc · posted 6 days ago

Open to candidates in Canada and United States

Contract · Staff

Sign up and we score this job against your resume. You never pay to apply.

RemoteHunt reads employers' own pages. Free to browse. How we check

What this job asks for

Extracted by RemoteHunt

Must have

  • •6+ years data engineering
  • •3+ years GCP production workloads
  • •Deep BigQuery experience
  • •Batch/streaming pipelines (Dataflow/Dataproc)
  • •Orchestration (Cloud Composer/Airflow)
  • •Strong Python and advanced SQL
  • •GCP infrastructure with Terraform/CI/CD

Nice to have

  • •GCP Professional Data Engineer cert
  • •Databricks experience
  • •Looker/LookML
  • •Serverless integration
  • •Data governance on GCP

Tools and technologies

Google Cloud Platform, BigQuery, Dataflow, Apache Beam, Dataproc, Spark, PySpark, Pub/Sub, Cloud Composer, Apache Airflow, Python, SQL, Terraform, CI/CD, Hadoop

Worth checking before you apply

  • not able to provide sponsorship
Read the full posting

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

The following covers the scope of work we anticipate the contractor supporting throughout the engagement.

  • 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.
Send this job to a friend:TelegramWhatsApp

More remote Data Engineer jobs

See all
$150k–$190k

San Francisco, CA, Washington, D.C., New York City, N.Y., Detroit, MI, Phoenix, AZ, Miami, FL, Denver, CO., Remote (USA) · 30d ago

More remote jobs open to candidates in

Get new jobs like this by email

Once a week. Remote data engineer jobs that can hire you in your country.

Hiring in: your countryChange

Weekly, only when there are at least 3 new jobs. No account needed. Unsubscribe in one click. You never pay to apply. Privacy

See how well this job fits your resume

Free, no card.

See my match for each job — free