Data Engineer(Snowflake & dbt)

Data Engineer(Snowflake & dbt)

Job Details

• 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.

• Department

  Data Engineer(Snowflake & dbt)

• Location

  Noida , Bangalore, Remote

• Job Type

  Full Time

• Experience

  3-7 Years