Snowflake Developer

Veriipro; Boston (MA); On-site; USD 130,000 - 190,000; Full time

Job summary

Veriipro is seeking an experienced Snowflake Developer with 7–12 years of experience in data engineering and data warehousing. The role focuses on Snowflake architecture, SQL mastery, ETL/ELT design, and building scalable, high-performance data pipelines.

The candidate will design, develop, and optimize Snowflake data solutions, implement Streams/Tasks, integrate with cloud storage, ensure data quality and governance, and collaborate across engineering, BI, and data science teams.

Qualifications

• 7–12 years of experience in data engineering, data warehousing, or database development.
• Strong hands-on Snowflake experience and architecture knowledge.
• Advanced SQL with complex queries, procedures, views and objects.
• ETL/ELT development and data pipeline design.

Responsibilities

• Design, develop, and maintain scalable Snowflake data solutions.
• Develop efficient SQL queries, stored procedures, views, and data transformation logic.
• Build and maintain reliable ETL/ELT pipelines for batch and real-time data processing.
• Develop data models to support analytics, reporting, and BI requirements.
• Optimize Snowflake queries, warehouses, storage, and workloads for performance and cost efficiency.
• Implement Snowflake Streams and Tasks for incremental processing.
• Integrate Snowflake with enterprise data sources and cloud storage.
• Implement data quality checks, validation processes, and error-handling mechanisms.
• Support data security, governance access management, and compliance requirements.
• Troubleshoot data pipeline, SQL, performance, and production issues.
• Participate in design discussions, code reviews, and architecture decisions.
• Develop and maintain technical documentation and data process specifications.
• Collaborate with Data Engineers, Data Architects, BI Developers, Data Scientists, and business stakeholders.
• Support CI/CD and automated testing and deployment of Snowflake objects.

Skills

Snowflake

SQL

ETL/ELT

Data modeling

Cloud platforms

Git

CI/CD

Data governance

Job description

We are seeking an experiencedSnowflake Developer with 7–12 years of experience in data engineering, data warehousing, and cloud data platforms. The ideal candidate will have strong hands‑on expertise in Snowflake, SQL, ETL/ELT, data modeling, and cloud‑based data solutions, with the ability to design and deliver scalable, high‑performance data pipelines.

Required Technical Skills

• 7–12 years of experience in data engineering, data warehousing, or database development.
• Strong hands‑on experience with Snowflake data platform and architecture.
• Advanced proficiency in SQL and experience developing complex queries, stored procedures, views, and database objects.
• Strong experience with ETL/ELT development and data pipeline design.
• Experience with Snowflake features including warehouses, databases, schemas, stages, streams, tasks, views, and data sharing.
• Strong understanding of data modeling, including dimensional modeling, fact/dimension tables, and schema design.
• Experience integrating Snowflake with various source systems, APIs, databases, and cloud storage platforms.
• Experience with at least one cloud platform, preferably AWS, Azure, or GCP.
• Strong knowledge of data performance tuning, query optimization, and warehouse optimization.
• Experience with data quality, validation, security, access controls, and governance.
• Proficiency with Git and exposure to CI/CD and automated deployment processes.

Roles & Responsibilities

• Design, develop, and maintain scalable Snowflake data solutions.
• Develop efficient SQL queries, stored procedures, views, and data transformation logic.
• Build and maintain reliable ETL/ELT pipelines for batch and real‑time data processing.
• Develop data models to support analytics, reporting, and business intelligence requirements.
• Optimize Snowflake queries, warehouses, storage, and workloads for performance and cost efficiency.
• Implement Snowflake Streams and Tasks for incremental and automated data processing.
• Integrate Snowflake with enterprise data sources, cloud storage, and downstream applications.
• Implement data quality checks, validation processes, and error‑handling mechanisms.
• Support data security, governance access management, and compliance requirements.
• Troubleshoot data pipeline, SQL, performance, and production issues.
• Participate in technical design discussions, code reviews, and architecture decisions.
• Develop and maintain technical documentation and data process specifications.
• Collaborate with Data Engineers, Data Architects, BI Developers, Data Scientists, and business stakeholders.
• Support CI/CD, automated testing, and deployment of Snowflake objects and data pipelines.