Data Engineer(Snowflake & dbt)

Alt Digital Technologies Pvt. Ltd.; Dadri; Remote; INR 1,200,000 - 1,500,000; Full time

Job summary

Alt Digital Technologies Pvt. Ltd. seeks a hands-on Data Engineer to build scalable data pipelines on AWS, transforming raw data into analytics-ready models using Snowflake, SQL, and dbt for a global enterprise.

You will collaborate with analysts and stakeholders, optimize warehouse performance, and ensure data quality with automated testing and documentation. A strong ELT foundation and independent remote work are essential.

Qualifications

• Minimum 3 years of data engineering experience focusing on Snowflake, SQL, and dbt.
• Strong understanding of data warehousing concepts, dimensional modeling, and ELT patterns.
• Ability to troubleshoot and resolve data pipeline, ingestion, and performance issues.
• Familiarity with Git and version control workflows.
• Strong written and verbal communication skills.
• Excellent communication for client engagement and team collaboration.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines to ingest data into Snowflake from APIs, databases, and files.
• Build and manage dbt models, tests, and documentation following best practices.
• Develop and automate API ingestion workflows with proper retry and error-handling logic.
• Use AWS services to support data storage, processing, and pipeline orchestration.
• Monitor pipelines, troubleshoot failures, and ensure data quality and timely delivery.
• Optimize Snowflake performance and cost through warehouse sizing and query tuning.
• Collaborate with analysts and business stakeholders to understand and deliver data requirements.

Skills

Snowflake

SQL

dbt

Data warehousing

ELT patterns

Git

Communication

Education

Bachelor's or Master's in CS/IT

SnowPro Core certification

dbt Analytics Engineering certification

3-7 years of hands-on data engineering

Tools

AWS S3

AWS Lambda

AWS IAM

AWS CloudWatch

Airflow

Dagster

AWS Step Functions

Job description

• We are seeking a hands-on Data Engineer with solid expertise in Snowflake, SQL, and dbt. This role is ideal for someone passionate about building reliable data pipelines, transforming raw data into analytics-ready models, and delivering scalable data solutions on AWS for a global enterprise.

REQUIREMENTS

• Minimum 3 years of data engineering experience with a focus on Snowflake, SQL, and dbt.
• Strong understanding of data warehousing concepts, dimensional modeling, and ELT patterns.
• Ability to troubleshoot and resolve data pipeline, ingestion, and performance issues.
• Familiarity with Git and version control workflows.
• Strong written and verbal communication skills.
• Excellent communication skills for client engagement and team collaboration.

PREFERRED SKILLS

• Strong expertise in Snowflake, including data loading, Snowpipe, streams and tasks, and performance tuning.
• Advanced SQL skills, including complex joins, window functions, CTEs, and query optimization.
• Hands-on experience with dbt (models, macros, tests, snapshots, and incremental models).
• Experience in API-based data ingestion (REST/JSON), including authentication, pagination, and error handling.
• Working knowledge of AWS services such as S3, Lambda, IAM, and CloudWatch.
• Familiarity with orchestration tools such as Airflow, Dagster, or AWS Step Functions.
• Excellent problem-solving skills and ability to work independently in a remote setup.

RESPONSIBILITIES

• Design, develop, and maintain ETL/ELT pipelines to ingest data from APIs, databases, and files into Snowflake.
• Build and manage dbt models, tests, and documentation following best practices.
• Develop and automate API ingestion workflows with proper retry and error-handling logic.
• Use AWS services to support data storage, processing, and pipeline orchestration.
• Monitor pipelines, troubleshoot failures, and ensure data quality and timely delivery.
• Optimize Snowflake performance and cost through warehouse sizing and query tuning.
• Collaborate with analysts and business stakeholders to understand and deliver data requirements.

EDUCATION PROFILE

• Bachelor's or Master's Degree in Computer Science, Information Technology, or a related field.
• SnowPro Core certification and/or dbt Analytics Engineering certification (preferred).
• 3-7 years of hands-on experience in data engineering.