[Remote] Snowflake Developer/Data Engineer
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