I will build data warehouse and optimize bigquery etl pipelines on google cloud
About this Gig
I'll build your Google Cloud data pipelines and cut your BigQuery bill.
I'm a data engineer who has run the full BigQuery stack in production currently a Lead/Senior Data Engineer, where I cut monthly BigQuery spend by 96% ($13K to $500) while query volume tripled, by redesigning schemas and optimizing queries.
What I do:
- Build ETL pipelines into BigQuery from APIs, GA4/Firebase exports, GCS, or databases
- Unify GA4, Firebase, Adjust, RevenueCat, Google Ads into one BigQuery model
- Cut BigQuery costs via schema redesign, partitioning/clustering, query optimization
- Set up scheduled orchestration (Airflow, Cloud Composer, Pub/Sub)
- Build transformation layers with Dataform
- Automate reporting workflows with Python and APIs
- Setup Billing Kill Switches per project
- Create and optimize data warehouse and data lakes
- Build dashboards directly from the warehouse
How I work: you share read access to GCP I audit pipeline/query costs I build or refactor & validate you get documentation and a handover call.
Tools: GCP, BigQuery, Cloud Storage, Pub/Sub, Airflow, Dataform, GA4, Firebase, SQL, Python.
- Message me first if your setup is non-standard.
Langugae:
English
Technical expertise:
Google BigQuery
Industry:
Data analytics
FAQ
Will you need billing/admin access to my GCP project?
No, I only need the specific IAM roles for the work in scope (e.g. BigQuery Data Editor, Job User). I'll tell you exactly what to grant
Can you guarantee a specific % cost reduction?
Every environment is different, so I won't promise a number before auditing your actual query patterns and schema — but cost reduction is usually the first thing I look for
Do you work with tools outside the Google stack (AWS, Snowflake, dbt)?
My deepest expertise is GCP/BigQuery, but I'm comfortable with general ETL/orchestration patterns, message me if your stack is mixed.
Can you set this up to run without me touching it again?
Yes, the Standard and Premium packages include scheduled orchestration so pipelines run automatically.

