Snowflake Data Engineer

Comerit; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Comerit is seeking a remote Snowflake Data Engineer to join the data engineering team. You will design and maintain scalable data pipelines on Snowflake, collaborating with data architects, analysts, and business stakeholders to deliver end-to-end solutions.

Ideal candidates have hands-on Snowflake experience, SQL proficiency, and certification. You will optimize performance, ensure data quality and security, and stay current with Snowflake features.

Qualifications

• Requires hands-on experience with Snowflake and data engineering.
• Strong SQL skills and Snowflake utilities (SnowSQL, SnowPipe, SnowPark).
• Familiarity with Data Vault 2.0 and Kimball data marts concepts.
• SnowPro certification is required.
• Proficiency in Python and AWS cloud environments.
• Experience with Agile methodologies and cross-functional collaboration.

Responsibilities

• Design, build, and maintain scalable data pipelines on Snowflake.
• Collaborate with architects, analysts, and stakeholders to deliver end-to-end solutions.
• Tune Snowflake performance using clustering, materialized views, and caching.
• Ensure data quality, security, and access controls across pipelines.
• Monitor data processing and troubleshoot issues promptly.
• Stay updated with Snowflake features and best practices.
• Translate requirements into detailed designs and code reviews.

Skills

SQL

Data modeling

ETL processes

Data Vault 2.0

Kimball Data Marts

Python

AWS

Agile methodology

Communication

Collaboration

Problem-solving

Education

SnowPro certification

Tools

Snowflake

SnowSQL

SnowPipe

SnowPark

Job description

This is a remote position. The Snowflake Data Engineer will be a member of the data engineering team for creating a data vault and data warehouse on Snowflake. This role will focus on building and maintaining scalable, efficient, and reliable data pipelines using the Snowflake Data Cloud. The ideal candidate will have extensive knowledge of Snowflake's architecture, features, and best practices. Originally posted on Himalayas

Responsibilities

1. Design, build, and maintain efficient, scalable, and reliable data pipelines using Snowflake and other relevant data integration tools.
2. Collaborate with data architects, analysts, and business stakeholders to understand data needs and deliver end-to-end solutions.
3. Optimize and performance-tune Snowflake data processes using best practices such as clustering keys, materialized views, and caching.
4. Ensure data quality, accuracy, and security by implementing proper validation, monitoring, and access controls.
5. Monitor data processing operations to ensure timely and successful completion, and proactively troubleshoot any issues.
6. Stay updated with the latest Snowflake features, upgrades, and best practices to continually improve data processes.
7. Translate complex functional and technical requirements into detailed designs.
8. Contribute to the team's knowledge by providing guidance, conducting code reviews, and sharing expertise.

Requirements

• Minimum of [specific number, e.g., "3"] years of experience as a Data Engineer or similar role with hands-on experience with Snowflake.
• Strong SQL skills and experience with Snowflake utilities like SnowSQL, SnowPipe, and SnowPark.
• Familiarity with data modeling concepts and ETL processes. o Data Vault 2.0 o Kimball Data Marts
• Snowflake SnowPro certification
• Familiarity with scripting languages like Python.
• Strong problem-solving skills and attention to detail.
• Excellent communication and collaboration skills
• Experience with AWS cloud platforms
• Experience with Agile methodology