Job Title: AWS Solution Architect – Data Foundation (Snowflake)
Company: Cogency Inc.
Location: Toronto (Hybrid – 4 Days Onsite Mandatory)
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 environment.
Key Responsibilities
Architecture & Design
- Design end-to-end data architecture on AWS using Snowflake as the core data platform
- Define data foundation layers (ingestion → storage → transformation → consumption)
- Establish reference architectures, design patterns, and enterprise standards
AWS Cloud & Platform Engineering
- 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
- Enable data access for:
- 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:
- 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 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