Senior Snowflake Developer (Python)

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) #J-18808-Ljbffr