interviews.md

Free Analytics Engineering Interview Advice

This is a list of resources you can rely on for great interview prep advice!

• The SQL Interview

  • DataExpert.io SQL Interview Video
  • DataExpert.io SQL Interview Blog Post
  • 50+ Data Lake SQL questions to try for free
  • 100+ SQL FAANG Interview Questions
  • HackerRank SQL Practice
  • StrataScratch SQL Interview Questions

• The Data Modeling Interview

  • DataExpert.io Data Modeling Interview Video
  • DataExpert.io Data Modeling Interview Blog Post
  • Kimball Dimensional Modeling Techniques

• The dbt & Transformation Interview

  • dbt Developer Blog - Best Practices
  • dbt Style Guide
  • How We Structure Our dbt Projects
  • GitLab dbt Guide

• The Metrics & Business Acumen Interview

  • Benn Stancil - The Analytics Engineering Guide
  • Locally Optimistic - Analytics Engineering
  • The Metrics Layer Explained

• The Data Quality & Testing Interview

  • dbt Testing Best Practices
  • Great Expectations Documentation
  • Elementary Data - Data Observability

• The Take-Home / Case Study Interview

  • Build a dbt project from scratch
  • Jaffle Shop dbt Tutorial
  • Analytics Engineering Portfolio Tips