Data warehousing and data engineering
Build the warehouses and pipelines that feed the whole company.
Your running project
A shop chain's sales warehouse
- The need
- Bring each day's sales from several shops into one reliable table.
- The data
- A public sales dataset.
- External tools
- SQLSnowflakedbtAirflow
Workshop
Establish the needs
Who uses it, what problem it solves, how to tell it worked.
What you will learn
- Advanced SQL and dimensional modelling
- Loading, transformation and orchestration
- Cloud warehouses: Snowflake, Microsoft Fabric
- Data quality and documentation
Certifications to aim for at the end
- Entry levelSnowPro Core Certification (COF-C03)SnowflakeExam available in French.
- IntermediateMicrosoft Certified: Fabric Data Engineer Associate (DP-700)MicrosoftExam available in French.
- AdvancedSnowPro Advanced: Data Engineer (DEA-C02)Snowflake
These certifications are issued by their own bodies, not by Nangmo, and their exams are paid for with them. Checked on 3 November 2026: confirm the language, price and exam location on their site before registering. These exams are generally taken without AI: you will need to read and reason on your own.
How to start a career in this field
- 1Become very strong in SQL: it is most of the interview.
- 2Model a small warehouse from public data, then automate its loading.
- 3Take SnowPro Core, then DP-700.
- 4Start as a BI analyst or junior data engineer: these roles lead to one another.
First jobs to aim for
- Junior data engineer
- BI developer
- Analytics engineer
The workshop is open, but this path's lessons are not online yet. Tell us you are interested: it helps us decide which to write first.