Data Engineer

Job description

**Job Title:** Data Engineer Snowflake & dbt **Experience:** 6+ Years **Location:** Bangalore **Notice Period:** Immediate to 15 Days (Preferred) Job Summary We are looking for an experienced **Data Engineer** with strong expertise in **Snowflake** and **dbt (Data Build Tool)** to design, develop, and optimize modern cloud-based data platforms. The ideal candidate should have hands-on experience in building scalable ETL/ELT pipelines, data modeling, and data warehousing using Snowflake. Experience with cloud platforms and orchestration tools is highly desirable. Key Responsibilities - Design, develop, and maintain scalable data pipelines using **dbt** and **Snowflake**. - Build and optimize ELT/ETL workflows for ingesting data from multiple sources. - Develop and maintain dimensional data models, star/snowflake schemas, and data marts. - Optimize Snowflake performance through query tuning, clustering, partitioning, and warehouse management. - Create reusable dbt models, macros, tests, snapshots, and documentation. - Collaborate with Data Analysts, BI Developers, and Business stakeholders to understand data requirements. - Ensure data quality through automated testing, validation, and monitoring. - Implement best practices for data governance, security, and performance optimization. - Troubleshoot production issues and provide timely resolutions. - Participate in code reviews and follow DevOps/CI-CD best practices. Mandatory Skills - 6+ years of experience in Data Engineering. - Strong hands-on experience with **Snowflake**. - Strong expertise in **dbt (Data Build Tool)**. - Experience in SQL query optimization and performance tuning. - Strong understanding of Data Warehousing concepts and dimensional modeling. - Experience with ETL/ELT development. - Proficiency in **Python** for data engineering tasks. - Experience with cloud platforms such as **AWS**, **Azure**, or **Google Cloud Platform (GCP)**. - Experience with Git and CI/CD pipelines. - Strong analytical and problem-solving skills. Preferred Skills - Experience with orchestration tools such as **Apache Airflow**, **Azure Data Factory (ADF)**, or similar. - Knowledge of data ingestion tools like **Fivetran**, **Matillion**, or **Informatica**. - Experience with messaging/streaming technologies such as **Kafka**. - Familiarity with BI tools such as **Power BI**, **Tableau**, or **Looker**. - Knowledge of Agile/Scrum methodologies.