Solution Architect

Job Title: Sr. Solution Architect
Job Location: Peoria, IL
Job Type: Contract

Job Description:

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

• Proven experience leading large-scale enterprise data migration projects.
• 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.

4. Data Engineering & Programming

• 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.