Apply on Kit Job: kitjob.ca/job/2fsj6q

Job Title: AWS Solution Architect – Data Foundation (Snowflake)

Company: Cogency Inc.

Experience Required: 10+ Years

Role Summary

Cogency 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 workplace.

Key Responsibilities

- Design end-to-end data architecture on AWS using Snowflake as the core data platform
- Establish reference architectures, design patterns, and enterprise standards
- Architect scalable solutions using AWS services (S3, EMR, EKS, Lambda, IAM, VPC)
- Optimize cost, performance, and scalability of cloud platforms
- Ensure high availability, resiliency, and disaster recovery strategies

Snowflake Data Platform

- Design Snowflake architecture including databases, schemas, and virtual warehouses
- Implement secure data sharing and access control mechanisms
- Develop and optimize data models and ELT/ETL pipelines
- Perform performance tuning and workload management

Data Ingestion & Integration

- Design and implement pipelines for:
- Batch and real-time data ingestion
- Structured and semi-structured data processing
- Integrate with upstream and downstream systems:
- Core banking platforms
- APIs and external data sources

Analytics & Consumption Layer

- BI tools (Power BI, Tableau)




- Advanced analytics and AI/ML platforms
- Define semantic layers, data marts, and reporting structures

DevOps & Automation

- Implement CI/CD pipelines for data and infrastructure
- Utilize Infrastructure as Code (Terraform, CloudFormation)
- Promote DevSecOps best practices and automation

Required Qualifications

Education

- Bachelor’s or Master’s degree in Computer Science, Engineering, or related field

Experience

- 10+ years of IT experience, including:
- 5+ years in AWS cloud architecture
- 3+ years of hands-on Snowflake implementation
- Experience in banking or financial services preferred

Technical Skills

- Strong expertise in:
- AWS (S3, EMR, EKS, Lambda, IAM, VPC)
- Snowflake (SQL, Scala, Java)
- Experience with:
- Streaming technologies (Kafka, Kinesis)
- Data platforms such as Quantexa (architecture & implementation)

Certifications (Preferred)

- AWS Certified Solutions Architect (Professional)
- Snowflake SnowPro Certification

Nice to Have (Banking Context)

- Knowledge of regulatory frameworks (OSFI, FINTRAC)
- Understanding of data privacy, governance, and residency requirements
- Experience working on large-scale data platforms in Tier-1 banks

Mandatory Requirements

- Must be available to work onsite in Toronto four (4) days per week
- Must not have any personal or professional constraints to start upon selection
- Must be willing to attend an in-person interview if required

#J-18808-Ljbffr

Apply on Kit Job: kitjob.ca/job/2fsj6q

📌 AWS Solution Architect – Data Foundation (Snowflake) (Toronto)
🏢 Cogency
📍 Toronto