Job Title: Snowflake Developer Location: Chicago or Cincinnati (Onsite)
Job Type: Fulltime
Job Description:
We are seeking a talented and experienced Snowflake Developer to join our growing data team. The ideal candidate will have handson 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 realtime 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:
- Bachelors degree in Computer Science Information Technology or a related field.