Become an Analytics Engineer
Are you a Data Analyst with solid SQL skills looking to move into an Analytics Engineer role? Data modeling, advanced SQL, development best practices and modern tools like dbt, through an end-to-end capstone project.
What you'll learn
Master data modeling
Understand and apply the ER, Kimball Dimensional and One Big Table approaches, along with advanced patterns (SCD, snapshot tables, incremental models).
Write advanced SQL and adopt best practices
Structure complex queries (CTEs, window functions, pivot), and apply software engineering principles (tests, Git, documentation, CI/CD).
Lead an end-to-end transformation project
Frame, model, implement and document a complete transformation pipeline with peer review, from staging to marts.
The detailed programme
Eight progressive modules to move from Data Analyst to Analytics Engineer, from data modeling fundamentals to the end-to-end capstone project.
The Analytics Engineer role
3h30
Understand the Analytics Engineer role within modern data teams and lay the foundations of data modelling.
Objectives
- Understand the Analytics Engineer role, the ELT paradigm and the modern technical stack
- Master ER models, Kimball Dimensional (star/snowflake schema) and One Big Table
- Identify interactions with other data and business roles
What's covered
- The Analytics Engineer role, the ELT paradigm and the modern technical stack
- ER models, Kimball Dimensional (star/snowflake schema) and One Big Table
- Interactions with other data and business roles
Training investment
1 500,00 €
per participant
9 000,00 €
per session
Fund your training through an OPCO
As a Qualiopi-certified training provider, the courses we offer can be funded through an OPCO (the French vocational-training funding body). Find which OPCO you depend on here.
Let's discuss your project
Personalised quotes, tailor-made formats, OPCO funding options: we answer all your questions.
Request a quote