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.