Snowflake Developer (US Citizen Only)

Ampstek; Johnston (RI); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading IT consulting firm is seeking a highly skilled Snowflake Developer to design, develop, and optimize data pipelines. The ideal candidate has 4-8 years of experience in Data Engineering and strong hands-on experience with Snowflake, SQL, and cloud platforms. This is a contract role focused on building scalable ETL processes to ensure quality data delivery.

Qualifications

• 4–8+ years of experience in Data Engineering or Snowflake development.
• Strong hands-on experience with Snowflake, SQL, and cloud platforms.
• Expert-level SQL development and query tuning skills.

Responsibilities

• Design, develop, and optimize data pipelines and cloud-based data warehouse solutions.
• Build scalable ELT/ETL processes and integrate multiple data sources.
• Ensure high-quality data delivery to business and analytics teams.

Skills

Snowflake SnowSQL

SQL development

Data Engineering

ETL/ELT pipelines

Python

Cloud platforms (AWS/Azure/GCP)

CI/CD

Git

Tools

dbt

Airflow

Informatica

Matillion

Job description

We are seeking a highly skilled Snowflake Developer to design, develop, and optimize data pipelines and cloud-based data warehouse solutions. The ideal candidate will be responsible for building scalable ELT/ETL processes, integrating multiple data sources, and ensuring high-quality data delivery to business and analytics teams.

This role requires strong hands‑on experience with Snowflake, SQL, and cloud platforms (AWS, Azure, or GCP).

Required Skills & Qualifications

• 4–8+ years of experience in Data Engineering or Snowflake development.
• Strong hands‑on experience with Snowflake SnowSQL, Snowpipe, Streams, Tasks, and Stages.
• Expert-level SQL development and query tuning skills.
• Experience building ETL/ELT pipelines using Python, dbt, Airflow, Informatica, or Matillion.
• Experience with cloud platforms (AWS/Azure/GCP), particularly object storage (S3/Blob/GCS).
• Strong understanding of data warehousing, dimensional modeling, and data architecture principles.
• Experience with CI/CD, Git, and DevOps workflows.
• Excellent communication, documentation, and troubleshooting skills.

Preferred Qualifications

• Snowflake certification (SnowPro Core or Advanced).
• Experience in banking, finance, insurance, or healthcare is a plus.
• Knowledge of API integration and real-time ingestion.

Seniority Level

• Mid‑Senior level

Employment Type

• Contract

Industries

• IT Services and IT Consulting

To apply, contact Rakesh Pathak, Senior Technical Recruiter at Ampstek.