Snowflake Engineer

Quantum Technologies. LLC; Paterson (NJ); On-site; USD 110,000 - 170,000; Full time

Job summary

Quantum Technologies. LLC is seeking an experienced Snowflake Engineer to design, develop, and maintain scalable cloud-based data warehouse solutions using Snowflake, SQL, Python, and ETL/ELT pipelines.

This role focuses on building robust data integration, performance optimization, and governance across cloud platforms. The ideal candidate will implement Snowpipe, Streams, and Tasks, leverage Snowpark with Python, and collaborate with analysts and engineers to translate data requirements into

Qualifications

• Extensive experience designing data warehouses in Snowflake.
• Strong SQL (Advanced/PLSQL) and Python development.
• Experience building and maintaining ETL/ELT pipelines with Snowflake.
• Knowledge of data modeling, warehousing concepts, and performance tuning.
• Familiarity with cloud data integration and governance practices.

Responsibilities

• Design, develop, and maintain scalable data warehouse solutions using Snowflake.
• Build and optimize complex SQL queries, stored procedures, and views.
• Implement data ingestion workflows using Snowpipe and Snowflake Streams.
• Develop automated data transformation processes using Snowflake Tasks.
• Integrate Snowflake with AWS S3, Azure Data Lake, and other cloud platforms.
• Migrate data from legacy systems to Snowflake.
• Optimize query performance and manage warehouse resource utilization.
• Implement RBAC and data governance controls.
• Develop data pipelines using Python and Snowpark.
• Collaborate with business analysts and data engineers on data requirements.
• Monitor data quality, troubleshoot pipelines, and resolve production issues.
• Implement CI/CD practices for Snowflake deployments.

Skills

Snowflake Data Cloud

Advanced SQL/PLSQL

Python Programming

ETL/ELT Development

Data Warehousing & Modeling

Query Performance Optimization

CI/CD for Snowflake

Tools

Snowpipe

Snowflake Streams

Snowflake Tasks

Snowpark

Apache Airflow

Informatica

Matillion

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization:US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary

We are looking for an experienced Snowflake Engineer responsible for designing, developing, and maintaining scalable cloud-based data warehouse solutions. The ideal candidate should have strong expertise in Snowflake, SQL, Python, ETL/ELT pipelines, and cloud data integration.

Key Responsibilities

• Design, develop, and maintain scalable data warehouse solutions using Snowflake.
• Build and optimize complex SQL queries, stored procedures, and views.
• Implement data ingestion workflows using Snowpipe and Snowflake Streams.
• Develop automated data transformation processes using Snowflake Tasks.
• Integrate Snowflake with AWS S3, Azure Data Lake, and other cloud platforms.
• Perform data migration from legacy databases to Snowflake.
• Optimize query performance and manage warehouse resource utilization.
• Implement data security, role-based access control (RBAC), and governance.
• Develop data pipelines using Python and Snowpark.
• Work with business analysts and data engineers to understand data requirements.
• Monitor data quality, troubleshoot pipeline failures, and resolve production issues.
• Implement CI/CD practices for Snowflake deployment and development.

Required Technical Skills

• Snowflake Data Cloud
• Advanced SQL and PL/SQL
• Python Programming
• Snowflake Snowpipe
• Snowflake Streams and Tasks
• Snowpark
• ETL/ELT Development
• Data Warehousing and Data Modeling
• Query Performance Optimization
• Apache Airflow / Informatica / Matillion

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.