Zodiac Solutions, Inc
Data Warehouse Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Warehouse Engineer in Irving, TX, on a contract basis. Requires 8+ years of experience, 3+ years with BigQuery, strong SQL optimization skills, and hands-on GCP services knowledge. Scripting experience in Python/Bash is essential.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
April 14, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Irving, TX
-
🧠 - Skills detailed
#Bash #Security #Scripting #Migration #Logging #BTEQ #Data Engineering #Cloud #GCP (Google Cloud Platform) #Data Warehouse #BigQuery #SQL (Structured Query Language) #Clustering #DBA (Database Administrator) #Automation #Storage #Python #Teradata #Monitoring #Dataflow #EDW (Enterprise Data Warehouse) #IAM (Identity and Access Management) #Airflow
Role description
Role: Big Query DBA or Data Warehouse Engineer or Cloud Data Warehouse Engineer
Location: Irving, TX (onsite role)
Job Type: Contract
Job Description:
• 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.
• Strong SQL performance tuning and query optimization skills.
• Hands-on experience with GCP services: BigQuery, Composer/Airflow, Dataflow, Cloud Storage, Pub/Sub, 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
If you are interested, please share your most updated resume over dheeresh.vats@zodiac-solutions.com. Thank you so much.
Role: Big Query DBA or Data Warehouse Engineer or Cloud Data Warehouse Engineer
Location: Irving, TX (onsite role)
Job Type: Contract
Job Description:
• 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.
• Strong SQL performance tuning and query optimization skills.
• Hands-on experience with GCP services: BigQuery, Composer/Airflow, Dataflow, Cloud Storage, Pub/Sub, 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
If you are interested, please share your most updated resume over dheeresh.vats@zodiac-solutions.com. Thank you so much.
