Snowflake Engineer

Job Title: Snowflake Engineer
Location: New Haven, CT (Preferred) OR Remote/Hybrid (Occasional travel once per month)
Employment Type: Contract-to-Hire
Duration: 6–12 Months

Position Overview

We are seeking an experienced Snowflake Engineer to support and enhance enterprise ETL and data warehouse environments. The ideal candidate will possess strong expertise in Snowflake development, data warehousing methodologies, and production support. This role requires hands-on experience with Data Vault 2.0, dimensional modeling, data pipeline optimization, and enterprise-scale data operations.

The successful candidate will play a key role in designing, developing, supporting, and optimizing Snowflake-based data solutions while ensuring reliability, scalability, and performance across critical business systems.

Core Responsibilities

• Manage the full lifecycle of Snowflake data operations, including monitoring, troubleshooting, performance tuning, and optimization of data pipelines.

• Design, develop, and maintain scalable Snowflake data pipelines and data models.

• Recommend and implement best practices for data ingestion, transformation, storage, security, and data governance.

• Develop and support Change Data Capture (CDC) processes and Slowly Changing Dimensions (SCD Type 2) implementations.

• Design and maintain Data Vault and dimensional data models within Snowflake environments.

• Provide production support for Snowflake, IBM DB2, and ETL orchestration platforms.

• Support and maintain scheduling and workflow orchestration tools such as Airflow and ESP.

• Troubleshoot production incidents and participate in root cause analysis and issue resolution.

• Collaborate with business and technical teams to deliver scalable and reliable data solutions.

• Participate in on-call support and occasional after-hours maintenance activities as required.

Required Qualifications

• Minimum 5 years of experience in Data Warehousing, Business Intelligence, Data Engineering, or Data Analysis.

• Minimum 3 years of SQL development experience across multiple database platforms such as Snowflake, Oracle, SQL Server, and DB2.

• Strong hands-on experience with Snowflake development, administration, data modeling, and security.

• Experience designing and implementing Data Vault 2.0 architectures.

• Strong understanding of dimensional modeling concepts and best practices.

• Experience implementing CDC and SCD Type 2 methodologies.

• Proficiency in SQL and scripting languages such as Python and Shell scripting.

• Experience with orchestration and scheduling tools including Airflow and/or ESP.

• Experience using Git for source code management and version control.

• Familiarity with CI/CD processes and deployment best practices.

• Experience working with incident management tools such as ServiceNow and Jira.

• Strong troubleshooting and production support experience in enterprise data environments.

• Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications

• Snowflake Certification.

• Insurance industry experience.

• Experience supporting large-scale enterprise data warehouse environments.

• Knowledge of data governance, security, and compliance best practices.

• Experience working in Contract-to-Hire environments.

Key Technical Skills

• Snowflake

• IBM DB2

• Oracle

• SQL Server

• Data Vault 2.0

• Dimensional Modeling

• Data Architecture

• ETL Development

• CDC (Change Data Capture)

• SCD Type 2

• Data Pipelines

• Data Transformation

• SQL

• Python

• Shell Scripting

• Apache Airflow

• ESP

• Git

• CI/CD

• ServiceNow

• Jira

Additional Information

• Candidates local to New Haven, CT are strongly preferred.

• Remote/Hybrid candidates must be willing to travel onsite approximately once per month.

• Participation in on-call rotations and occasional after-hours support is required.

✅
✅
✅ Holder

No H1B, OPT, CPT, TN, or other visa sponsorship available for this position.