Design and implement advanced SQL queries in BigQuery for analytics

• Analyze schemas to map business requirements to data models

• Build native SQL operations and rollup queries for metrics aggregation

• Implement CTEs, window functions, and complex joins for hierarchical data

• Create parameterized queries with dynamic filtering and grouping

• Design data models for analytics and reporting

2. BigQuery Optimization

• Analyze query performance using execution plans

• Optimize SQL for cost and performance (partitioning, clustering, materialization)

• Recommend schema design improvements and best practices

• Monitor and tune slow queries and resource usage

3. Domain-Specific Analytics

• Understand business domains (Sales, Finance, Marketing, CX, Churn)

• Translate business metrics into SQL queries and GraphQL APIs

• Implement drill-downs, filters, and aggregations by domain