BigQuery Platform Admin & Performance Optimizer

TechDigital Group; Ashburn (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

TechDigital Group is seeking an experienced BigQuery Administrator to manage and optimize enterprise BigQuery environments, ensuring performance, security, and cost efficiency across development to production workloads.

The role emphasizes governance, monitoring, and collaboration with analytics, reporting, AI/ML teams, and business-critical workloads.

Qualifications

• 8-10 years of experience in BigQuery administration and data platforms.
• Experience with GCP and cloud data engineering.
• Experience with workload management, reservations, and data governance.

Responsibilities

• Administer and maintain Google BigQuery environments across Development, QA, UAT, and Production.
• Configure and manage datasets, tables, partitions, clustering, and storage lifecycle policies.
• Manage BigQuery resource allocation, quotas, reservations, and workload management.
• Support platform upgrades, new feature adoption, and environment provisioning.
• Analyze and tune BigQuery SQL queries for performance and cost.

Skills

BigQuery Administration

SQL Performance Tuning

Python Programming

Shell Scripting

Cloud Monitoring

IAM & Security

Cost Optimization

Data Warehousing Concepts

Teradata Knowledge (Preferred)

Tools

Terraform

Git / CI-CD Pipelines

Apache Airflow / Cloud Composer

New Relic

ServiceNow

OpsGenie

Splunk

Job description

Job Summary
The BigQuery Administrator is responsible for the administration, monitoring, performance optimization, security, governance, and operational support of Google Cloud BigQuery environments.
The role ensures the availability, scalability, reliability, and cost efficiency of enterprise data platforms while supporting analytics, reporting, AI/ML, and business-critical workloads.

Experience Level: 8 - 10 Years
Role: L2/L3 Support / Platform Administration
Support Model: 24x7 Production Support (as applicable)

Technical Skills
∙ Google Cloud Platform (GCP)
∙ BigQuery Administration & Performance Tuning
∙ BigQuery Reservations & Capacity Management
∙ Python Programming
∙ GCP IAM & Security
∙ Cloud Monitoring & Logging
∙ Cloud Storage
∙ Data Warehousing Concepts
∙ SQL Performance Optimization
∙ Shell Scripting
∙ Terraform
∙ Git / CI-CD Pipelines
∙ Apache Airflow / Cloud Composer (preferred)
Database Knowledge
∙ BigQuery
∙ Teradata (Preferred)
∙ PostgreSQL/MSSQL/Oracle (Good to Have)
Monitoring & Operations
∙ Cloud Monitoring
∙ OpsGenie
∙ Splunk
∙ New Relic
∙ ServiceNow

Key Responsibilities
Platform Administration

• Administer and maintain Google BigQuery environments across Development, QA, UAT, and Production.
• Configure and manage datasets, tables, partitions, clustering, and storage lifecycle policies.
• Manage BigQuery resource allocation, quotas, reservations, and workload management.
• Support platform upgrades, new feature adoption, and environment provisioning.

Performance & Optimization

• Analyze and tune BigQuery SQL queries for improved performance and reduced execution cost.
• Optimize storage structures, partitioning, clustering, and materialized views.
• Monitor query execution patterns and recommend performance improvements.
• Improve workload efficiency and reduce cloud spend through continuous optimization.