Senior Snowflake Data Engineer | Cloud DW, ETL Pipelines

Ethereum Technologies; Paterson (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

Ethereum Technologies is seeking an experienced Snowflake Engineer to design, develop, and maintain scalable cloud-based data warehouse solutions. The ideal candidate will have deep Snowflake, SQL, Python, and ETL/ELT expertise to build robust data pipelines across cloud platforms.

You will implement Snowpipe, Snowflake Streams/Tasks, and Snowpark to automate transformations, migrate data, and optimize performance while ensuring RBAC and governance compliance.

Qualifications

• Experience designing and maintaining Snowflake-based data warehouses.
• Strong SQL/PLSQL development for large-scale data pipelines.
• Experience with cloud data integration and data governance.

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

Skills

Snowflake Data Cloud

Advanced SQL and PL/SQL

Python Programming

ETL/ELT Development

Data Warehousing and Data Modeling

Query Performance Optimization

CI/CD for Snowflake

Tools

Snowflake Snowpipe

Snowflake Streams and Tasks

Snowpark

Apache Airflow

Informatica

Matillion

Job description

Ethereum Technologies is seeking an experienced Snowflake Engineer to design, develop, and maintain scalable cloud-based data warehouse solutions. The ideal candidate will have deep Snowflake, SQL, Python, and ETL/ELT expertise to build robust data pipelines across cloud platforms.

You will implement Snowpipe, Snowflake Streams/Tasks, and Snowpark to automate transformations, migrate data, and optimize performance while ensuring RBAC and governance compliance.