Snowflake Platform Engineer

Company Information
CIBC Mellon is a leading provider of asset servicing solutions to institutional investors in Canada, including multi‑currency accounting, fund valuation, and investment information reporting. We are passionate about providing exceptional client service backed by our culture of innovation and success. Our outstanding employee experience will provide you with opportunities to learn and grow professionally while supporting the communities in which you live and work.

Job Number: J

Category:
Information Technology

Employment Type:

Full Time

City:
Toronto

Posting Date:
June 18, 2026

Closing Date:
July 2, 2026

Position Overview
Reporting into the Assistant Vice President, Data Engineering the Snowflake Platform Engineer is responsible for the ownership, governance, and ongoing evolution of the enterprise data platform. Serving as the subject‑matter expert for Snowflake, this senior individual‑contributor designs scalable ingestion pipelines, enforces platform security, and champions modern architectural patterns. The role leverages Snowflake’s AI and governance capabilities to drive organizational value. The engineer collaborates closely with data engineers, analytics engineers, data scientists, and business stakeholders, functioning as both a hands‑on practitioner and internal advisor.

Decisions made in this role directly impact the reliability, cost‑efficiency, and strategic direction of the cloud data ecosystem.

Responsibilities
Platform Architecture & Engineering

Design, build, and maintain a production‑grade Snowflake environment aligned to Medallion Architecture principles (Bronze / Silver / Gold layers), ensuring clear data lineage, quality contracts, and promotion workflows across all tiers;

Architect and optimise multi‑cluster virtual warehouses, resource monitors, and auto‑scaling policies to balance performance against cost;

Lead the technical roadmap for the Snowflake platform, evaluating new features and native capabilities against business needs.

Data Ingestion & Integration

Design and operate Snowpipe, dbt, DAGs for low‑latency, continuous data ingestion and data orchestration;

Implement and manage Open Flow (Snowflake's native data flow orchestration) to automate end‑to‑end data movement with observable, auditable pipelines.

Security, Governance & Compliance

Own the RBAC (Role‑Based Access Control) framework — design and maintain role hierarchies, functional roles, object‑level privileges, row‑access policies, and column‑masking policies at enterprise scale;

Administer and extend Snowflake Horizon Catalog to manage and discover data assets, enforce data quality rules, apply sensitivity classifications, and publish the enterprise data catalog for internal consumers;

Implement and monitor data governance controls including dynamic data masking, object tagging, data classification, and lineage tracking through Horizon.

AI & Advanced Analytics

Drive adoption of Snowflake Cortex AI — deploy and fine‑tune Cortex LLM functions, Cortex Search, and Cortex Analyst to enable natural‑language querying and AI‑powered data products;

Identify and prototype new use cases for AI‑assisted data transformation, anomaly detection, and intelligent alerting within the platform.

Operations & Reliability

Establish and maintain platform observability: query profiling, cost attribution dashboards, warehouse utilisation metrics, and alerting;

Own platform incident response for data availability and performance issues; define and enforce SLOs / SLAs for critical data pipelines;

Manage Snowflake account‑level configurations including network policies, private link connectivity, Tri‑Secret Secure key management, and Business Critical features.

Enablement & Standards

Define and enforce coding standards, CI/CD patterns, and Infrastructure‑as‑Code practices for platform provisioning;

Mentor data engineers and serve as the escalation point for complex Snowflake questions across the organisation;

Produce documentation, runbooks, and architectural decision records (ADRs) that raise the collective engineering bar.

Qualifications
Education/Experience

Bachelor's degree or higher in Computer Science, Software Engineering, Information…