I will build automated etl data pipelines with dbt and bigquery
BigQuery dbt Ecommerce Analytics Specialist
About this Gig
If your reporting still depends on manual CSV exports, repeated SQL fixes, or data scattered across different tools, I can help you build a cleaner setup.
I build automated data pipelines with BigQuery and dbt, turning raw data into reliable, analytics-ready tables.
I can help with:
Connecting data sources to BigQuery
Building staging, intermediate, and mart models in dbt
Cleaning and transforming data with SQL
Adding tests and data quality checks
Creating incremental models
Setting up scheduled workflows with Airflow when needed
Preparing clean tables for Power BI, Looker Studio, or Tableau
Fixing broken or unreliable existing pipelines
I have hands-on experience building end-to-end BigQuery and dbt projects with Python, GCS, Airflow, SQL, and automated validation, including pipelines processing tens of millions of records.
Message me with your current setup and what you need the pipeline to do before ordering larger projects.
Destination Platform:
Google BigQuery
Tools & Platforms:
Fivetran
•
Airbyte
•
Other
My Portfolio
Other Data Engineering Services I Offer
FAQ
Do you work with existing dbt projects?
Yes. I can review, debug, extend, or improve an existing dbt project, including models, tests, dependencies, and incremental logic.
Can you fix a broken BigQuery or dbt pipeline?
Yes. I can troubleshoot SQL errors, failed dbt models, duplicate data, incorrect transformations, incremental model issues, and failed data quality tests.
What data sources can you connect to BigQuery?
It depends on the project. I can work with files, databases, APIs, cloud storage, and existing BigQuery datasets. Please message me first if your source requires a specific connector or third-party tool.
Should I contact you before ordering?
Yes, especially for Standard or Premium packages. Send me your data source, current setup, expected output, and any existing code or errors so I can confirm the scope.

