- Snowflake Development & Architecture
- Design and develop scalable Snowflake data models including fact, dimension, and staging layers.
- Optimize Snowflake storage and compute architecture based on business workloads.
- Data Ingestion & Pipeline Development
- Build and maintain ETL/ELT pipelines using: Snowflake SQL, Snowpipe, Azure Data Factory (ADF), Matillion
- Perform data validation, deduplication, and consistency checks across sources and targets.
- SQL & Stored Procedure Development
- Write complex SQL queries, views, and stored procedures using: Snowflake Scripting, JavaScript (for Snowflake stored procedures)
- Conduct SQL performance tuning and query optimization.
- Analyze and troubleshoot slow-running queries using Query Profile and Snowflake monitoring tools.
Required Skills & Qualifications
- 10+ years of experience in Data Engineering or related roles.
- 5+ years hands-on experience working with Snowflake.
- Strong expertise in SQL, stored procedures, and performance tuning.
- Hands-on experience with ETL/ELT tools such as Azure Data Factory, Matillion, or Snowpipe.
- Solid understanding of data warehousing concepts, dimensional modeling, and data architecture.
- Experience with RBAC, security best practices, and data governance.
- Familiarity with cloud platforms (Azure/AWS/GCP preferred).
- Solid debugging, problem-solving, and analytical skills.