I will build dbt models for bigquery reporting and analytics
About this Gig
I provide DBT modeling, BigQuery optimization, and end-to-end data transformation services.
BRONZE PASS Basic Setup & Support
Connect BigQuery with DBT
Basic DBT project setup
12 DBT models (staging or transformation)
Basic data cleaning & transformations
Test basic data quality checks
One dataset or table source
Documentation for models
Delivery report
Limited revisions
Use case: Perfect for basic transformation and clean data preparation.
SILVER PASS Advanced Data Modeling & Optimization
Everything in Bronze
46 DBT models (staging + marts)
Incremental models
Advanced transformations
Data quality tests (unique, not null, relationships)
Source freshness checks
Performance optimization in BigQuery
DBT documentation site setup
Business-ready tables
Moderate revisions
Use case: Ideal for analytics-ready data warehouses and reporting.
GOLD PASS Complete Data Engineering Pipeline (End-to-End)
Everything in Silver
812+ DBT models
Full ELT pipeline in BigQuery
Advanced performance tuning
Custom m
Technology:
Excel
•
Google Analytics
•
Power BI
•
Tableau
•
BigQuery
Analysis type:
Quantitative analysis
•
Exploratory analysis
Expertise:
Web analytics
•
Statistics
Programming language:
Python
•
SQL

