GCP DBT (Data Build tool) Developer with SQL expertise

Tredence Inc.; Bengaluru; On-site; INR 2,800,000 - 4,800,000; Full time

Job summary

Tredence Inc. is hiring a seasoned DBT (Data Build Tool) Developer with SQL expertise to design, build and maintain ETL/ELT pipelines using DBT on Google Cloud Platform.

The role requires deep data modeling, quality frameworks, and collaboration with data engineers, analysts, and business stakeholders to deliver robust analytics solutions. The position is hybrid, supporting data-driven decision-making across multiple business units.

Qualifications

• 8+ years of experience in data engineering or related field.
• Proficiency in using DBT for data transformation, testing, and documentation.
• Advanced SQL skills for data modeling and large datasets.
• Understanding of data warehousing concepts, dimensional modeling, and star schema design.
• Experience with ETL/ELT tools and frameworks (Airflow/Composer, Dataflow, Data Fusion, Beam).

Responsibilities

• Designing, building, and maintaining ETL/ELT pipelines using DBT.
• Creating and managing data models and transformations using DBT to ensure efficient and accurate data consumption for analytics and reporting.
• Developing and maintaining a data quality framework, including automated testing and cross-dataset validation.
• Writing and optimizing SQL queries for efficient data processing within cloud components.
• Working with data engineers, analysts, scientists, and business stakeholders to deliver data solutions.
• Supporting day-to-day incident and ticket resolution related to data pipelines.
• Creating and maintaining comprehensive documentation for data pipelines, configurations, and procedures.
• Utilizing GCP services like BigQuery, Cloud Composer, Cloud Functions, etc.
• Developing and maintaining SQL/Python scripts for data ingestion, transformation, and automation tasks.

Skills

GCP

DBT

SQL

Python

Data Modeling

ETL/ELT

BigQuery

Tools

Airflow/Composer

Apache Beam

Cloud Dataflow

Data Fusion

Cloud Functions

Job description

Tredence is a global analytics services and solutions company. Our capabilities range from Advanced analytics and Data Management to Data Visualization, Big Data, and Machine Learning. Our uniqueness is in bringing the right mix of technology and business analytics to create sustainable white-box solutions that are transitioned to our clients at the end of the engagement. We do this cost-effectively using a global execution model leveraging our clients' existing technology and data assets. We also come in with some strong IP and pre-built analytics solutions in data mining, BI, and Big Data

Job title : DBT (Data Build tool) Developer with SQL expertise

Hybrid role from Location: Bangalore, Chennai, Gurgaon, Pune, Kolkata, Hyderabad

Employment Type: Full Time with Tredence

Experience - 8 to 12 years

Required Skills - GCP, DBT (Data Build tool), SQL

Role & responsibilities

• Designing, building, and maintaining ETL/ELT pipelines using DBT
• Creating and managing data models and transformations using DBT to ensure efficient and accurate data consumption for analytics and reporting.
• Developing and maintaining a data quality framework, including automated testing and cross-dataset validation.
• Writing and optimizing SQL queries for efficient data processing within cloud components.
• Working with data engineers, analysts, scientists, and business stakeholders to deliver data solutions.
• Supporting day-to-day incident and ticket resolution related to data pipelines.
• Creating and maintaining comprehensive documentation for data pipelines, configurations, and procedures.
• Utilizing GCP services like BigQuery, Cloud Composer, Cloud Functions, etc.
• Developing and maintaining SQL/Python scripts for data ingestion, transformation, and automation tasks.

Preferred candidate profile

• Typically requires 8+ years of experience in data engineering or a related field.
• Proficiency in using DBT for data transformation, testing, and documentation.
• Advanced SQL skills for data modeling, performance optimization, and querying large datasets.
• Understanding data warehousing concepts, dimensional modeling, and star schema design.
• Experience with ETL/ELT tools and frameworks, including Apache Beam, Cloud Dataflow, Data Fusion, or Airflow/Composer