Talent.com
Cogency
AWS Solution Architect – Data Foundation (Snowflake) - oshawaCogency • oshawa, on, ca
No longer accepting applications
AWS Solution Architect – Data Foundation (Snowflake) - oshawa

AWS Solution Architect – Data Foundation (Snowflake) - oshawa

Cogency • oshawa, on, ca
2 days ago
Job type
  • Full-time
Job description

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

Create a job alert for this search

AWS Solution Architect – Data Foundation (Snowflake) - oshawa • oshawa, on, ca

Similar jobs

Data Analyst - oshawa

BET99oshawa, on, ca
Full-time

BET99 is Canada's Premiere Online Sportsbook and Casino.Launched in 2020, we have consistently innovated the online gaming landscape every step of the way, exponentially growing our customer base a... Show more

 • Promoted

Data Foundations Principal - oshawa

Diabsolutoshawa, on, ca
Full-time

As part of Diabsolut’s continued growth, we are expanding our Innovation team with an experienced.It is not a delivery role, a utilization role, or a presales capacity role.It exists so that Diabso... Show more

 • Promoted

Oracle CPQ Consultant - oshawa

NLB Servicesoshawa, on, ca
Full-time

Oracle CPQ and Java integration development Job Responsibilities:.Conducting software analysis, programming, testing, and debugging.Individually manage Oracle CPQ, Java and Java EE application deve... Show more

 • Promoted

Senior Statistical Programmer - oshawa

Warman O'Brienoshawa, on, ca
Full-time

Senior Statistical Programmer | Leading CRO | Remote – Canada |.Join a fast-growing, independent CRO recognised for high-quality deliverables, outstanding client service, and a flexible, entreprene... Show more

 • Promoted

Senior Analytics (AWS DBT) Engineer - oshawa

Mastech Digitaloshawa, on, ca
Full-time

We are seeking a Senior AWS DBT Engineer to play a critical role in transforming an existing analytics ecosystem into a modern, scalable Databricks + dbt architecture (Bronze → Silver → Gold).This ... Show more

 • Promoted

CCaaS Consultant - oshawa

Quality IT Resourcingoshawa, on, ca
Full-time

Engagement length 6 months; would be looking for someone to start asap.Lead the technical design and implementation of Amazon Connect call flows, routing, IVR/IVA, and integrations.Plan and execute... Show more

 • Promoted

Architecte Réseau / Cloud Senior - oshawa

Astekoshawa, on, ca
Full-time

Astek est un leader mondial en conseil technologique.Avec plus de 7 800 experts à travers le monde, nous accompagnons nos clients dans leur transformation numérique en développant des solutions inn... Show more

 • Promoted

Microsoft 365 Solutions Architect - oshawa

Quarry Consultingoshawa, on, ca
Full-time

Title: Microsoft 365 Solutions Architect.Assisting in designing and maintaining a scalable, secure, and well governed information architecture.Leading migrations, modernisation, and platform consol... Show more

 • Promoted

Sr AWS Cloud Engineer (Banking/Capital Markets) - oshawa

companyoshawa, on, ca
Full-time

Senior AWS Cloud Engineer / Sr AWS DevOps (10+ years of experience).Duration: 6mo (high change of extension).Location: Downtown Toronto or remore (within Canada only).AWS cloud infrastructure / pla... Show more

 • Promoted

Director of AI - oshawa

People In AIoshawa, on, ca
Full-time

Director, AI / ML (Applied AI & Agentic Systems).A scaled, product-led technology company operating at the intersection of data, AI, and vertical SaaS—focused on transforming how complex, real-worl... Show more

 • Promoted

Oracle HCM Cloud Senior Consultant, Managed Services - oshawa

ArcLight Consultingoshawa, on, ca
Full-time

ArcLight Consulting, an Addison Group Company, is dedicated to ensuring that Cloud Solutions clients are successful with their investment.For over 15 years, ArcLight experts have provided guidance ... Show more

 • Promoted

Data Architect - oshawa

LatentView Analyticsoshawa, on, ca
Full-time

LatentView Analytics is a leading global analytics and decision sciences provider, delivering solutions that help companies drive digital transformation and use data to gain a competitive advantage... Show more

 • Promoted

Principal AI Engineer - oshawa

Workerbeeoshawa, on, ca
Permanent

No C2C or third-party submissions.Workerbee connects workers with employers through trusted introductions.By joining Workerbee you can be matched for project-based, contract, or permanent opportuni... Show more

 • Promoted

Director of Microsoft Cloud and Cloud Solution Provider (CSP )Operations - oshawa

Buchanan Technologiesoshawa, on, ca
Full-time +1

Director of Microsoft Cloud & CSP Operations.Remote, anywhere in North America.The Director of Microsoft Cloud & CSP Operations is responsible for the day-to-day management and optimization of the ... Show more

 • Promoted

SailPoint IdentityIQ (IIQ) – Architect - oshawa

Orion Labs Incoshawa, on, ca
Full-time

SailPoint IdentityIQ (IIQ) – Architect .At Orion Labs, we are looking for a SailPoint IdentityIQ Architect for a contract position with one of our clients.The duration of the contract will be 6 mon... Show more

 • Promoted

Agentic AI Architect - oshawa

Inizio Partnersoshawa, on, ca
Full-time

This role can be based in US or Canada - EST working hours.Role & Responsibilities Overview:.Architecture & Technical Leadership.Define end-to-end architecture for agentic AI-enabled platform acros... Show more

 • Promoted

DevOps Engineer (AI) - oshawa

Affinityoshawa, on, ca
Full-time

Client: Enterprise class EMR provider.On behalf of our client, Affinity is seeking a DevOps Engineer to build and evolve the infrastructure behind its flagship EMR platform.You’ll own Kubernetes-ba... Show more

 • Promoted

Developer/Analyst - oshawa

Navacordoshawa, on, ca
Full-time

Navacord is hiring technical talent in the insurance industry! We are accepting applications for a dynamic individual with 5+ years experience in a full stack development environment and with at le... Show more

 • Promoted

Senior Consultant, AI - oshawa

Konica Minolta Business Solutions Canadaoshawa, on, ca
Full-time

Exciting Opportunity in Canada - Remote.Lead the design and implementation/delivery of AI solutions, AI Training, Adoption, or Assessments, ensuring alignment with customer objectives, adhering to ... Show more

 • Promoted

Generative AI Developer – Retail/CPG Domain - oshawa

Comprehensive Resources Incoshawa, on, ca
Full-time

Generative AI Developer (Retail/CPG).Seeking a GenAI Developer with expertise in LLMs, RAG, and prompt engineering.Build scalable AI solutions using Python, LangChain, HuggingFace, and vector DBs l... Show more