Snowflake Developer

Role: Snowflake Engineer

Location: New Haven, CT (Preferred) or Remote/Hybrid (Occasional travel, once a month)

Job Title: Snowflake Engineer 

Duration: 6-12 months (Contract to Hire)

The client is looking for a Data Engineer who can provide production support to our existing and future ETL environments. The candidate must possess strong technical expertise in Snowflake, data warehousing methodologies like Data Vault 2.0.

Core Responsibilities

• Manage the full lifecycle of Snowflake data operations, including monitoring, troubleshooting, and optimizing data pipelines.
• Design, develop, and optimize Snowflake data pipelines and models.
• Recommend and implement best practices for data ingestion, transformation, storage, security and data modeling.
• Support advanced features like Change Data Capture (CDC) and Slowly Changing Dimensions (SCD Type 2).
• Support frameworks like Data Vault and dimensional modeling in Snowflake.
• Provide production support for IBM DB2, Snowflake, and orchestration tools (Airflow, ESP).
• On-call and/or after-hours work required.

Skills Qualifications

• Minimum of 5 years of relevant experience in data warehousing, business intelligence tools, and data analysis.
• Minimum of 3 years of SQL query development across multiple database platforms (Snowflake, Oracle, SQL Server, DB2).
• Strong expertise in Snowflake (development, data modeling, security). Snowflake certification preferred.
• Strong proficiency in SQL and scripting languages (e.g., Python, Shell).
• Familiarity with orchestration tools (ESP, Airflow) and version control systems (Git).
• Experience with incident management tools (e.g., ServiceNow, Jira) and CI/CD practices.
• Solid understanding of data architecture, dimensional modeling, and frameworks like Data Vault.