Note: The job is a remote job and is open to candidates in USA. Dice is a recruiting company seeking a Snowflake Developer/Data Engineer for an insurance client. The role involves managing the full lifecycle of Snowflake data operations, designing and optimizing data pipelines, and providing production support for ETL environments.

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

• 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)
• 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
• Snowflake certification preferred

Company Overview

Company H1B Sponsorship