Senior DBT Engineer

Saama Technologies

Pune District, Chennai

Hybrid

INR 3,000,000 - 5,000,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Saama Technologies in Pune, India seeks a Senior DBT Engineer to design, build, and optimize cloud-based data architecture with scalable pipelines and high-quality data. You will work on data modeling, PySpark processing, and Redshift performance tuning within a modern data stack.

You will transform and test data using dbt, orchestrate with AWS services, and implement robust data quality and CI/CD practices in a fast-paced, enterprise environment.

Qualifications

  • 8–10 years of proven, hands-on experience with enterprise databases and data warehousing technologies.
  • Deep knowledge of data warehousing concepts: Facts, Dimensions, SCD1, SCD2, Data Loads, and Transformations.
  • Proficient in Python and SQL with libraries like pandas and boto3.
  • Hands-on AWS expertise: Redshift, S3, Glue, Lambda, Step Functions.
  • Experience with dbt for data transformation and testing.
  • Strong background with Apache Spark/PySpark for large-scale data processing.

Responsibilities

  • Design and maintain scalable data models and implement automated testing to ensure data integrity.
  • Develop production-grade PySpark pipelines to process massive datasets.
  • Architect, build, and tune Redshift table structures for fast query performance.
  • Leverage AWS services to deliver end-to-end cloud data solutions.
  • Develop robust pre-ingestion processes to pull data from APIs and third-party sources.
  • Manage CI/CD and version control using Git.

Skills

Python
SQL
dbt
PySpark
AWS
Data Modeling
ETL

Tools

AWS Redshift
S3
AWS Glue
Lambda
Step Functions
Git

Job description

Job Title: Senior DBT Engineer


Experience Level: 810 Years


About the Role:

We are seeking a highly experienced Senior dBT Engineer to design, build, and optimize our cloud-based data architecture. In this role, you will be responsible for building highly scalable data pipelines, optimizing data warehouse performance, and ensuring the highest standards of data quality. The ideal candidate will have 8 to 10 years of deep technical experience in databases, data warehousing, and modern cloud data stacks (AWS, dbt, PySpark).


Key Responsibilities:

  • Data Modeling & Transformation (dbt): Design and maintain clean, scalable data models. Write custom macros and implement automated testing to ensure data integrity before it moves upstream.
  • Big Data Processing (PySpark): Write highly efficient, production-grade PySpark code to process massive datasets, clean messy data, and prepare it for enterprise storage.
  • Data Warehousing (AWS Redshift): Architect, build, and maintain Redshift table structures. Actively monitor and tune database performance to ensure blazing-fast query execution.
  • Cloud Data Infrastructure: Leverage core AWS services to build end-to-end data solutions, utilizing S3 (file storage), AWS Glue (data cataloging/ETL), Lambda (automation scripts), and Step Functions (workflow orchestration).
  • Pipeline Development: Develop robust pre-integration processes to extract raw data from various APIs and third-party sources into staging areas.
  • Data Quality & CI/CD: Build automated systems to catch errors and bad data early in the pipeline. Manage code deployments, version control, and collaboration using Git.

Required Skills & Qualifications:

  • Experience: 8–10 years of proven, hands-on experience working with enterprise databases and data warehousing technologies.
  • Data Warehousing Fundamentals: Deep theoretical and practical knowledge of key data warehousing concepts, including Facts, Dimensions, Slowly Changing Dimensions (SCD1, SCD2), Data Loads, and Transformations.
  • Python & SQL Mastery:
    • Must be a highly proficient Python coder capable of using libraries like pandasand boto3 to build scripts and connect to complex APIs.
    • Ability to write, debug, and optimize advanced SQL queries with ease.
  • Cloud Expertise: Solid, hands-on experience operating within the AWS ecosystem (Redshift, S3, Glue, Lambda, Step Functions).
  • Big Data Tools: Strong background in Apache Spark/PySpark for large-scale data transformations.
  • Modern Data Stack: Practical experience with dbt (data build tool) for data transformation and testing.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer DBT
Data Engineer DBT

Multiverse Solutions • Dadri

On-site
INR 900,000 - 1,300,000
Data Engineer
Data Engineer

atsMantra® • Hyderabad

On-site
INR 1,500,000 - 2,600,000
Snowflake DBT Engineer
Snowflake DBT Engineer

Anblicks Inc. • Hyderabad

On-site
INR 1,800,000 - 2,800,000
Data Engineer
Data Engineer

ExlService Holdings, Inc. • Pune District

Hybrid
INR 2,500,000 - 4,500,000
Senior Data Engineer
Senior Data Engineer

Infomagnus • Hyderabad

Hybrid
INR 2,500,000 - 5,000,000
Data Engineer(Snowflake & dbt)
Data Engineer(Snowflake & dbt)

Alt Digital Technologies • Dadri

Remote
INR 1,200,000 - 1,500,000
Senior Data Engineer - Databricks & DBT
Senior Data Engineer - Databricks & DBT

Multiverse Solutions • Dadri

On-site
INR 4,500,000 - 6,000,000
Senior Data Engineer - Databricks & DBT
Senior Data Engineer - Databricks & DBT

Mployee.me • Dadri

Remote
INR 4,000,000 - 7,000,000
Data Engineer (Snowflake & dbt)
Data Engineer (Snowflake & dbt)

Marlabs Inc. • India

On-site
INR 1,200,000 - 1,800,000
Data Engineer (Snowflake & dbt)
Data Engineer (Snowflake & dbt)

Marlabs • Bengaluru

On-site
INR 1,800,000 - 2,400,000