Master data engineering and AI like a big tech engineer

OpenAI

Amazon

Netflix

Tesla

Salesforce

Robinhood

Microsoft

Real Time Formula 1 Analytics

Big Bag Data

Chess.com Analytics

Trading Strategy for Crypto Currency - Analytics Engineering Capstone Submission

BetFlow - Real Time Sports Betting App

Showcase of student projects

Capstone Projects

Book a discovery call with Zach

Discovery call

Our students have gone on to work at companies like Meta, Airbnb and Amazon. As well as achieve 100% raises!

Fast Track Your Career

Immediate free cloud access to Databricks, AWS, Snowflake, Astronomer, and more!

Free Cloud Access with tons of hands on exercises

Weekly Guest Speaker Sessions

Why Choose DataExpert.io Academy?

Anthropic

Databricks

Discord

Snowflake

GitHub

I have led teams of data engineers and software engineers at Airbnb, Facebook, and Netflix. My next goal is to upskill as many data knowledge workers as I can!

Zach Wilson

Master dbt, Snowflake, Iceberg, and Airflow — and become the analytics engineer every data team fights to hire.

Jess Ramos - Data Analyst 

Madison Schott - Analytics Engineer 

Ben Rogojan - Fractional Head of Data

John Kutay - Director of Engineering at Rippling

Carly Taylor - Field CTO at Databricks

Vin Vashishtha - Author of From Data to Profit

Parth Parekh - Director of Data Engineering at Meta

Prasad Rao - Principal Solutions Architect

Andrew Madson - Head of DevRel at Fivetran

Gourav Khanijoe - Engineering Lead at HubSpot

Carly Taylor - Field CTO at Databricks (2.0)

Jess Ramos - Data Analyst (2.0)

Madison Schott - Analytics Engineer (2.0)

Vaishali Macwan - Senior Data Scientist

Tim Chan - Data at OpenAI

Joe Reis - Author of Fundamentals of Data Engineering

Madison Schott - Analytics Engineer (3.0)

Carly Taylor - Field CTO at Databricks (3.0)

Raaid A. - AI, Data, & Product Strategy Leader 

Parth Parekh - Director of Data Engineering at Meta (2.0)

Capstone Project

Capstone Project Proposal

Understanding Capstone Requirements

Analytics Engineering Bootcamp Kickoff

Capstone Requirements

Data Expert.io Architecture

Onboarding Guide for the Data and AI Engineering Bootcamp

Complex Data Types Lecture

Complex Data Types Lab

Slowly Changing Dimensions Lecture

Slowly Changing Dimensions Lab

Graph Data Modeling Lecture

Graph Data Modeling Lab

Fact Data Modeling Lecture

Fact Data Modeling Lab

Data modeling with Date lists Lecture

Data modeling with Date lists Lab

Q&A with Zach Week 1

Q&A with Zach Week 2

Q&A with Zach Week 3

Q&A with Zach Week 4

Q&A with Zach Week1

Q&A with Zach Week2

Q&A with Zach Week3

Q&A with Zach Week4

Q&A with Zach Week5

dbt-basics-assignment

dbt basics Jan 2026

dbt basics Apr 2025

dbt basics:  How dbt works: sources, models, packages Lecture

dbt basics:  How dbt works: sources, models, packages Lab

dbt basics: creating a full dbt project lecture

dbt basics: creating a full dbt project lab

Build your first pipeline with dbt

Build your first pipeline with dbt Lab

Creating a full dbt Project Lecture

Creating a full dbt Project Lab

dbt advanced Apr 2025

dbt advanced Jan 2026

advanced-dbt-assignment

Advanced dbt: Understanding incremental models Lecture

Advanced dbt: Understanding incremental models Lab

Advanced pipelines: Blue-green and WAP with Airflow Lecture

Advanced pipelines: Blue-green and WAP with Airflow Lab

Advanced dbt: Jinja, Macros and variables Lecture

Advanced dbt: Jinja, Macros and variables Lab

Advanced dbt: Production Pipelines and dbt with Airflow Lecture

Advanced dbt: Production Pipelines and dbt with Airflow Lab

Advanced Snowflake Queries

Snowflake Basics Day 1 Lecture

Snowflake Basics Day 1 Lab

Conceptual Data Modeling Lecture Day 1

Conceptual Data Modeling Lab Day 1

How to use Snowpark and Snowflake Optimizations Lecture Day 2

How to use Snowpark and Snowflake Optimizations Lab Day 2

Advanced Snowflake Data Modeling and UDFs Lecture Day 3

Advanced Snowflake Data Modeling and UDFs Lab Day 3

Structured Embedding Assignment 

Advanced snowflake: Deploying the Capstone dag Lecture

Advanced snowflake: Deploying the Capstone dag Lab

Advanced Snowflake: Data Modeling and UDFs Lecture

Advanced Snowflake: Data Modeling and UDFs Lab

Master Advanced Snowflake Data Modeling with the VARIANT data type

How to connect Iceberg and Snowflake with Catalogs

Advance Snowflake Day 2 Lecture

Advance Snowflake Day 2 Lab

Apache Iceberg and PyIceberg

Apache Iceberg: Big Data History Lecture

Apache Iceberg: Partitioning, time travel for RCA and metadata Lab

Apache Iceberg: Data Lake Architectures Lecture

Apace Iceberg: Data Compression, Run length encoding Lab

Apache Iceberg: Data Contracts Lecture

Apache iceberg: WAP patterns and Querying branched Data Lab

Apache Iceberg Lecture Day1

Apache Iceberg Lab Day1

Apache Iceberg Lecture Day2

Apache Iceberg Lab Day2

Apache Iceberg Lecture Day3

Apache Iceberg Lab Day3

Airflow Data Quality Lesson

Create a cumulative DAG

How to build job orchestration that matters

Injecting quality into your Airflow DAG Lab

How to load data into Iceberg with Airflow

Airflow Day2 Lab

Backfilling with Airflow

Orchestration and Airflow Fundamentals Day 1 Lecture

Write a comprehensive pipeline spec document

Write a comprehensive pipeline spec document Lab

Orchestration and Airflow Fundamentals Lecture

Orchestration and Airflow Fundamentals Lab

Orchestration and Airflow Fundamentals Day 1 Lab

Hard Orchestration Lessons Day 2 Lecture

Hard Orchestration Lessons Day 2 Lab

Cumulative DAGs in Production Day 3 Lecture

Cumulative DAGs in Production Day 3 Lab

CDC Assignment

Bonus Growth Accounting Module

How to do Growth Accounting like Meta

Growth Accounting Lab

Mastering Change Data Capture (CDC)

Change Data Capture Lab

Snowflake and Glue Catalog Integration Lab

Understanding Read Streams and SCD Implementation Lab

Change Data Capture (CDC) and Snowflake basics Lecture

Change Data Capture (CDC) and Snowflake basics Lab

How to use snowpark and Snowflake optimization Lecture

How to use snowpark and Snowflake optimization Lab

Growth Accounting Models Lecture

Growth Accounting Models Lab

Grouping sets and Window functions Lecture

Grouping sets and Window functions Lab

Capstone Project AE Bootcamp April 2025

Capstone Proposal AE Bootcamp April 2025

Capstone Project Day 1 Lecture

Capstone Project Day 1 Lab

Capstone Project Day 2 Class

Capstone Project Day 3 Class

AnalyticsExpert

Timed, role-specific mock interviews — SQL under pressure, data modeling, system design, behavioral and more. Graded the moment you submit.

InterviewExpert

Master Snowflake, Coco AI Agents, Airflow and dbt and become a powerful AI analytics engineer

Kick off

Advance Snowflake Day 1 Lecture

Advance Snowflake Day 1 Lab

advanced dbt Day 1 Lecture

advanced dbt Day 1 Lab

advanced dbt Day 2 Lecture

advanced dbt Day 2 Lab

dbt basics Day1 Lab

dbt basics Day2 Lecture

dbt basics Day2 Lab

Senior AI Analytics Engineering Boot Camp

Ship production AI: RAG, agents, MCP, and MLOps — taught by the engineers companies are paying top dollar to hire.

RAG and LLMs Day1 Lecture

RAG and LLMs Day1 Lab

RAG and LLMs Day2 Lecture

RAG and LLMs Day2 Lab

LLMs Day 3 Part1

LLMs Day3 Part2

Capstone Proposal Assignment

Capstone Submission

Li Yin - Founder of Adal (2025-07-10)

Conor Brennan - CEO & Founder at Hypersell

Vikram Chennai - Founder at Ardent AI

Ryan Brandt - CEO at VundaAI

Chip Huyen - Author of AI Engineering

Data Engineering Interviews with Swetha at OpenAI

Tech Talk with Xinran Waibel

AIExpert

This gets you access to all self-paced content and the discord community of highly motivated learners!

All-Access DataExpert.io Subscription