GCP Data Engineer — BigQuery + DBT Expert

Capgemini; New York (NY); On-site; USD 115,000 - 125,000; Full time

Job summary

Capgemini in the United States seeks a GCP Data Engineer to design, build and maintain scalable data pipelines on Google Cloud Platform, primarily with BigQuery and DBT for modeling. You will write optimized SQL, apply data warehousing concepts, and use Python for scripting and automation.

The role collaborates with data analysts and business stakeholders to deliver high‑quality data solutions. You will ensure data governance and security, monitor pipelines, and drive reliability in a fast-paced

Qualifications

• Hands-on experience with Google Cloud Platform and BigQuery
• Proficient in DBT for data transformation and modeling
• Strong SQL skills and solid data warehousing understanding
• Light proficiency in Python for scripting and automation
• Understanding of CES and call transcript data a plus

Responsibilities

• Design, build, and maintain scalable data pipelines on GCP, primarily using BigQuery
• Develop and manage DBT models to transform raw data into clean datasets
• Write complex and optimized SQL queries for data extraction, transformation, and analysis
• Implement and maintain data warehousing solutions with performance and reliability
• Collaborate with data analysts and business stakeholders to meet data requirements
• Monitor and troubleshoot data pipeline performance and data quality issues
• Automate data workflows using Python scripts where necessary
• Ensure data governance, security, and compliance standards are met

Skills

GCP pipelines

BigQuery

SQL

Data warehousing

Python

Pyspark

Call transcript data

Tools

DBT

DBT models

Job description

Capgemini in the United States seeks a GCP Data Engineer to design, build and maintain scalable data pipelines on Google Cloud Platform, primarily with BigQuery and DBT for modeling. You will write optimized SQL, apply data warehousing concepts, and use Python for scripting and automation.

The role collaborates with data analysts and business stakeholders to deliver high‑quality data solutions. You will ensure data governance and security, monitor pipelines, and drive reliability in a fast-paced