Snowflake Engineer

MACHINE LEARNING TECHNOLOGIES LLC

Paterson (NJ)

On-site

USD 96,000 - 138,000

Full time

8 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Machine Learning Technologies LLC is seeking an experienced Snowflake Engineer in Paterson, NJ to design, develop, and maintain scalable data warehouse solutions in the Snowflake ecosystem. The role emphasizes SQL, Python, ETL/ELT pipelines, and cloud integration across AWS S3 and Azure Data Lake.

The candidate will build Snowflake Snowpipe/Streams/Tasks, optimize queries, and implement CI/CD for deployments while collaborating with analysts and data engineers to meet data requirements.

Qualifications

  • Design and implement scalable data warehouse solutions using Snowflake.
  • Develop complex SQL queries, stored procedures, and views.
  • Build and optimize ETL/ELT pipelines for large-scale data processing.
  • Ingest data using Snowpipe and Snowflake Streams.
  • Create automated data transformations with Snowflake Tasks.
  • Integrate Snowflake with AWS S3, Azure Data Lake and other clouds.
  • Migrate data from legacy databases to Snowflake.
  • Optimize warehouse performance and manage resources.
  • Implement data security, RBAC and governance.
  • Develop data pipelines using Python and Snowpark.
  • Collaborate with analysts and data engineers on data requirements.
  • Monitor data quality and troubleshoot production pipelines.
  • Apply CI/CD practices for Snowflake deployments.

Responsibilities

  • Design, develop, and maintain Snowflake-based data warehouses.
  • Write and optimize SQL, stored procedures, and views.
  • Build ETL/ELT pipelines for large datasets.
  • Implement Snowpipe, Streams, and Tasks for data ingestion/automation.
  • Integrate Snowflake with cloud data stores (S3, Data Lake).
  • Migrate data from legacy DBs to Snowflake.
  • Ensure security and RBAC across environments.
  • Develop Python-based data pipelines with Snowpark.
  • Collaborate with business users to capture data needs.
  • Monitor quality and resolve production issues.
  • Follow CI/CD processes for deployments.

Skills

Snowflake Data Cloud
Advanced SQL
Python Programming
Snowpipe
Snowflake Streams
Snowflake Tasks
Snowpark
ETL/ELT Development
AWS S3
Azure Data Lake
Data Warehousing
Query Performance
ETL/ELT Tools
Git
Jenkins
CI/CD

Tools

Airflow
Informatica
Matillion

Job description

Job ID: J55356

Job Title: Snowflake Engineer

Location: Paterson, NJ

Duration: 8 Months + Extension

Domain Exposure: Utilities/ Energy

Client: To Be Discussed Later

Employment Type: W-2, 1099, C2C

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

Bill Rate: $83/hour (C2C)

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.
  • Develop ETL/ELT pipelines for large-scale data processing.
  • 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
  • AWS S3 / Azure Data Lake
  • Data Warehousing and Data Modeling
  • Query Performance Optimization
  • Apache Airflow / Informatica / Matillion
  • Git, Jenkins, and CI/CD
Equal Opportunity Employer

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Data Engineer
Snowflake Data Engineer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 90,000 - 124,000
Snowflake Data Engineer
Snowflake Data Engineer

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 83,000 - 124,000
Snowflake Engineer
Snowflake Engineer

Valiant Technologies LLC • Paterson (NJ)

On-site
USD 120,000 - 180,000
Snowflake Data Engineer
Snowflake Data Engineer

Robotics Technologies LLC • Atlanta (GA)

On-site
USD 77,000 - 110,000
Snowflake Engineer
Snowflake Engineer

Quantum Technologies LLC • Paterson (NJ)

On-site
USD 110,000 - 170,000
Snowflake Engineer
Snowflake Engineer

Ethereum Technologies LLC • Paterson (NJ)

On-site
USD 120,000 - 160,000
Snowflake Engineer
Snowflake Engineer

Robotic Process Automation LLC • Paterson (NJ)

On-site
USD 120,000 - 180,000
Snowflake Data Engineer
Snowflake Data Engineer

Quantum Technologies LLC • Atlanta (GA)

On-site
USD 77,000 - 110,000
Snowflake Data Engineer
Snowflake Data Engineer

Valiant Technologies LLC • Chicago (IL)

On-site
USD 88,000 - 125,000
Snowflake Data Engineer
Snowflake Data Engineer

Quantum Technologies LLC • Chicago (IL)

On-site
USD 88,000 - 125,000