Snowflake Architect

CloudBigD

Chicago (IL)

Remote

USD 96,000 - 124,000

Full time

4 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

CloudBigD in Chicago, IL is seeking a Senior Snowflake Architect to design and implement enterprise data platforms and streaming solutions. You will lead Snowflake architecture, build pipelines, and ensure secure, scalable data ingestion.

The role covers Snowpipe automation, Data Vault modeling, and Azure data services (ADLS, ADF, Databricks), with emphasis on performance tuning, streaming integration, and robust security controls. Candidates should have deep Snowflake expertise and leadership.

Qualifications

  • Senior Snowflake Architect with expertise in Snowflake, Snowpipe, and Data Vault.
  • Strong SQL, Python/PySpark and Azure data engineering skills.
  • Experience designing enterprise data platforms and streaming solutions.

Responsibilities

  • Design and lead Snowflake-based data architecture.
  • Implement Snowpipe for automated data ingestion.
  • Develop data pipelines using SQL, Python, and PySpark.
  • Design and implement Data Vault architectures.
  • Build Azure data platforms using ADLS, ADF, and Databricks.
  • Implement Kafka-based streaming and Event Hub integration.
  • Apply row-level and column-level security.
  • Optimize Snowflake queries and warehouse performance.
  • Manage Snowflake tasks, triggers, and streaming workflows.
  • Understand and design underlying data infrastructure.

Skills

SQL
Python/PySpark
Data modeling
Leadership

Tools

Snowflake
Snowpipe
Kafka
Databricks
ADF
ADLS
PySpark

Job description

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

Job Title: Snowflake Architect
Location: Chicago, IL(Remote)
Duration: 24 Months + Extension
Bill Rate: $78/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description:

Looking for a Senior Snowflake Architect with strong expertise in Snowflake, Snowpipe, Data Vault, SQL, Python/PySpark, and Azure data engineering. The candidate will lead the design and development of enterprise data platforms and streaming solutions.

Key Responsibilities:

Design and lead Snowflake-based data architecture.

Implement Snowpipe for automated data ingestion.

Develop data pipelines using SQL, Python, and PySpark.

Design and implement Data Vault architecture.

Build Azure data platforms using ADLS, ADF, and Databricks.

Implement Kafka-based streaming and Event Hub integration.

Implement row-level and column-level security.

Optimize Snowflake queries and warehouse performance.

Manage Snowflake tasks, triggers, and streaming workflows.

Understand and design underlying data infrastructure.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Architect
Snowflake Architect

Robotic Technologies Automation • Chicago (IL)

Hybrid
USD 91,000 - 124,000
Snowflake Architect
Snowflake Architect

Ethereum Technologies • Chicago (IL)

Remote
USD 91,000 - 124,000
Snowflake Architect
Snowflake Architect

Robotics Technologies LLC • Chicago (IL)

Hybrid
USD 89,000 - 126,000
Snowflake Architect
Snowflake Architect

Quantum Technologies. LLC • Chicago (IL)

Hybrid
USD 89,000 - 126,000
Snowflake Architect
Snowflake Architect

Valiant Technologies LLC • New York (NY)

On-site
USD 96,000 - 107,000
Snowflake Architect
Snowflake Architect

Ethereum Technologies LLC • New York (NY)

On-site
USD 87,000 - 117,000
Snowflake Architect
Snowflake Architect

Quantum Technologies LLC • New York (NY)

On-site
USD 84,000 - 120,000
Snowflake Data Engineer
Snowflake Data Engineer

Quantum Technologies LLC • Atlanta (GA)

On-site
USD 77,000 - 110,000
Snowflake Data Engineer
Snowflake Data Engineer

Valiant Technologies LLC • Atlanta (GA)

On-site
USD 83,000 - 124,000
Snowflake Data Engineer
Snowflake Data Engineer

Ethereum Technologies LLC • Atlanta (GA)

On-site
USD 90,000 - 124,000