Data Engineer

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

We are seeking a GCP Data Engineer with hands-on experience with Google Cloud Platform (GCP) services, particularly BigQuery, and be experienced in DBT for data transformation and modeling. This role requires strong SQL skills, a solid understanding of data warehousing concepts, and light proficiency in Python for scripting and automation. Strong understanding of Telco - CES and Network Data. Calls, Chats, Network data.

Your role:

• Design, build, and maintain scalable data pipelines on GCP, primarily using BigQuery.
• Nice to have the experience to 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, ensuring performance, scalability, and reliability.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions.
• 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 and experience:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 5 years of experience in data engineering or a similar role.
• Strong expertise in SQL 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.
• Excellent problem-solving and communication skills."