[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.ResponsibilitiesManage the full lifecycle of Snowflake data operations, including monitoring, troubleshooting, and optimizing data pipelinesDesign, develop, and optimize Snowflake data pipelines and modelsRecommend and implement best practices for data ingestion, transformation, storage, security and data modelingSupport advanced features like Change Data Capture (CDC) and Slowly Changing Dimensions (SCD Type 2)Support frameworks like Data Vault and dimensional modeling in SnowflakeProvide production support for IBM DB2, Snowflake, and orchestration tools (Airflow, ESP)On-call and/or after-hours work requiredSkillsMinimum of 5 years of relevant experience in data warehousing, business intelligence tools, and data analysisMinimum 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 practicesSolid understanding of data architecture, dimensional modeling, and frameworks like Data VaultSnowflake certification preferredCompany OverviewDice is the go-to career marketplace for tech professionals. It was founded in 2010, and is headquartered in Drachten, Friesland, NLD, with a workforce of 201-500 employees. Its website is https://www.or-quest.nl/.Company H1B SponsorshipDice has a track record of offering H1B sponsorships, with 2 in 2022, 4 in 2021, 5 in 2020. Please note that this does not guarantee sponsorship for this specific role.