Job Title: Snowflake Developer

Location: Chicago or Cincinnati (Onsite)

Job Type: Full-time

Job Description:

We are seeking a talented and experienced Snowflake Developer to join our growing data team. The ideal candidate will have hands-on experience with Snowflake Data Cloud and a deep understanding of modern data warehousing concepts. As a Snowflake Developer, you will be responsible for developing, optimizing, and maintaining data models, pipelines, and integrations within the Snowflake platform. You will work closely with data engineers, architects, and business analysts to support business intelligence (BI) and data analytics initiatives.

Responsibilities:

• Design, develop, and optimize data models and ETL pipelines in Snowflake.
• Use Snowpipe for real-time data loading and automate data ingestion processes.
• Create and optimize SQL queries and stored procedures using SnowSQL.
• Collaborate with data engineers and analysts to support BI and analytics needs.
• Integrate Snowflake with various cloud platforms and data sources (AWS, Azure, GCP).
• Implement data security and governance best practices.
• Troubleshoot performance issues and optimize data workflows.

Required Skills:

• Strong experience with Snowflake Data Cloud (data models, Snowpipe, SnowSQL, Task management, etc.).
• Expertise in SQL query writing and performance tuning.
• Experience with ETL/ELT tools (e.g., dbt, Matillion).
• Familiarity with cloud platforms (AWS, Azure, GCP) and integration with Snowflake.
• Strong understanding of data modeling (Star Schema, Snowflake Schema).
• Experience with SnowPro certification or preparation.
• Knowledge of scripting languages (Python, Shell) and version control (Git).

Preferred Skills:

• Snowflake Certification (SnowPro Core or Advanced).
• Familiarity with BI tools (e.g., Tableau, Power BI, Looker).
• Experience with big data technologies (e.g., Hadoop, Spark).

Education:

• Bachelor's degree in Computer Science, Information Technology, or a related field.