GrowthArc - Snowflake Developer - SQL/ETL

Role Overview :

We are looking for an experienced Snowflake Developer with strong expertise in DBT and SQL, and optional exposure to Cortex as an added advantage. The ideal candidate will design, develop, and optimize scalable cloud-based data solutions, enabling analytics and business insights across the organization.

Key Responsibilities :

Snowflake Development :

- 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 Certification (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.

Soft Skills :

- Excellent problem-solving and analytical abilities.

- Strong communication and collaboration skills.

- Ability to work independently and in cross-functional teams.

- High attention to detail and quality.

(ref:hirist.tech)