AWS Solution Architect – Data Foundation (Snowflake)

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