All paths

Azure Data Engineering

Build production data pipelines on the Microsoft Azure data stack

Learn data engineering on the Azure stack used by Microsoft-aligned shops: Azure Data Factory (ADF), Azure Data Lake Storage Gen2 (ADLS), Synapse, Databricks notebooks, Power BI, plus Microsoft Fabric and Direct Lake. We cover the patterns (dimensional modeling, ETL vs ELT, Spark, streaming, data quality testing) using AdventureWorksLT data so by the end you have a runnable bronze→silver→gold pipeline you can demo in an interview. The underlying patterns translate to Snowflake / BigQuery / Redshift shops too, but you'll graduate Azure-fluent. Cert target: DP-203 Azure Data Engineer Associate.

SnowflakeBigQuerydbtAirflowSQL ServerSparkPythonPower BI

Salary range

$80k – $145k

entry → mid US

Time to complete

14 wk

28 wk part-time

Lessons

11

4 phases

Capstone

Yes

real cloud account

Salary range is sourced from BLS Database Architects + Glassdoor 2026 data-engineer postings. Your specific outcome depends on location, experience, interview performance, and market conditions.

Roles this path prepares you for

  • Azure Data Engineer
  • Analytics Engineer
  • ETL Developer
  • ADF / Synapse Engineer

Curriculum

1

Data Engineering Foundations

Free preview

What data engineering is, the modern data stack, SQL for data engineers, dimensional modeling.

3 lessons

2

Pipelines End-to-End

Locked

ETL vs ELT, cloud data warehouses, Spark crash course, streaming basics.

5 lessons

3

Data Quality + First Pipeline

Locked

Data quality testing patterns and shipping your first end-to-end pipeline.

2 lessons

4

Career Launch (Data)

Locked

Data engineering career paths, interview prep, portfolio guidance.

1 lessons

Capstone project + completion certificate

End-to-end SQL → Synapse → Power BI pipeline

In your own Azure subscription: ingest AdventureWorksLT into ADLS bronze, transform via Databricks notebooks (silver + gold star schema), load into Synapse, and surface in Power BI. Schedule daily.

Deliverables

  • ·Master ADF pipeline scheduled to run daily
  • ·Databricks notebooks for bronze→silver and silver→gold
  • ·Synapse tables populated with fact + dim
  • ·Power BI report with 3+ visuals via DirectQuery
  • ·Azure Monitor alert on pipeline failure
Completion certificate. Finish every lesson in this path and we auto-issue a CloudPath Azure Data Engineering certificate to your account, with a shareable verification URL. Show it on LinkedIn, your portfolio, or in a recruiter conversation.

Before you start

  • ·Basic SQL
  • ·Familiarity with the cloud (Cloud Foundations track or equivalent)

What you walk out with

  • Build production-grade Azure data pipelines
  • Design star schemas + dimensional models
  • Use Databricks for data transformation at scale
  • DP-203 certification ready
  • Interview confidently for Data Engineer roles

Ready to start?

Sign up, complete the 7-question fit-assessment wizard, and Onyx (your AI mentor) will tailor the path to your goals.

Start this path Explore other paths