I will design and build your snowflake or bigquery data warehouse
Data Engineer ,ETL Pipelines, Spark and Cloud Data Warehouse Expert
About this Gig
Is your data scattered across spreadsheets, databases, and SaaS tools with no single source of truth? I will design and build a modern cloud data warehouse on Snowflake or BigQuery that gives your team clean, reliable, query-ready data so analysts can answer questions in seconds, not days.
What I deliver:
- Snowflake or BigQuery data warehouse setup and configuration
- Data modeling using dbt (staging, intermediate, and mart layers)
- Star schema or OBT design based on your reporting requirements
- Data ingestion pipelines from your source systems
- Role-based access control and security configuration
- dbt tests for data quality and freshness checks
- Documentation of all models using dbt docs
- BI tool connectivity (Looker, Tableau, Power BI, Metabase)
My stack: Snowflake, BigQuery, Amazon Redshift, dbt Core / dbt Cloud, Fivetran, Airbyte, Python, SQL, Apache Airflow.
Who this is for:
- Startups setting up their first cloud data warehouse
- Companies moving from a legacy on-prem warehouse (Oracle, Teradata) to the cloud
- Teams who have raw data in S3 or GCS and need a structured warehouse on top
- Analytics teams drowning complex SQL queries who need a clean semantic layer
Warehouse Platform:
Snowflake
•
BigQuery
•
Redshift
Project Type:
New Build
My Portfolio
Other Data Engineering Services I Offer
FAQ
Snowflake or BigQuery — which should I use?
It depends on your cloud provider and team. Snowflake is cloud-agnostic and great for mixed-cloud teams. BigQuery is best if you are already on GCP. I will recommend the right one for your situation during our chat.
Do I need dbt?
Not always, we can use other stack as well
Will this connect to my BI tool?
Yes. I configure connectivity to Looker, Tableau, Power BI, Redash, or Metabase as part of the Standard and Premium packages.
Can you migrate our existing warehouse?
Yes. I have migrated warehouses from MySQL to Snowflake, Redshift to BigQuery, and on-prem SQL Server to dbt Cloud. Include details in your message.
What access do you need?
For cloud platforms I need a service account or IAM role with the necessary permissions. I never ask for root credentials
