Senior Data Engineer (DBT - Data Build tool Developer)

As a DBT Senior/Lead Developer you will work with a team to help designing, building, and maintaining data pipelines and transformations using Data Build Tool (DBT). This often includes using tools like Python, and requires strong SQL skills and knowledge of data warehousing concepts. The role also involves ensuring data quality, performance optimization, and collaborating with cross-functional teams.

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

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

Years of experince - 59 Years

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 59 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 of 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.