Snowflake Engineer
Job Details
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
Data Platforms
Snowflake
IBM DB2
Oracle
SQL Server
Data Warehousing
Data Vault 2.0
Dimensional Modeling
Data Architecture
ETL Development
Data Integration
Programming & Scripting
Orchestration & DevOps
Apache Airflow
ESP
Git
CI/CD
Enterprise Tools
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.
Work Authorization Accepted
✅
✅
✅ Holder
No H1B, OPT, CPT, TN, or other visa sponsorship available for this position.
Never miss an opportunity! Create an alert based on the job you applied for.