Description

• Design, develop, and maintain Snowflake data warehouse objects including schemas, tables, stages, and warehouses.
• Build and optimize ETL/ELT pipelines using Snowflake features such as Snowpipe, Streams, Tasks, and Stored Procedures.
• Implement scalable data models (star, snowflake, Data Vault preferred).

DBT (Data Build Tool)

• Develop, test, and deploy transformation models using DBT.
• Build DBT tests, documentation, and snapshots following best practices.
• Maintain modular, version‑controlled transformations.

SQL Development

• Write efficient and complex SQL queries for transformations, analytics, and validation.
• Perform SQL tuning for speed, reliability, and cost optimization.

General Responsibilities

• Collaborate with analysts, data engineers, and business teams to deliver high‑quality data solutions.
• Troubleshoot pipeline and performance issues.
• Ensure data governance, security standards, and documentation.
• Participate in code reviews and follow DevOps best practices.

Required Skills & Experience

• 4+ years of experience in data engineering or cloud data warehousing.
• Strong hands-on experience with Snowflake.
• Solid proficiency in DBT including testing, lineage, and model deployment.
• Advanced SQL development skills.
• Experience with at least one major cloud platform: AWS, Azure, or GCP.
• Strong understanding of ETL/ELT, data modeling, and pipeline design.
• Experience with Git‑based version control and CI/CD workflows.

Mandatory
Snowflake certifications (SnowPro Core / Advanced).

Nice to Have

• Cortex experience (analytics acceleration, AI/ML‑assisted workflows, advanced transformation capabilities).
• Python or other scripting language knowledge.
• Experience with orchestration tools: Airflow, Prefect, Dagster, or similar

Key Skills

Education

Bachelor's degree