Snowflake-DBT Developer

Key Responsibilities:

• Design, develop, and maintain data transformation pipelines using DBT to build modular, reusable, and scalable data models on Snowflake.
• Develop and optimize SQL queries for data loading, transformation, and analysis in Snowflake.
• Load and manage data efficiently in Snowflake from various sources, ensuring data quality and integrity.
• Analyze and profile data using SQL to support business requirements and troubleshooting.
• Collaborate with data engineers, analysts, and business stakeholders to understand data needs and translate them into technical solutions.
• Implement best practices for DBT project structure, version control (Git), testing, and documentation.
• Work on Azure cloud platform, leveraging its integration capabilities with Snowflake.
• Participate in code reviews, unit testing, and deployment processes to ensure high-quality deliverables.
• Troubleshoot and optimize data pipelines for performance and cost-effectiveness.

Qualification

• Bachelors degree in science, Engineering and related disciplines.

Work Experience

• 4-6 years of experience in data engineering or development roles, with at least 1 years of hands-on experience in Snowflake and 1 years with DBT.
• Experience developing ETL/ELT pipelines and working with data warehouse concepts.
• Strong proficiency in SQL, including complex query writing, data analysis, and performance tuning.
• Proven experience loading and transforming data in Snowflake.
• Hands-on experience working on Azure cloud platform and integrating Snowflake with Azure services.
• Familiarity with DBT Core features such as models, macros, tests, hooks, and modular project structure.
• Experience with version control systems like Git and CI/CD workflows is a plus.
• Strong analytical, problem-solving, and communication skills.