I will build data warehouse and optimize bigquery etl pipelines on google cloud

Pakistan

I speak Urdu, English, Arabic

5 orders completed

I'm a Data Engineer with 4+ years building production data infrastructure for e-commerce and app-based businesses on Google Cloud. I cut a monthly BigQuery bill by 96% ($13K to $500) while query volum...
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

Expertise:

ETL Development

Data Warehousing

Data Integration

Industry:

Data analytics