Job Title: Solution Architect • No C2C/No Sponsorship • Location: Remote Hours: 12 hours a week, some work can be done after hours, but must be available during business hours for some calls. Duration: Contract until end end of Aug 2025 with opportunity to be put on different project codes Pay: $70-80/hr SOLUTIONS ARCHITECT – SNOWFLAKE DATA INGESTION & WAREHOUSING (FIVETRAN FOCUS) Snowflake Professional Services enables enterprise customers to unlock the full value of the Snowflake platform by providing expert guidance on data integration, platform design, and scalable data architecture. We are seeking a Senior Solutions Architect with hands-on expertise in Fivetran-based ingestion pipelines and Snowflake data warehousing best practices to lead and support customers through successful, production-ready implementations. This role is fully focused on data movement, modeling, and operationalization—helping teams architect high-quality, maintainable pipelines from diverse sources into well-designed Snowflake environments. AS A SENIOR SOLUTIONS ARCHITECT, YOU WILL: • Serve as a technical lead on data ingestion and warehousing engagements, specializing in Fivetran-to-Snowflake pipelines • Design, implement, and optimize data ingestion workflows across systems like Salesforce, Netsuite, Workday, and custom sources via Fivetran • Architect scalable and performant Snowflake data models using dimensional, normalized, or data vault approaches • Guide customers through data pipeline orchestration, transformation (ELT), and dependency management • Provide best practices on data quality, metadata management, lineage, and monitoring • Lead platform configurations: warehouse sizing, resource scaling, access controls, and cost optimization • Collaborate with customer data teams to design future-state architecture and build detailed technical roadmaps • Work across Snowflake internal teams to ensure platform alignment and adoption of new features REQUIRED SKILLS & QUALIFICATIONS: • Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent practical experience • 12+ years in data engineering, analytics, or architecture, including significant experience with Snowflake implementations • Strong hands-on expertise with Fivetran, including connector setup, sync optimization, and schema change management • Expert-level SQL skills, including window functions, CTEs, performance tuning, and analytics functions • Proficiency in Snowflake platform features, including role-based access control (RBAC), data sharing, secure views, and time travel • Solid understanding of modern ELT design patterns and orchestration tools such as dbt or Airflow • Experience designing high-volume, high-performance data pipelines in a cloud-native environment • Familiarity with data warehouse testing frameworks and implementation of data validation checks PREFERRED EXPERIENCE: • Experience with dbt for transformation logic and model versioning • Experience working with third-party APIs or webhook-based integrations into Snowflake • Cloud certifications (AWS, Azure, or GCP), especially related to data engineering • Experience in customer-facing roles within product or consulting organizations • Snowflake SnowPro Core and Advanced Architect or Data Engineer certifications