A leading IT consulting firm is seeking a GCP Data Engineer to design and maintain scalable data pipelines primarily on BigQuery. Candidates should have strong SQL skills and experience with DBT for data modeling, alongside a solid foundation in data warehousing. This full-time role offers a hybrid working model, spanning several major U.S. cities, including Dallas and Atlanta.
Qualifications
5 years of experience in data engineering or similar role.
Expertise in SQL for writing efficient queries.
Proficiency in DBT for data transformation.
Responsibilities
Design, build, and maintain scalable data pipelines on GCP.
Develop and manage DBT models for clean datasets.
Collaborate with stakeholders to meet data requirements.
Skills
SQL
Data modeling with DBT
BigQuery
Python scripting
Data warehousing principles
Problem-solving
Communication skills
Education
Bachelor’s degree in Computer Science or related field
Tools
GCP
Git
Job description
Overview
Job Title: GCP Data Engineer
Location: Hybrid - Atlanta, GA / Dallas, TX / Houston, TX / Chicago, IL / NY-NJ
Duration: Fulltime with client
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, 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.
Required Qualifications
Bachelor’s degree in Computer Science, Information Systems, or a related field.
4-5 years of experience in data engineering or a similar role.
Strong expertise in SQL with the ability to write efficient, complex queries.
Proficiency 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.