Data Engineer – Snowflake

Jobtailor; United States; On-site; USD 100,000 - 130,000; Full time

Job summary

Jobtailor is seeking a Snowflake-focused data engineer to design, build, and optimize Snowflake databases and procedures in a fast-paced environment. You will implement ingestion automation, manage RBAC, and partner with data teams to deliver scalable data solutions.

The role requires 2–5 years of IT experience with Snowflake development and strong SQL skills. Experience with Snowpipe, Cortex, and cloud integrations is a plus, and communication skills are essential.

Qualifications

• 2–5 years of IT experience with at least 2+ years of hands-on Snowflake development experience.
• SnowPro Certification is a plus.
• Strong communication and problem-solving skills.

Responsibilities

• Develop and maintain Snowflake databases, schemas, tables, views, streams, tasks, and stored procedures.
• Write and optimize complex SQL queries for performance and scalability.
• Design and implement data ingestion and automation solutions using Snowpipe, Streams, Tasks, and scripting.
• Manage Snowflake users, roles, permissions, and RBAC.
• Optimize performance using clustering, micro-partitioning, query profiling, and warehouse tuning.
• Build integrations with cloud platforms, BI tools, APIs, and external applications.
• Leverage Snowflake Cortex and other latest Snowflake features for AI‑driven use cases.
• Troubleshoot production issues and support platform monitoring and optimization.
• Collaborate with data engineers, analysts, and business teams to deliver scalable solutions.

Skills

Snowflake development

SQL optimization

Data modeling

RBAC management

Cloud integration

Collaboration

Tools

Snowpipe

Cortex

Job description

Responsibilities

• Develop and maintain Snowflake databases, schemas, tables, views, streams, tasks, and stored procedures.
• Write and optimize complex SQL queries for performance and scalability.
• Design and implement data ingestion and automation solutions using Snowpipe, Streams, Tasks, and scripting.
• Manage Snowflake users, roles, permissions, and Role-Based Access Control (RBAC).
• Optimize performance using clustering, micro-partitioning, query profiling, and warehouse tuning.
• Build integrations with cloud platforms, BI tools, APIs, and external applications.
• Leverage Snowflake Cortex and other latest Snowflake features for AI‑driven use cases.
• Troubleshoot production issues and support platform monitoring and optimization.
• Collaborate with data engineers, analysts, and business teams to deliver scalable solutions.

Requirements

• 2–5 years of IT experience with at least 2+ years of hands‑on Snowflake development experience.
• SnowPro Certification is a plus.
• Strong communication and problem‑solving skills.