> Markdown version of [/jobs/ext/1349287-gcp-data-engineer-data-warehouse-migration-contract](https://www.wearedevelopers.com/jobs/ext/1349287-gcp-data-engineer-data-warehouse-migration-contract). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # GCP Data Engineer - Data Warehouse Migration (Contract) - **Company:** SYMHAS L.L.C. - **Location:** Denver, CO, United States - **Experience:** Experienced - **Salary:** $128,960.0 - $135,200.0 - **Contract:** Temporary contract - **Skills:** Application Programming Interfaces (APIs), Airflow, BigQuery, Cloud Computing Security, Cloud Storage, Continuous Integration, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Warehousing, Dimensional Modeling, Data Flow Control, Github, Identity and Access Management, Python (Programming Language), Microsoft SQL Server, Oracle (Applications), Cloudera, SQL Stored Procedures, SQL Databases, Teradata SQL, Google Cloud, Cloud Platform System, Netezza, Snowflake, Build Server, Git, Database Migration, Pyspark, Infrastructure Automation Frameworks, Data Lineage, Terraform, Code Restructuring, Looker Analytics, Data Pipelines - **Published:** July 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=db29dad2b864cc94 ## About the Role Work Authorization: Only U.S. Citizens and Green Card holders will be considered. Candidates must be able to work on our W2., * 6+ years of data engineering experience, including 3+ years hands-on with GCP data services (BigQuery, Dataflow, Cloud Composer) * Proven experience with at least one end-to-end data warehouse migration to BigQuery (e.g., from Teradata, Oracle, SQL Server, or Netezza) * Expert-level SQL and strong Python/PySpark skills, including translating and optimizing complex legacy SQL for BigQuery * Solid understanding of dimensional data modeling, data quality/reconciliation frameworks, and cloud security/IAM fundamentals * Nice to have: GCP Professional Data Engineer certification, dbt, Datastream/CDC pipelines, and Looker or other BI tools ## Description We are seeking a GCP Data Engineer to drive a large-scale data warehouse migration to Google Cloud Platform. The role involves migrating legacy on-prem data warehouse workloads to BigQuery, re-engineering ETL/ELT pipelines, validating data quality and reconciliation, and optimizing performance and cost in the target environment. You will work closely with data architects, analysts, and business stakeholders to deliver a reliable, well-governed cloud data platform., * Cloud Platform: Google Cloud Platform (BigQuery, Cloud Storage, Dataflow, Dataproc, Pub/Sub, Cloud Composer) * Migration Tooling: BigQuery Migration Service, Database Migration Service, Datastream * Languages: SQL, Python, PySpark * Orchestration: Cloud Composer (Airflow), dbt * Source Systems: Legacy EDWs (Teradata / Oracle / SQL Server / Netezza), flat files, APIs * Data Modeling: Dimensional modeling (star/snowflake), partitioning and clustering strategies in BigQuery * DevOps: Git, CI/CD (Cloud Build / GitHub Actions), Terraform * Governance & Quality: Dataplex, data lineage, reconciliation and validation frameworks, IAM and security best practices, * Migrate legacy data warehouse schemas, historical data, and workloads to BigQuery, including SQL translation and refactoring of stored procedures and ETL logic * Design, build, and optimize batch and streaming pipelines using Dataflow, Dataproc/PySpark, Pub/Sub, and Cloud Composer * Perform data validation and reconciliation between source and target systems to ensure completeness, accuracy, and auditability * Optimize BigQuery performance and cost through partitioning, clustering, materialized views, and workload tuning * Implement CI/CD and infrastructure-as-code practices for data pipelines and GCP resources * Collaborate with architects, analysts, and business teams on cutover planning, parallel-run testing, and post-migration support ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [A Guide to Green Tech and Green IT Careers](https://www.wearedevelopers.com/magazine/374-a-guide-to-green-tech-and-green-it-careers)