Senior Snowflake Developer Python Data Architect

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 7 hours ago

Vacancies: 1 Vacancy

Job Summary

Role: Senior Snowflake Developer - Python Data Architect.

Location: Toronto ON (Onsite).

Duration: Long Term Contract.

Job Overview
Design and own enterprise Snowflake platforms processing petabyte-scale analytics workloads. This senior role architects data models optimizes query performance at scale and builds production Python pipelines ensuring 99.99% reliability for business-critical analytics.

Snowflake Architecture Ownership

Data Warehouse Design: Multi-warehouse sizing clustering keys materialized views
Advanced Features: Snowpark Python UDFs streams/tasks zero-copy cloning
Performance Engineering: Query acceleration search optimization auto-clustering
Security & Governance: RBAC dynamic data masking secure views Time Travel
Data Sharing: Cross-account sharing secure data marketplaces

Python Pipeline Mastery

ETL/ELT: Snowpark DataFrames Python stored procedures external functions
Integration: Snowflake Connector Pandas optimization Arrow serialization
Automation: Dynamic warehouse sizing query tagging resource monitors
Validation: Great Expectations integration reconciliation logic

Production Impact

Query Optimization: 100x performance gains through clustering materialized views
Pipeline Reliability: 99.99% success rate across 10K daily jobs
Cost Management: 40% credit reduction through warehouse autoscaling query pruning
Data Freshness: < 15min SLA from source to Snowflake analytics

Required Expertise (8-12 years total 4 Snowflake)

Snowflake: Virtual warehouses Snowpark Python streams/tasks clustering mastery
Python: Snowpark DataFrames pandas optimization multiprocessing logging
SQL: Window functions lateral joins query profiles result caching
Cloud: AWS S3/Glue Azure Data Factory integration
DevOps: Git branching CI/CD via GitHub Actions dbt deployment
Orchestration: Airflow DAGs Snowflake Tasks Azure Data Factory

Role: Senior Snowflake Developer - Python Data Architect. Location: Toronto ON (Onsite). Duration: Long Term Contract. Job Overview Design and own enterprise Snowflake platforms processing petabyte-scale analytics workloads. This senior role architects data models optimizes query performance at s...