In-depth understanding of Google's product technology and underlying architectures BigQuery - Warehouse data marts - Through understanding of Big Query internals to write efficient queries for ELT needs, creation of viewsmaterialized views, creation of reusable store procedures etc