Snowflake Engineer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Purplejack Technologies LLC, is seeking the following. Apply via Dice today! Job Title S 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 Type2) implementations. Design and maintain Data Vault and dimensional data models within Snowflake environments. Provide production support for Snowflake, IBMDB2, 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 Vault2.0 architectures. Strong understanding of dimensional modeling concepts and best practices. Experience implementing CDC and SCD Type2 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 IBMDB2 Oracle SQL Server Data Warehousing Data Vault2.0 Dimensional Modeling Data Architecture ETL Development Data Integration CDC (Change Data Capture) SCD Type2 Data Pipelines Data Transformation Programming & Scripting SQL Python Shell Scripting Orchestration & DevOps Apache Airflow ESP Git CI/CD Enterprise Tools 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. Work Authorization Accepted U.S. Citizen, Permanent Resident, or other eligible status. No H1B, OPT, CPT, TN, or other visa sponsorship available for this position. #J-18808-Ljbffr