BigQuery data pipeline

We are scaling our analytics stack and need a data engineer to build a reliable ETL pipeline that ingests product events into BigQuery.

Responsibilities

• Design and implement ingestion from our event stream into BigQuery
• Orchestrate jobs with Airflow (idempotent, retryable DAGs)
• Model curated tables with dbt and add data tests
• Set up monitoring, alerting and basic cost controls

Requirements

• Expert in Python and advanced SQL
• Production experience with Airflow and dbt
• Strong grasp of partitioning, clustering and warehouse cost optimization

Nice to have

• Experience with streaming (Pub/Sub, Kafka)
• Terraform for warehouse infrastructure

Engagement

Hourly, ongoing with a clear initial milestone. Please share a similar pipeline you have shipped.