Data architecture, streaming pipelines, transformations, SQL optimization, and performance engineering