Senior Data Engineer - Remote (GCP BigQuery Migration)

DeepCamp; United States; On-site; USD 130,000 - 180,000; Full time

Job summary

DeepCamp is seeking a Sr. Data Engineer to migrate legacy data platforms to Google Cloud Platform BigQuery, focusing on data warehouses and migration tooling. The role emphasizes data modeling, validation, and scalable ETL/ELT pipelines.

You will work on schema mapping, data profiling, and migration factory approaches, leveraging SQL, Python, Spark, and cloud data warehouse expertise to enable reliable migration and modern analytics capabilities.

Qualifications

• 6+ years in data engineering, ETL/ELT, analytics engineering, data warehouse development, or big data pipelines.
• 4 years on Google Cloud Platform cloud data platforms preferred.
• Cloud & Data Warehouse hands-on experience with BigQuery or another enterprise cloud data warehouse.
• Experience with one or more legacy data platforms such as Teradata, Hadoop/Hive, Databricks, Oracle, SQL Server, Netezza, Redshift, Snowflake, or Azure Synapse.
• Data Migration & Data Warehousing Experience in migration assessment, schema mapping, data profiling, and migration factory approaches.
• Strong understanding of dimensional modelling, fact and dimension table design, and SCD Type 1 & Type 2.
• Experience with schema evolution, historical data handling, data validation, reconciliation, parallel run, cutover, and rollback strategies.
• Data Engineering Strong proficiency in SQL and Python.
• Experience designing, developing, and supporting ETL/ELT pipelines.
• Strong understanding of data modelling, data warehousing concepts, partitioning, clustering, indexing, and query optimization.
• Experience with cloud storage and data lake architectures.
• Big Data & Pipeline Processing Hands-on experience with batch and streaming data pipelines.
• Experience with Spark/PySpark, Apache Beam, Google Cloud Dataflow, Dataproc, Databricks, Amazon EMR Workflow Orchestration & DevOps with orchestration tools.

Skills

SQL

Python

BigQuery

ETL/ELT

Data Warehousing

Data Modeling

Spark/PySpark

Cloud Data Platforms

Data Migration

Data Pipeline

Tools

Dataproc

Airflow

dbt

Cloud Composer

Job description

DeepCamp is seeking a Sr. Data Engineer to migrate legacy data platforms to Google Cloud Platform BigQuery, focusing on data warehouses and migration tooling. The role emphasizes data modeling, validation, and scalable ETL/ELT pipelines.

You will work on schema mapping, data profiling, and migration factory approaches, leveraging SQL, Python, Spark, and cloud data warehouse expertise to enable reliable migration and modern analytics capabilities.