I will build a data warehouse for ecommerce and marketing data
Shopify GA4, Ads and Consent Tracking with Server Side GTM
About this Gig
Is your data spread across your shop system, GA4, Google Ads, Meta and maybe an ERP or CRM? Does every report mean exporting spreadsheets? I bring it together in one BigQuery data warehouse, modelled with dbt, so you get one reliable source of truth for orders, customers and marketing performance.
What I build:
- A clean warehouse structure on BigQuery: raw, staging and reporting layers
- Data loading with Airbyte, native connectors or Python, e.g. Shopify, WooCommerce, GA4, Google Ads, Meta Ads
- dbt models for orders, customers and marketing spend, with data tests
- Scheduled runs with Airflow or dbt Cloud
- Version control in GitLab or GitHub, documentation and role-based access
Why me: I also fix e-commerce tracking (GA4, GTM, server-side), so I understand where your data comes from and where it goes wrong, not just how to move it.
Prefer Snowflake or Azure Data Factory? Message me before ordering and I'll confirm the scope.
Warehouse Platform:
Snowflake
•
BigQuery
Project Type:
New Build
My Portfolio
FAQ
Who pays for BigQuery and the tools?
You do, directly to Google and the tool providers. The Basic plan includes a cost estimate before anything is built.
Can you work with Snowflake instead?
Yes. Message me before ordering, and I'll confirm the scope and send a custom offer.
What if I need a dashboard?
Looker Studio dashboards on top of your warehouse can be added as a custom offer after the warehouse is ready.
Do you need my passwords?
No. Please invite me to your Google Cloud project, Git repository and data sources. Never share passwords.

