Responsibilities
- Design and sustain high-performance data architectures on Google Cloud Platform with emphasis on BigQuery
- Enhance BigQuery query efficiency to lower processing time and operational costs
- Apply proven strategies for table organization, partitioning, clustering, and data retention in BigQuery
- Write and refine advanced SQL queries to support analytics and business reporting
- Evaluate query execution patterns, detect performance issues, and recommend tuning actions
- Work closely with data teams and business units to define data needs and implement robust solutions
- Build and manage data integration workflows using GCP tools like Dataflow, Pub/Sub, and Cloud Storage
- Develop automated scripts in Python or equivalent languages for system monitoring and optimization
- Control BigQuery spending by reviewing consumption trends and enforcing cost-saving measures
- Use GCP monitoring and logging features to oversee system performance and resource usage
- Establish documented standards and optimization protocols for cloud data environments
- Assist in structuring data models for reporting and business intelligence systems
- Keep current with evolving GCP capabilities, BigQuery updates, and cloud best practices
