Senior Snowflake Developer

Nx-dt; United States; Remote; USD 150,000 - 190,000; Full time

Job summary

Nx-dt seeks a Senior Snowflake Developer to lead Snowflake development and architecture across scalable data models and pipelines. You will optimize storage/compute, implement robust ingestions, and ensure data quality with rigorous validation and governance.

Ideal candidates have 10+ years in data engineering, 5+ years on Snowflake, strong SQL and scripting skills, and hands-on experience with ADF/Matillion/Snowpipe in a cloud environment.

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).

Responsibilities

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

Skills

Snowflake

SQL

Performance tuning

Stored procedures

Data modeling

ETL/ELT pipelines

Snowpipe

Azure Data Factory

Matillion

Data governance

RBAC security

Cloud platforms (Azure/AWS/GCP)

JavaScript for Snowflake

Tools

Snowflake

Azure Data Factory

Matillion

Snowpipe

Job description

Role : Senior Snowflake Developer

Experience: 10+ Years

Role & Responsibilities

• 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).
• Strong debugging, problem-solving, and analytical skills.