Snowflake Solution Architect

Staffingine LLC

Peoria (IL)

On-site

USD 165,000 - 248,000

Part time

3 days 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

Staffingine LLC is seeking a Senior Snowflake Solution Architect for a contract role in Peoria, IL, onsite five days a week. The ideal candidate has 17+ years of enterprise data experience, with hands-on Snowflake and AWS expertise and strong leadership skills.

The role focuses on leading enterprise-wide data migrations, designing scalable cloud data architectures, and delivering end-to-end data engineering solutions, including governance and security considerations.

Qualifications

  • 17+ years of experience in Enterprise Data Engineering, Data Architecture, Data Warehousing, or Solution Architecture.
  • Hands-on architectural expertise in Snowflake and AWS.
  • Experience mapping data end-to-end from source to target and migration architecture.
  • Experience managing onshore and offshore technical teams.

Responsibilities

  • Design scalable, secure, enterprise data architectures using Snowflake and AWS.
  • Lead end-to-end data migration projects: extract, transform, load, validate, reconcile, cutover.
  • Develop source-to-target mapping documents and migration strategies.
  • Architect batch and real-time data pipelines, ETL/ELT, and enterprise data integration.
  • Design cloud-native data solutions using AWS services (S3, Glue, Lambda, EMR, IAM, VPC, CloudWatch).
  • Architect and optimize Snowflake platforms using Snowpipe, Streams, Tasks, Dynamic Tables, Data Sharing.
  • Lead onshore and offshore engineering teams and drive delivery standards.
  • Present architecture designs and roadmaps to senior stakeholders.

Skills

Technical Leadership
Stakeholder Management
Data Architecture
Cloud Data Migration
Communication

Tools

Snowflake
AWS
Python
PySpark
GitHub Actions
Terraform
AWS CloudFormation
Lambda
S3

Job description

Staffingine LLC is excited to announce an excellent Contract opportunity with one of our top clients !

Position: Snowflake Solution Architect
Location: Peoria, IL – 5 Days Onsite (NON-NEGOTIABLE)
Hire mode: Contract - Long term
Experience: 17+ Years
Job Summary
  • We are seeking a highly experienced Senior Enterprise Data Solution Architect with strong expertise in Snowflake, AWS Cloud, Enterprise Data Engineering, and Large-Scale Data Migration.
  • The ideal candidate will lead enterprise-wide data migration initiatives, design scalable cloud data architectures, develop source-to-target data mapping strategies, and drive end-to-end data engineering solutions.
  • The candidate must have hands‑on architectural experience migrating complex legacy data environments to Snowflake and AWS, building scalable data pipelines, and implementing enterprise data governance, security, and performance optimization practices.
Key Responsibilities
  • Solution Architecture: Design scalable, secure, and high-performance enterprise data architectures using Snowflake and AWS.
  • Data Migration: Lead end-to-end enterprise data migration, including extraction, transformation, loading, validation, reconciliation, and production cutover.
  • Data Mapping: Develop source-to-target mapping documents, transformation rules, data dependencies, and migration strategies.
  • Data Engineering: Architect batch and real-time data pipelines, ETL/ELT frameworks, and enterprise data integration solutions.
  • AWS Cloud: Design cloud-native data solutions using AWS S3, Glue, Lambda, EMR, IAM, VPC, and CloudWatch.
  • Snowflake: Architect and optimize Snowflake platforms using Snowpipe, Streams, Tasks, Dynamic Tables, and Data Sharing.
  • Technical Leadership: Lead onshore and offshore engineering teams and drive architecture and delivery standards.
  • Stakeholder Management: Present architecture designs, migration roadmaps, technical recommendations, and project updates to senior stakeholders.
  • Innovation: Identify opportunities to leverage AI, LLMs, vector databases, and automation to improve enterprise data engineering capabilities.
Required Technical Skills
  • Snowflake: Snowflake Architecture, Snowpipe, Streams, Tasks, Dynamic Tables, Data Modeling, Performance Optimization.
  • Data Migration & Mapping: Enterprise Data Migration, Source-to-Target Mapping, ETL/ELT, Data Transformation, Data Validation, Reconciliation, Legacy-to-Snowflake Migration.
  • Data Engineering: Python, PySpark, Pandas, NumPy, Batch & Real-Time Data Pipelines.
  • DevOps & CI/CD: Git, GitHub Actions, GitLab CI, Terraform, AWS CloudFormation.
  • Data Governance & Security: RBAC, Data Masking, Encryption, Data Quality, Metadata Management, Data Lineage.
  • AI/ML (Good to Have): LLMs, Vector Databases, Prompt Engineering, AWS SageMaker, MLOps.
Required Qualifications
  • 17+ years of overall experience in Enterprise Data Engineering, Data Architecture, Data Warehousing, or Solution Architecture.
  • Strong hands‑on architectural expertise in Snowflake and AWS.
  • Strong expertise in source-to-target data mapping and migration architecture.
  • Experience managing onshore and offshore technical teams.
  • Excellent communication, solution design, and executive stakeholder management skills.
  • Must be willing to work onsite in Peoria, IL, five days per week. This requirement is non‑negotiable.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Solution Architect – Snowflake, AWS & Data Migration
Sr. Solution Architect – Snowflake, AWS & Data Migration

Staffingine LLC • Peoria (IL)

On-site
USD 160,000 - 220,000
Senior Snowflake Architect – Onsite Enterprise Data (Peoria, IL)
Senior Snowflake Architect – Onsite Enterprise Data (Peoria, IL)

Staffingine LLC • Peoria (IL)

On-site
USD 165,000 - 248,000
Solution/Data Architect | Peoria, IL
Solution/Data Architect | Peoria, IL

Worknovasllc • Peoria (IL)

On-site
USD 120,000 - 160,000
Snowflake Architect
Snowflake Architect

Aroha Technologies, Inc • Raritan (NJ)

Hybrid
USD 96,000 - 165,000
Snowflake Data Architect (LOCAL CANDIDATES - DALLAS, TX)
Snowflake Data Architect (LOCAL CANDIDATES - DALLAS, TX)

Sum Theory, Inc. • Dallas (TX)

On-site
USD 152,000 - 262,000
Snowflake Architect
Snowflake Architect

PETADATA • Milwaukee (WI)

On-site
USD 120,000 - 150,000
Snowflake Architect
Snowflake Architect

5 Star Recruitment • Dallas (TX)

On-site
USD 130,000 - 160,000
Snowflake Architect
Snowflake Architect

PETADATA • Milwaukee (WI)

On-site
USD 120,000 - 150,000
Snowflake Architect
Snowflake Architect

Cognizant Technology Solutions Corporation • Missouri

On-site
USD 140,000 - 200,000
Senior Snowflake Developer
Senior Snowflake Developer

TekDallas • Boston (MA)

Hybrid
USD 130,000 - 185,000