GCP Data Engineer — BigQuery & DBT Specialist

Capgemini; Atlanta (GA); Hybrid; USD 77,000 - 151,000; Full time

Job summary

Capgemini seeks a GCP Data Engineer to design, build and maintain scalable data pipelines on Google Cloud Platform, primarily BigQuery. The role emphasizes DBT modeling, advanced SQL, and Python scripting for automation.

You will collaborate with analysts and stakeholders, ensure data governance and security, and optimize data warehousing solutions for performance and reliability in a hybrid Atlanta, GA environment.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5+ years of experience in data engineering or a similar role.
• Strong SQL skills with the ability to write efficient, complex queries.
• Nice to have knowledge in DBT for data modeling and transformation.
• Hands-on experience with BigQuery and other GCP data services.
• Solid understanding of data warehousing principles and best practices.
• Basic to intermediate skills in Python for scripting and automation.
• Familiarity with version control systems like Git.

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, ensuring performance 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 and tasks using Python scripts where necessary.
• Ensure data governance, security, and compliance standards are met.

Skills

SQL

Python (basic)

Data warehousing concepts

Git

Education

Bachelor's degree in Computer Science, Information Systems, or a related field

Tools

BigQuery

DBT

GCP

Job description

Capgemini seeks a GCP Data Engineer to design, build and maintain scalable data pipelines on Google Cloud Platform, primarily BigQuery. The role emphasizes DBT modeling, advanced SQL, and Python scripting for automation.

You will collaborate with analysts and stakeholders, ensure data governance and security, and optimize data warehousing solutions for performance and reliability in a hybrid Atlanta, GA environment.