Sr. Solution Architect – Snowflake, AWS & Data Migration

Staffingine LLC

Peoria (IL)

On-site

USD 160,000 - 220,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Staffingine LLC seeks a Senior Solution Architect with deep Snowflake and AWS expertise to lead enterprise-scale data migration and engineering initiatives. The role involves designing scalable data platforms, data mapping strategies, and guiding both onshore and offshore teams to deliver secure, high-performance solutions.

The candidate will drive end-to-end migrations, data quality and governance, and explore AI-enabled approaches to enhance data productivity, reporting to executive

Qualifications

  • 15+ years of experience in data engineering or enterprise architecture.
  • Strong architectural experience with Snowflake and AWS.
  • Proven leadership of enterprise data migration projects.
  • Excellent communication and executive presence.
  • Must be available to work onsite in Peoria, IL, five days per week.

Responsibilities

  • Design and deliver scalable, secure enterprise data platforms on AWS and Snowflake.
  • Lead end-to-end data migrations including analysis, strategy, ETL/ELT, validation and production deployment.
  • Develop source-to-target data mappings and transformation rules.
  • Architect and lead batch and real-time data pipelines and integrations.
  • Design cloud-native data solutions using AWS services (S3, Glue, Lambda, EMR, IAM, VPC).
  • Design and optimize Snowflake architectures (Snowpipe, Streams, Tasks, Data Sharing).
  • Manage onshore and offshore teams delivering architecture and migration work.
  • Present architecture, strategies, and progress to executives and stakeholders.
  • Identify opportunities to leverage AI/LLMs to improve data engineering productivity.

Skills

Snowflake
AWS Cloud
Python
PySpark
CI/CD
Git/GitHub Actions
Terraform
CloudFormation
SageMaker
Data Governance

Tools

GitHub Actions
Terraform
CloudFormation
SageMaker

Job description

Sr. Solution Architect - Snowflake, AWS & Data Migration
Location: Peoria, IL - 5 Days Onsite (NON-NEGOTIABLE)
Experience: 17+ Years
Virtual
Position Overview

We are looking for a highly experienced Senior Solution Architect with strong expertise in Snowflake, AWS, Enterprise Data Engineering, and Data Migration. The ideal candidate will lead enterprise-scale data migration initiatives, design data mapping strategies, architect scalable data platforms, and drive end-to-end data engineering solutions across AWS and Snowflake.

The candidate should have hands‑on architectural experience in migrating complex enterprise data environments, integrating multiple data sources, developing data pipelines, and ensuring data quality, governance, security, and performance.

Key Responsibilities
  • Enterprise Data Architecture: Design and deliver scalable, secure, and high-performance enterprise data platforms using AWS and Snowflake.
  • Data Migration: Lead end-to-end data migration initiatives, including source-to-target analysis, migration strategy, data extraction, transformation, loading (ETL/ELT), validation, reconciliation, and production deployment.
  • Data Mapping: Develop source-to-target data mapping documents, define transformation rules, identify data dependencies, and ensure data accuracy and consistency during migration.
  • Data Engineering: Architect and lead batch and real-time data pipelines, data integrations, transformation frameworks, and enterprise data workflows.
  • AWS Architecture: Design cloud-native data solutions leveraging AWS services such as S3, Glue, Lambda, EMR, IAM, VPC, and CloudWatch.
  • Snowflake Architecture: Design and optimize Snowflake data platforms, including Snowpipe, Streams, Tasks, Dynamic Tables, data sharing, and performance optimization.
  • Team Leadership: Lead onshore and offshore teams to deliver architecture, data migration, and engineering solutions.
  • Stakeholder Management: Present technical architecture, migration strategies, project progress, and business value to executive stakeholders.
  • Innovation & AI: Identify opportunities to leverage AI, LLMs, vector databases, and automation to improve data engineering productivity and business outcomes.
Required Technical Skills
1. Snowflake
  • Strong expertise in Snowflake architecture, data warehousing, and performance optimization.
  • Hands‑on experience with Snowpipe, Streams, Tasks, Dynamic Tables, and data sharing.
  • Experience designing scalable data models and enterprise data warehouse solutions.
2. AWS Cloud
  • Deep expertise in AWS data and cloud infrastructure.
  • Hands‑on experience with S3, Glue, Lambda, EMR, IAM, VPC, and CloudWatch.
  • Experience designing secure and scalable cloud-based data platforms.
3. Data Migration & Data Mapping
  • Strong understanding of source-to-target data mapping and transformation rules.
  • Experience with ETL/ELT processes, data profiling, cleansing, validation, reconciliation, and migration testing.
  • Ability to develop migration roadmaps, strategies, and cutover plans.
  • Experience migrating legacy databases or data warehouses to Snowflake/AWS environments.
  • Advanced Python programming skills.
  • Strong experience with PySpark, Pandas, and NumPy.
  • Experience building scalable data pipelines and reusable data engineering frameworks.
  • Strong understanding of batch and real-time data processing.
5. DevOps & CI/CD
  • Experience with Git, GitHub Actions, GitLab CI, and automated deployment pipelines.
  • Infrastructure as Code experience using Terraform or AWS CloudFormation.
6. Data Governance & Security
  • Experience implementing RBAC, data masking, encryption at rest and in transit.
  • Strong understanding of data quality, metadata management, lineage, and governance frameworks.
7. AI & Machine Learning Awareness
  • Understanding of vector databases, LLM integration, prompt engineering, and MLOps.
  • Exposure to AWS SageMaker and AI-enabled data solutions.
Required Qualifications
  • 15+ years of experience in Data Engineering, Data Warehousing, Data Migration, or Enterprise Solution Architecture.
  • Strong architectural experience with Snowflake and AWS.
  • Proven experience leading enterprise data migration and data mapping initiatives.
  • Strong understanding of end‑to‑end data engineering and integration architecture.
  • Experience managing onshore and offshore technical teams.
  • Excellent communication and executive stakeholder presentation skills.
  • Must be available to work onsite in Peoria, IL, five days per week. This is non-negotiable.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Solution Architect
Snowflake Solution Architect

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
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
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
Data Solutions Lead
Data Solutions Lead

Adactin Software • United States

Remote
USD 140,000 - 210,000
Senior Solution Architect: Snowflake, AWS & Data Migration
Senior Solution Architect: Snowflake, AWS & Data Migration

Staffingine LLC • Peoria (IL)

On-site
USD 160,000 - 220,000
Senior Data & Cloud Architect – Snowflake & AWS
Senior Data & Cloud Architect – Snowflake & AWS

Worknovasllc • Peoria (IL)

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

Protégé Hunters • Atlanta (GA)

On-site
USD 130,000 - 160,000
Senior Snowflake Architect: Lead Data Solutions
Senior Snowflake Architect: Lead Data Solutions

Compunnel Inc. • Alpharetta (GA)

Hybrid
USD 180,000 - 240,000
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000