Snowflake Developer

Quantum Technologies. LLC; Chicago (IL); On-site; USD 120,000 - 170,000; Full time

Job summary

Quantum Technologies. LLC is seeking a Senior Data Engineer to build and optimize modern Snowflake-based data warehouses. You will design scalable pipelines, implement robust data governance, and partner with analytics teams to enable enterprise insight.

The role requires 5–8 years in data engineering, strong SQL/Snowflake expertise, and experience with cloud platforms (AWS/Azure/GCP). This on-site position offers growth within a dynamic technical team.

Qualifications

• Bachelor's degree in Data Engineering, CS, IS, or Applied Math.
• Graduate coursework in Data Architecture / Cloud Computing.
• SnowPro Core/Advanced certifications preferred.
• Certifications in AWS/Azure/dbt or cloud data engineering beneficial.
• Hands-on experience delivering Snowflake data warehouse projects valued.

Responsibilities

• Design, develop, and maintain scalable Snowflake data warehouse solutions.
• Build and optimize complex SQL queries, views, and stored procedures.
• Develop ETL/ELT pipelines to integrate data from multiple sources.
• Configure Snowflake Streams and Tasks for automated data processing.
• Monitor warehouse performance and optimize query execution.
• Implement data validation, quality checks, and reconciliation processes.
• Manage data access, security policies, and user permissions.
• Collaborate with data engineers, architects, and analytics teams.

Skills

Snowflake architecture

SQL optimization

Snowflake Streams & Tasks

Snowflake stored procedures

Snowflake virtual warehouses

Python / Snowpark

Cloud platforms

Data modeling / dimensional modeling

ETL/ELT development

Data security / RBAC

Data governance

Education

Bachelor's degree in Data Engineering / CS

Graduate coursework in Data Architecture / Cloud Computing

SnowPro Core/Advanced certifications

Cloud certifications (AWS/Azure)

Tools

Informatica

Matillion

dbt

Fivetran

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:

This role focuses on building and optimizing modern cloud-based data warehouse solutions using Snowflake. The ideal candidate will have strong expertise in SQL, Snowflake architecture, data pipeline development, and cloud data integration, with the ability to handle large-scale enterprise data environments.

Technical Skill Requirements:

Strong hands-on experience with Snowflake data warehouse architecture.

Advanced proficiency in SQL and SnowSQL.

Experience with Snowflake Streams, Tasks, and Stored Procedures.

Knowledge of Snowflake virtual warehouses and query performance optimization.

Familiarity with Python, Snowpark, and scripting.

Experience with AWS, Azure, or Google Cloud Platform.

Knowledge of data modeling, dimensional modeling, and database design.

Experience with tools such as Informatica, Matillion, dbt, or Fivetran.

Understanding of data security, role-based access control, and data governance.

Core Responsibilities:

Design, develop, and maintain scalable data warehouse solutions in Snowflake.

Build and optimize complex SQL queries, views, and stored procedures.

Develop ETL/ELT pipelines to integrate data from multiple source systems.

Configure Snowflake Streams and Tasks for automated data processing.

Monitor warehouse performance and optimize query execution.

Implement data validation, quality checks, and reconciliation processes.

Integrate Snowflake with cloud storage and external data platforms.

Manage data access, security policies, and user permissions.

Collaborate with data engineers, architects, and analytics teams.

Experience & Technical Background:

5-8 years of experience in data engineering or data warehouse development.

3+ years of hands-on experience working with Snowflake.

Strong expertise in SQL, data transformation, and query optimization.

Experience building enterprise-scale ETL/ELT workflows.

Practical knowledge of cloud platforms and data integration tools.

Experience handling large datasets and complex data migration projects.

Strong analytical, troubleshooting, and problem-solving abilities.

Academic & Professional Qualifications:

Bachelor's degree in Data Engineering, Computer Science, Information Systems, or Applied Mathematics.

Graduate-level coursework in Data Architecture, Cloud Computing, or Database Systems is an advantage.

SnowPro Core or SnowPro Advanced certifications are preferred.

Certifications in AWS, Azure, dbt, or cloud data engineering are beneficial.

Relevant hands-on experience delivering Snowflake data warehouse projects is highly valued.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.