Winter 2026 Analytics Engineering Camp
Master Snowflake and dbt like a pro in 5 weeks!
Taught by Zach Wilson
Founder at DataExpert.io
What you'll learn
✓
Lifetime Access to Content
✓
5 guest speaker sessions
✓
Join a vibrant learning community
✓
Join our referral network for jobs
✓
Bulid a standout capstone project
✓
Best for Analysts looking to become Data Engineers or Data Engineers looking to upskill
Learn directly from the experts
Enroll now
Jan 6, 2026 – Feb 6, 2026 · Starting soon
Payment plan
$3000
one-timeDuration4 weeks
StartsJan 6, 2026
Time commitment12 hrs / week
FormatLive Online
What's included
Lifetime Access to Content
5 guest speaker sessions
Join a vibrant learning community
Join our referral network for jobs
Bulid a standout capstone project
Best for Analysts looking to become Data Engineers or Data Engineers looking to upskill
Course syllabus
160 lessons • 123+ hours of content • 20 assignments
Bootcamp Kick off
1
Analytics Engineering Bootcamp Kickoff
2
Data Expert.io Architecture
3
Onboarding Guide for the Data and AI Engineering Bootcamp
Airflow
1
How to build job orchestration that matters
2
Injecting quality into your Airflow DAG Lab
3
How to load data into Iceberg with Airflow
4
Airflow Day2 Lab
5
Backfilling with Airflow
Mastering Analytical Patterns
1
How to do Growth Accounting like Meta
2
Growth Accounting Lab
3
Mastering Change Data Capture (CDC)
4
Change Data Capture Lab
5
Snowflake and Glue Catalog Integration Lab
6
Understanding Read Streams and SCD Implementation Lab
dbt basics
1
Build your first pipeline with dbt
2
dbt basics Day1 Lab
3
dbt basics Day2 Lecture
4
dbt basics Day2 Lab
advanced dbt
1
advanced dbt Day 1 Lecture
2
advanced dbt Day 1 Lab
3
advanced dbt Day 2 Lecture
4
advanced dbt Day 2 Lab
Advanced Snowflake
1
Master Advanced Snowflake Data Modeling with the VARIANT data type
2
How to connect Iceberg and Snowflake with Catalogs
3
Advance Snowflake Day 2 Lecture
4
Advance Snowflake Day 2 Lab
Q&A with Zach
1
Q&A with Zach Week1
2
Q&A with Zach Week2
3
Q&A with Zach Week3
4
Q&A with Zach Week4
5
Q&A with Zach Week5
Tech Talks
1
Tech Talk - Joe
2
Tech Talk - Madison
3
Tech Talks - Carly
4
Tech Talk - Raaid
5
Tech Talk - Parth
TA Office hours
1
TA Office hour 1
2
TA Office hour 2
3
TA Office hour 3
4
TA Office hour 4
5
TA Office hour 5
6
TA Office hour 6
7
TA Office hour 7
8
TA Office hour 8
Career Dev Sessions
1
Career Dev Session 1
2
Career Dev Session 2
3
Career Dev Session 3
4
Career Dev Session 4
5
Career Dev Session 5
Book Club
1
Book Club 1
2
Book Club 2
3
Book Club 3
4
Book Club 4
5
Book Club 5
Data Modeling on Iceberg
1
Apache Iceberg Lecture Day1
2
Apache Iceberg Lab Day1
3
Apache Iceberg Lecture Day2
4
Apache Iceberg Lab Day2
5
Apache Iceberg Lecture Day3
6
Apache Iceberg Lab Day3
Data Modeling on Snowflake
1
Conceptual Data Modeling Lecture Day 1
2
Conceptual Data Modeling Lab Day 1
3
How to use Snowpark and Snowflake Optimizations Lecture Day 2
4
How to use Snowpark and Snowflake Optimizations Lab Day 2
5
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
6
Advanced Snowflake Data Modeling and UDFs Lab Day 3
Capstone Project
1
Lesson 1
Also included
IncludedAnalytics Engineering Boot Camp starting October 202449 lessons
IncludedAnalytics Engineering Boot Camp starting October 2024
49 lessonsBootcamp Kickoff
1Analytics Engineering Bootcamp Kickoff
2Capstone Requirements
3Understanding Capstone Requirements
Pipeline Spec Building + Airflow Fundamentals
1Write a comprehensive pipeline spec document
2Write a comprehensive pipeline spec document Lab
3Orchestration and Airflow Fundamentals Lecture
4Orchestration and Airflow Fundamentals Lab
Change Data Capture (CDC) and Analytical Patterns
1Change Data Capture (CDC) and Snowflake basics Lecture
2Change Data Capture (CDC) and Snowflake basics Lab
3How to use snowpark and Snowflake optimization Lecture
4How to use snowpark and Snowflake optimization Lab
5Growth Accounting Models Lecture
6Growth Accounting Models Lab
7Grouping sets and Window functions Lecture
8Grouping sets and Window functions Lab
dbt basics
1dbt basics: How dbt works: sources, models, packages Lecture
2dbt basics: How dbt works: sources, models, packages Lab
3dbt basics: creating a full dbt project lecture
4dbt basics: creating a full dbt project lab
Advanced dbt
1Advanced dbt: Understanding incremental models Lecture
2Advanced dbt: Understanding incremental models Lab
3Advanced pipelines: Blue-green and WAP with Airflow Lecture
4Advanced pipelines: Blue-green and WAP with Airflow Lab
Advanced Snowflake
1Advanced snowflake: Deploying the Capstone dag Lecture
2Advanced snowflake: Deploying the Capstone dag Lab
3Advanced Snowflake: Data Modeling and UDFs Lecture
4Advanced Snowflake: Data Modeling and UDFs Lab
Passing Analytics Engineer Interviews
1SQL
Bonus
1Complex Data Types Lecture
2Complex Data Types Lab
3Slowly Changing Dimensions Lecture
4Slowly Changing Dimensions Lab
5Graph Data Modeling Lecture
6Graph Data Modeling Lab
7Fact Data Modeling Lecture
8Fact Data Modeling Lab
9Data modeling with Date lists Lecture
10Data modeling with Date lists Lab
Tech Talk
1Tech talk with Andrew Madson
2Tech talk with Gourav Khanijoe
3Tech talk with Carly Taylor
4Tech talk with Jess Ramos
5Tech talk with Madison Schott
6Tech talk with Vaishali Macwan
7Tech talk with Tim Chan
TA Office Hours
1Office Hour 1
2Office Hour 2
3Office Hour 3
4Office Hour 4
IncludedAnalytics Engineering Boot Camp starting April 14th, 202544 lessons
IncludedAnalytics Engineering Boot Camp starting April 14th, 2025
44 lessonsData Modeling on Iceberg
1Apache Iceberg Lecture Day 1
2Apache Iceberg Lab Day 1
3Apache Iceberg Lecture Day 2
4Apace Iceberg Lab Day 2
5Apache Iceberg Lecture Day 3
6Apache iceberg Lab Day 3
Data Modeling on Snowflake
1Conceptual Data Modeling Lecture Day 1
2Conceptual Data Modeling Lab Day 1
3How to use Snowpark and Snowflake Optimizations Lecture Day 2
4How to use Snowpark and Snowflake Optimizations Lab Day 2
5Advanced Snowflake Data Modeling and UDFs Lecture Day 3
6Advanced Snowflake Data Modeling and UDFs Lab Day 3
Snowflake + dbt basics
1dbt basics Day 1 Lecture
2dbt basics Day 1 Lab
3dbt basics Day 2 Lecture
4dbt basics Day 2 Lab
Advanced dbt
1Advanced dbt Lecture Day 1
2Advanced dbt Lab Day 1
3Advanced dbt Lecture Day 2
4Advanced dbt Lab Day 2
End-to-End Project Hacking
1Capstone Project Day 1 Lecture
2Capstone Project Day 1 Lab
3Capstone Project Day 2 Class
4Capstone Project Day 3 Class
Q&A With Zach Wilson
1Q&A with Zach Week 1
2Q&A with Zach Week 2
3Q&A with Zach Week 3
4Q&A with Zach Week 4
TA Office Hours
1TA Office Hour 1
2TA Office Hour 2
3TA Office Hour 3
4TA Office Hour 4
5TA Office Hour 5
6TA Office Hour 6
Tech Talks
1Tech Talk 1 - Jess Ramos
2Tech Talk 2 - Madison
3Tech Talk 3 - Ben Rogojan
4Tech Talk 4 - John Kutay
5Tech Talk 5 - Carly Taylor
6Tech Talk 6 - Vin Vashishtha
7Tech Talk 7 - Parth Parekh
8Tech Talk 8 - Prasad Rao
Career Development
1Build-a-Resume!
2LinkedIn Like Pro!
Program Resources
See what you'll be working with
Program overview
Homework overview
Weekly schedule
Before you join
Prerequisites
Basic SQL skills
Platform Access Included
AstronomerDiscordGitHub
Snowflake
AWSScholarship Available
We believe great learning shouldn't be limited by finances. Apply for a partial or full scholarship to access this program.
Enroll now
Jan 6, 2026 – Feb 6, 2026 · Starting soon
Payment plan
$3000
one-timeDuration4 weeks
StartsJan 6, 2026
Time commitment12 hrs / week
FormatLive Online
What's included
Lifetime Access to Content
5 guest speaker sessions
Join a vibrant learning community
Join our referral network for jobs
Bulid a standout capstone project
Best for Analysts looking to become Data Engineers or Data Engineers looking to upskill
Enroll now
Jan 6, 2026 – Feb 6, 2026 · Starting soon
Payment plan
$3000
one-timeDuration4 weeks
StartsJan 6, 2026
Time commitment12 hrs / week
FormatLive Online
What's included
Lifetime Access to Content
5 guest speaker sessions
Join a vibrant learning community
Join our referral network for jobs
Bulid a standout capstone project
Best for Analysts looking to become Data Engineers or Data Engineers looking to upskill
$3000one-time
One-time