Senior Snowflake Developer (Python)

Themesoft Inc.; Toronto; Hybrid; CAD 120,000 - 150,000; Full time

Job summary

A technology solutions provider is seeking a Senior Snowflake Developer to join their Toronto team in a hybrid capacity. The successful candidate will design, develop, and optimize data solutions using Snowflake and Python, ensuring performance and reliability. Candidates should have extensive data engineering experience, strong expertise in SQL, and the ability to collaborate across teams. The position offers a long-term contract with opportunities for growth in a dynamic environment.

Qualifications

• Strong hands-on experience with Snowflake.
• Advanced proficiency in Python.
• Strong SQL expertise, including complex queries.

Responsibilities

• Design and maintain Snowflake data warehouses.
• Develop ETL/ELT pipelines using Python.
• Optimize query performance and manage data governance.

Skills

Snowflake

Python

SQL expertise

Data warehousing principles

Education

Bachelor’s or Master’s degree in Computer Science

Tools

Airflow

Azure Data Factory

Job description

Themesoft Inc. is a global IT solutions provider and a Woman‑Owned Minority Business Enterprise headquartered in Dallas, TX. With a strong presence across the US, Canada, India, Singapore, and Brazil, we specialize in digital transformation, consulting, and workforce solutions across diverse industries.

We are currently looking for a tech‑savvy and results‑driven professional for one of our leading clients. If you’re passionate about technology and looking to grow in a dynamic, fast‑paced environment, this could be the perfect fit for you!

Job Title: Senior Snowflake Developer (Python)

Toronto, ON / Hybrid

Long term Contract

Experience

8–12 years overall data engineering experience, with 4+ years on Snowflake

Job Summary

We are seeking a Senior Snowflake Developer with strong Python experience to design, develop, and optimize scalable cloud‑based data solutions. The ideal candidate will have deep expertise in Snowflake architecture, data modeling, and performance optimization, along with hands‑on experience building data pipelines and automation using Python. This role involves close collaboration with data engineers, analysts, and business stakeholders to deliver reliable, high‑performance analytics solutions.

Key Responsibilities

Snowflake Development & Architecture

• Design, develop, and maintain Snowflake data warehouses, schemas, and data models
• Implement and manage Snowflake objects including databases, schemas, tables, views, streams, and tasks
• Optimize query performance, clustering, and warehouse sizing
• Implement data sharing, time travel, and zero‑copy cloning features
• Ensure best practices for security, role‑based access control (RBAC), and data governance
• Develop and maintain ETL/ELT pipelines using Python
• Integrate Snowflake with Python frameworks and libraries (e.g., Pandas, Snowflake Connector, Snowpark)
• Build reusable Python modules for data validation, transformation, and automation
• Implement error handling, logging, and monitoring for data pipelines

Data Integration & Orchestration

• Integrate data from multiple sources (RDBMS, APIs, flat files, cloud storage)
• Work with orchestration tools such as Airflow, Azure Data Factory, or similar
• Implement CI/CD pipelines for data workloads

Performance, Quality & Reliability

• Troubleshoot data issues and optimize pipeline reliability
• Implement data quality checks and reconciliation processes
• Monitor Snowflake usage and manage cost optimization
• Collaborate with data analysts, data scientists, and business teams
• Provide technical guidance and mentorship to junior developers
• Participate in architecture reviews and technical decision‑making
• Document technical designs, data models, and operational procedures

Required Skills & Qualifications

Technical Skills

• Strong hands‑on experience with Snowflake
• Advanced proficiency in Python
• Strong SQL expertise, including complex queries and performance tuning
• Experience with Snowflake Snowpark (Python) is a strong plus
• Knowledge of ETL/ELT concepts and data warehousing principles
• Experience with cloud platforms (AWS, Azure, or GCP)
• Familiarity with version control tools (Git, Bitbucket, etc.)

Preferred Skills

• Experience with Airflow, dbt, or similar data tools
• Knowledge of data governance, metadata management, and security best practices
• Exposure to DevOps / CI‑CD practices for data platforms
• Experience in Agile/Scrum environments

Education

• Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, or a related field

Soft Skills

• Strong analytical and problem‑solving skills
• Excellent communication and stakeholder management abilities
• Ability to work independently and in a collaborative team environment
• Proactive mindset with attention to detail

Nice to Have

• Experience with real‑time or near‑real‑time data processing
• Exposure to data visualization tools (Power BI, Tableau, Looker)