---
source_url: "https://localdebootcamp.github.io/?utm_source=openai"
title: "Build Like a Data Engineer | Portfolio & System Design Mentorship"
mirrored_at: 2026-08-22T01:07:15.033Z
host: localdebootcamp.github.io
cited_in_42a: true
mirror_canonical: "https://index.42a.ai/localdebootcamp.github.io/index__q__utm_source_openai"
---

> **Original source:** https://localdebootcamp.github.io/?utm_source=openai

Core Promise

## Build, explain, and defend a real data pipeline.

This is not a passive course. It is a guided engineering environment where learners design, build, present, receive feedback, and improve.

“I can design, build, explain, and defend a real-world data pipeline from ingestion to transformation, orchestration, quality checks, and reporting.”

**For learners who know some SQL, Python, or data tools**

But still feel unsure about how real systems are connected end to end.

**For students, analysts, junior developers, and bootcamp graduates**

Especially those who need a serious portfolio project and clearer career direction.

**For people who want system design confidence**

The focus is not only tool usage, but also tradeoffs, architecture, failure handling, and production thinking.

**For learners ready to present their work**

Every participant should be willing to explain their project, design decisions, and improvements.

### Portfolio First

The main outcome is one strong end-to-end project, not scattered notes or isolated tutorials.

### System Design First

Students design the architecture before coding, so they understand the purpose of every component.

### Presentation Ready

Students learn how to explain tradeoffs, failures, data quality, backfills, and design decisions.

Python PostgreSQL SQL Docker dbt Core Airflow Medallion Architecture Kimball Modeling Data Quality Reporting Layer

Week 1

### Data Engineering Mindset + Skill Audit

Understand the real role of a data engineer, identify current gaps, choose a project domain, and define the project scope.

Week 2

### System Design Before Coding

Design the pipeline architecture, data flow, layers, failure points, freshness needs, and backfilling approach.

Week 3

### Data Ingestion with Python

Build config-driven ingestion from APIs, CSVs, or web sources and load raw data into PostgreSQL with logging and error handling.

Week 4

### Storage Design + Data Modeling

Create raw, staging, and production tables. Learn keys, data types, messy source handling, facts, and dimensions.

Week 5

### Transformations with SQL and dbt

Set up dbt Core, build staging and mart models, add tests, document models, and make transformations maintainable.

Week 6

### Orchestration with Airflow

Create DAGs, tasks, dependencies, schedules, retries, and run ingestion plus dbt through an orchestrated workflow.

Week 7

### Quality Checks, Backfilling, and Production Thinking

Add null checks, duplicate checks, reconciliation, audit logs, incremental logic, and a clear recovery strategy.

Week 8

### Final Presentation + Career Packaging

Polish GitHub, README, architecture diagram, project explanation, resume description, LinkedIn post, and final presentation.

**GitHub Project** Clean repo structure and documented code.

**Architecture Diagram** Clear visual explanation of the pipeline.

**Project README** Problem, design, setup, and usage explained.

**Final Presentation** Confident explanation of design tradeoffs.

**Quality Checks** Validation, reconciliation, and reliability logic.

**Backfill Strategy** Recovery and reprocessing plan.

**Resume Description** Project summary for job applications.

**LinkedIn Post** Shareable story of what was built.

Application Form

## Apply for the founding cohort

Share your current level, goals, and commitment. After submission, you will be redirected to a thank-you page and further announcements will be shared later.