Snowflake Data Engineer

Job Title

Snowflake Data Engineer

Location

Boston, MA

Employment Type

Contract Role

Job Summary

We are seeking a skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and data warehouse solutions using Snowflake. The ideal candidate will have strong experience in cloud data platforms, ETL/ELT processes, and data modeling, with a focus on delivering high-quality, reliable data solutions.

Key Responsibilities

• Design, develop, and maintain data pipelines using Snowflake
• Implement ETL/ELT workflows for ingesting data from multiple sources
• Optimize Snowflake performance, including query tuning and cost management
• Build and maintain data models (star/snowflake schemas)
• Work with structured and semi-structured data (JSON, Parquet, etc.)
• Integrate Snowflake with cloud platforms like AWS, Azure, or GCP
• Ensure data quality, integrity, and security best practices
• Collaborate with data analysts, scientists, and business stakeholders
• Automate workflows using orchestration tools (e.g., Airflow)
• Monitor and troubleshoot data pipelines and system issues

Required Skills & Qualifications

• Strong experience with Snowflake Data Warehouse
• Proficiency in SQL (advanced level)
• Experience with ETL/ELT tools (e.g., Informatica, Talend, dbt, Matillion)
• Hands‑on experience with cloud platforms (AWS / Azure / GCP)
• Programming knowledge in Python, Scala, or Java
• Understanding of data modeling techniques
• Experience with data integration and API‑based ingestion
• Familiarity with CI/CD pipelines and version control (Git)