Role - Senior GCP Data Engineer Location - Secaucus, NJ (Remote)Job Summary The Senior Data Engin

Danta Technologies; Secaucus (NJ); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Healthcare insurance

Major holidays

Paid sick leave

Job summary

Danta Technologies in Secaucus, NJ, is seeking a Senior GCP Data Engineer to design and maintain scalable data pipelines on Google Cloud Platform. You will work with architects, analysts, and stakeholders to deliver high-quality data solutions in BigQuery and related services.

The role involves data ingestion, transformation, orchestration, governance, and ensuring performance and cost optimization across enterprise data systems. Remote-friendly in Secaucus as noted.

Qualifications

• Extensive experience designing and maintaining scalable data pipelines on Google Cloud Platform (GCP).
• Strong SQL and Python expertise for data transformations and automation.
• Experience with data modeling, ETL/ELT frameworks, and data governance practices.

Responsibilities

• Design and implement end-to-end data pipelines using Cloud Dataflow (Python/Apache Beam) for batch and streaming data.
• Develop, optimize, and maintain BigQuery stored procedures, SQL scripts, and UDFs for complex transformations.
• Build and manage data orchestration workflows using Cloud Composer (Airflow) with appropriate operators and dependencies.
• Establish secure connections to source systems for data ingestion and integration.
• Migrate history data from legacy warehouses (Snowflake, Teradata, Netezza, Oracle, SQL Server) to BigQuery.
• Design data validation and testing frameworks to ensure data quality across pipelines.
• Implement data governance including metadata management, lineage tracking, and access control.
• Collaborate with analysts and architects to define scalable data models, views, and semantic layers in BigQuery.
• Troubleshoot pipeline failures, perform root-cause analyses, and apply preventive measures.
• Optimize cost and performance of GCP workloads using Best Practices for BigQuery and Dataflow.

Skills

Python programming

SQL

ETL/ELT frameworks

Data governance

Metadata & lineage

Data validation & testing

Data modeling (Star/Snowflake)

Workflow orchestration

Communication skills

Tools

BigQuery

Dataflow

Cloud Composer

GCS

Snowflake

Teradata

Netezza

Oracle

SQL Server

Job description

Job Summary

The Senior Data Engineer will be responsible for designing, developing, and maintaining scalable data pipelines and solutions on Google Cloud Platform (GCP). The role focuses on data ingestion, transformation, orchestration, and governance across enterprise data systems. The engineer will work closely with architects, data analysts, and business stakeholders to implement high-quality, performance-optimized data solutions in BigQuery and related GCP services.

Role - Senior GCP Data Engineer

Location - Secaucus, NJ (Remote)

Job Summary

The Senior Data Engineer will be responsible for designing, developing, and maintaining scalable data pipelines and solutions on Google Cloud Platform (GCP). The role focuses on data ingestion, transformation, orchestration, and governance across enterprise data systems. The engineer will work closely with architects, data analysts, and business stakeholders to implement high-quality, performance-optimized data solutions in BigQuery and related GCP services.

Key Responsibilities

• Design and implement end-to-end data pipelines using Cloud Dataflow (Python/Apache Beam) for batch and streaming data.
• Develop, optimize, and maintain BigQuery stored procedures (SPs), SQL scripts, and user-defined functions (UDFs) for complex transformations and business logic implementation.
• Build and manage data orchestration workflows using Cloud Composer (Airflow) with appropriate operators and dependencies.
• Establish secure and efficient connections to source systems for data ingestion and integration.
• Manage data ingestion workflows from on-premise and cloud sources into Google Cloud Storage (GCS) and BigQuery.
• Execute history data migration from legacy data warehouses (preferably Snowflake, Teradata, Netezza, Oracle, SQL Server) to BigQuery, ensuring accuracy and performance optimization.
• Design and maintain data validation and testing frameworks for ensuring data quality and reliability across pipelines.
• Implement data governance practices, including metadata management, lineage tracking, and access control.
• Collaborate with data analysts and architects to define scalable and reusable data models, views, and semantic layers in BigQuery.
• Troubleshoot data pipeline failures, perform root cause analysis, and implement preventive measures.
• Optimize cost and performance of GCP workloads using best practices for BigQuery and Dataflow.

Skill Requirements

• Strong hands-on experience in Google Cloud Platform (GCP) with expertise in BigQuery, Dataflow, Cloud Composer, and GCS.
• Proficient in Python programming for data engineering (Dataflow pipelines, validation scripts, automation).
• Expertise in BigQuery SQL, Stored Procedures, Views, and User Defined Functions (UDFs).
• Experience with data migration from on-premise or cloud data warehouses (preferably Snowflake, Teradata, Netezza, Oracle, SQL Server) to BigQuery.
• Strong understanding of ETL/ELT frameworks, data modeling, and schema design (Star/Snowflake).
• Familiarity with data governance, metadata, and lineage frameworks on GCP.
• Knowledge of data validation and testing techniques, including reconciliation, rule-based checks, and automation.
• Hands-on experience in workflow orchestration using Cloud Composer (Airflow) with custom operators.
• Strong SQL tuning and BigQuery performance optimization skills.
• Good communication and collaboration skills to work with cross-functional teams in Agile environments.
• Proven ability to troubleshoot, optimize, and enhance complex data workflows at scale.

Notes: All qualified applicants will receive consideration for employment without regard to race, color, religion, religious creed, sex, national origin, ancestry, age, physical or mental disability, medical condition, genetic information, military and veteran status, marital status, pregnancy, gender, gender expression, gender identity, sexual orientation or any other characteristic protected by local law, regulation or ordinance.

Benefits: Danta offers a compensation package to all W2 employees that are competitive in the industry. It consists of competitive pay, the option to elect healthcare insurance (Dental, Medical, Vision), Major holidays and Paid sick leave as per state law.

The rate/ Salary range is dependent on numerous factors including Qualification, Experience and Location.