Big Query Admin
About the role
8+ years as a data warehouse engineer or dba. 3+ years of hands-on bigquery administration in production. Map Teradata DDLs and data types to BigQuery-optimized partitioning and clustering schemas. Refactor legacy Teradata BTEQ scripts and SQL logic into BigQuery Standard SQL and stored procedures. Optimize query performance and slot utilization to manage costs for migrated workloads. Configure BigQuery slot reservations and workload management to replicate Teradata capacity. Perform data validation, row-count reconciliations, and checksums between Teradata and GCP. Establish query guardrails and project-level quotas to manage spend during migration phases.
Responsibilities
- Strong SQL performance tuning and query optimization skills.
- Hands-on experience with Gcp services: BigQuery, Composer/Airflow, Dataflow, Cloud Storage, Monitoring/Logging.
- Experience with EDW platform migrations and enterprise-scale data engineering.
- Strong knowledge of IAM, security controls, networking basics, and DR strategies.
- Experience with scripting (Python/Bash) and automation.
Requirements
Strong knowledge of IAM, security controls, networking basics, and DR strategies. Experience with scripting (Python/Bash) and automation.
Qualifications
8+ years as a data warehouse engineer or dba. 3+ years of hands-on bigquery administration in production. Map Teradata DDLs and data types to BigQuery-optimized partitioning and clustering schemas. Refactor legacy Teradata BTEQ scripts and SQL logic into BigQuery Standard SQL and stored procedures. Optimize query performance and slot utilization to manage costs for migrated workloads. Configure BigQuery slot reservations and workload management to replicate Teradata capacity. Perform data validation, row-count reconciliations, and checksums between Teradata and GCP. Establish query guardrails and project-level quotas to manage spend during migration phases.
Skills
Strong SQL performance tuning and query optimization skills. Hands-on experience with Gcp services: BigQuery, Composer/Airflow, Dataflow, Cloud Storage, Monitoring/Logging. Experience with EDW platform migrations and enterprise-scale data engineering. Strong knowledge of IAM, security controls, networking basics, and DR strategies. Experience with scripting (Python/Bash) and automation.
Benefits
N/A
Pay
The expected pay range for this contract assignment is shown above with the Job details. The exact pay rate will vary based on skills, experience, and location and will be determined by the third-party employer.
Schedule
N/A