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.