Snowflake Data Engineer

Company Description: GrowthArc is a business-technology consulting company that helps growth-focused organizations scale using an architecture-led approach powered by platforms, data, and AI. The company enables clients to simplify execution complexities through its Business Technology Blueprint (BTB) framework, which aligns technology decisions with business priorities and outcomes. BTB is built on deep, collective industry, domain, and technology expertise from seasoned practitioners. GrowthArc focuses on developing enterprise architecture blueprints and realizing them through intelligent platforms, interconnected data, and integrated AI solutions.

We are looking for an experienced Snowflake Consultant 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

• 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).
• Develop, test, and deploy transformation models using DBT.
• Build DBT tests, documentation, and snapshots following best practices.
• Maintain modular, version‑controlled transformations.
• Write efficient and complex SQL queries for transformations, analytics, and validation.
• Perform SQL tuning for speed, reliability, and cost optimization.
• 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

• 5+ 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.