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.
-
Data Engineer(Snowflake & dbt)
-
Noida , Bangalore, Remote
-
Full Time
-
3-7 Years