I will design and optimize dbt data models for your analytics data warehouse

United States

I speak English, Chinese

Data Engineer

Analytics engineer/Data Engineer with a PhD degree. Expert in ETL/ELT pipelines, data build tool (dbt) , data modeling, BigQuery, Amazon redshift , snowflake, data warehousing , data visualization, Da...
About this Gig

I will build an automated ETL data pipeline and analytics dashboard for your business.


Many companies struggle with fragmented data and manual reporting.

I help transform raw data into reliable analytics pipelines and dashboards.


What I can build:


Automated data ingestion from data lake, APIs or databases

Cloud data warehouse setup (BigQuery)

Data transformation using dbt

Scheduled pipelines with Airflow

Interactive dashboards using Looker Studio

Data quality checks and documentation


Tech Stack:

Python | SQL | BigQuery | dbt | Airflow | Looker Studio | Cloud Storage


Example Use Cases:


- Financial market analytics

- Business KPI dashboards

- Ecommerce sales analysis

- Healthcare analytics


You will receive:


Production-ready ETL data pipeline

Clean dbt data models and analytic ready data warehouse

Business analytics dashboard


If you have a custom data analytics project, feel free to contact me before ordering.

Warehouse Platform:

Snowflake

BigQuery

Redshift

Project Type:

New Build

My Portfolio