Job Title: AWS Solution Architect Data Foundation (Snowflake)Company: Cogency Inc. Location: Toronto (Hybrid 4 Days Onsite Mandatory) Experience Required: 10+ YearsRole SummaryCogency Inc. is seeking a highly experienced AWS Solution Architect to design and build a scalable, secure, and enterprise-grade data foundation layer leveraging Snowflake on AWS.This role will be responsible for defining target data architecture and enabling data ingestion, storage, governance, and consumption for analytics, reporting, and AI/ML use cases within a banking environment.Key ResponsibilitiesArchitecture & DesignDesign end-to-end data architecture on AWS using Snowflake as the core data platformDefine data foundation layers (ingestion storage transformation consumption)Establish reference architectures, design patterns, and enterprise standardsAWS Cloud & Platform EngineeringArchitect scalable solutions using AWS services (S3, EMR, EKS, Lambda, IAM, VPC)Optimize cost, performance, and scalability of cloud platformsEnsure high availability, resiliency, and disaster recovery strategiesSnowflake Data PlatformDesign Snowflake architecture including databases, schemas, and virtual warehousesImplement secure data sharing and access control mechanismsDevelop and optimize data models and ELT/ETL pipelinesPerform performance tuning and workload managementData Ingestion & IntegrationDesign and implement pipelines for:Batch and real-time data ingestionStructured and semi-structured data processingIntegrate with upstream and downstream systems:Core banking platformsAPIs and external data sourcesAnalytics & Consumption LayerEnable data access for:BI tools (Power BI, Tableau)Advanced analytics and AI/ML platformsDefine semantic layers, data marts, and reporting structuresDevOps & AutomationImplement CI/CD pipelines for data and infrastructureUtilize Infrastructure as Code (Terraform, CloudFormation)Promote DevSecOps best practices and automationRequired QualificationsEducationBachelors or Masters degree in Computer Science, Engineering, or related fieldExperience10+ years of IT experience, including:5+ years in AWS cloud architecture3+ years of hands-on Snowflake implementationExperience in banking or financial services preferredTechnical SkillsStrong expertise in:AWS (S3, EMR, EKS, Lambda, IAM, VPC)Snowflake (SQL, Scala, Java)Experience with:Data modeling methodologies (Kimball, Data Vault)Streaming technologies (Kafka, Kinesis)Data platforms such as Quantexa (architecture & implementation)Certifications (Preferred)AWS Certified Solutions Architect (Professional)Snowflake SnowPro CertificationNice to Have (Banking Context)Knowledge of regulatory frameworks (OSFI, FINTRAC)Understanding of data privacy, governance, and residency requirementsExperience working on large-scale data platforms in Tier-1 banksMandatory RequirementsMust be available to work onsite in Toronto four (4) days per weekMust not have any personal or professional constraints to start upon selectionMust be willing to attend an in-person interview if required
Job Title
AWS Solution Architect – Data Foundation (Snowflake)