GCP Data Engineer: BigQuery & DBT Expert

Capgemini; Atlanta (GA); On-site; USD 120,000 - 170,000; Full time

Job summary

Capgemini seeks a GCP Data Engineer to design, build, and optimize data pipelines on Google Cloud Platform, with strong emphasis on BigQuery and SQL.

The role also involves developing and managing DBT models, scripting in Python for automation, collaborating with data analysts and stakeholders, ensuring data governance, security, and performance across data warehousing solutions. You will monitor pipelines and ensure reliable delivery for Telco data.

Qualifications

• Bachelor's degree in CS/IS or related field.
• 5 years of experience in data engineering or a similar role.
• Strong SQL expertise with complex queries.
• Hands-on experience with BigQuery and other GCP data services.
• Familiarity with Git for version control.
• Basic to intermediate Python for scripting and automation.

Responsibilities

• Design, build, and maintain scalable data pipelines on GCP, primarily using BigQuery.
• Develop and manage DBT models to transform raw data into clean, tested, and documented datasets.
• Write complex and optimized SQL queries for data extraction, transformation, and analysis.
• Implement and maintain data warehousing solutions for performance, scalability, and reliability.
• Collaborate with data analysts, data scientists, and stakeholders to understand 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

SQL

BigQuery

GCP

DBT

Python scripting

Data warehousing

Git

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

BigQuery

DBT

Git

Job description

Capgemini seeks a GCP Data Engineer to design, build, and optimize data pipelines on Google Cloud Platform, with strong emphasis on BigQuery and SQL.

The role also involves developing and managing DBT models, scripting in Python for automation, collaborating with data analysts and stakeholders, ensuring data governance, security, and performance across data warehousing solutions. You will monitor pipelines and ensure reliable delivery for Telco data.