Snowflake Developer

ITC Infotech is looking for Snowflake Developer with AI/ML enablement experience to join our team in Vancouver.

About Us:

ITC Infotech is a leading global technology services and solutions provider, led by Business and Technology Consulting. ITC Infotech provides business-friendly solutions to help clients succeed and be future-ready, by seamlessly bringing together digital expertise, strong industry specific alliances and the unique ability to leverage deep domain expertise from ITC Group businesses. We provide technology solutions and services to enterprises across industries such as Banking & Financial Services, Healthcare, Manufacturing, Consumer Goods, Travel and Hospitality, through a combination of traditional and newer business models, as a long-term sustainable partner.

Role Summary:

We are seeking a highly skilled Snowflake Developer AI/ML Enablement with strong data engineering expertise and hands-on experience in building AI-ready data platforms. The role focuses on designing, developing, and optimizing scalable Snowflake-based data solutions, supporting batch, near-real-time, and streaming workloads, and enabling advanced analytics and AI/ML use cases.

Mandatory Domain Requirement: Strong Retail domain knowledge, with hands-on understanding of Merchandising and Planning data, processes, and KPIs.

Key Responsibilities

Snowflake Development & Data Modeling

• Design, develop, and maintain Snowflake data models to meet business and analytics requirements.
• Implement dimensional models (Star, Snowflake) and advanced patterns such as Data Vault where applicable.
• Collaborate with data architects to ensure scalable, efficient, and cost-optimized database structures.
• Apply best practices for data loading, clustering, partitioning, and indexing.

ETL / ELT & Data Pipelines

• Develop and maintain ELT pipelines to ingest, transform, and curate data in Snowflake.
• Leverage Snowflake-native capabilities such as Snowpipe, Streams, Tasks, and Dynamic Tables.
• Build pipelines supporting both batch and near-real-time processing.
• Ensure data quality, reconciliation, and accuracy through validation and automated checks.

SQL Development & Performance Optimization

• Write, test, and optimize complex SQL queries for data retrieval, transformation, and analytics.
• Perform performance tuning of queries, warehouses, and workloads to improve efficiency and reduce cost.
• Conduct root cause analysis for performance bottlenecks and data issues.

Workflow Orchestration (Apache Airflow)

• Design, develop, and maintain Apache Airflow DAGs for batch and hybrid pipelines.
• Implement dependency management, retries, alerting, SLA monitoring, and failure recovery.
• Orchestrate Snowflake jobs, ML workflows, and downstream analytics processes.

Streaming & Event-Driven Data (Kafka)

• Design and support Kafka-based ingestion pipelines into Snowflake.
• Handle event ordering, late-arriving data, reprocessing, and replay scenarios.
• Manage schema evolution and data contracts for streaming use cases.
• Integrate Kafka with Snowflake using Snowpipe Streaming or Kafka connectors.

AI / ML Enablement on Snowflake

• Prepare, curate, and manage datasets for machine learning and advanced analytics.
• Implement ML workflows using Snowpark (Python) and Snowflake ML.
• Support feature engineering, model training, inference, and evaluation.
• Enable AI-driven retail use cases such as demand forecasting, assortment optimization, anomaly detection, and recommendations.

Integration, Automation & DevOps

• Integrate Snowflake with APIs, cloud storage, BI tools, and streaming platforms.
• Implement CI/CD pipelines for SQL, Python, and Airflow deployments.
• Support automated testing, version control, and release management.

Security, Governance & Reliability

• Implement RBAC, masking policies, row/column-level security, and secure data sharing.
• Ensure compliance with data governance, privacy, and audit requirements.
• Monitor pipelines, manage failures, and support data reprocessing.
• Maintain technical documentation and operational runbooks.

Agile Delivery

• Actively participate in Agile/Scrum ceremonies including sprint planning, stand-ups, reviews, and retrospectives.
• Collaborate closely with business stakeholders, product owners, and cross-functional teams.

Required Skills & Experience

Must-Have:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 3 10+ years of experience in Data engineering or analytics engineering.
• Proven hands-on experience as a Snowflake Developer or similar role.
• Advanced SQL skills and strong understanding of relational database concepts.
• Experience with Snowflake features: Snowpipe, Streams, Tasks, Dynamic Tables.
• Strong experience with Apache Airflow (DAG design, monitoring, troubleshooting).
• Experience with Kafka or event-driven/streaming architectures.
• Proficiency in Snowpark (Python).
• Solid understanding of data warehousing principles and best practices.
• Working knowledge of AI/ML fundamentals (feature engineering, training, inference).
• Mandatory Retail domain expertise, especially in Merchandising and Planning.
• Excellent problem-solving, analytical, and communication skills.

Good-to-Have / Preferred

• Snowflake Certification.
• Experience with Snowflake ML, Cortex, or AI functions.
• Knowledge of Python ML libraries (pandas, numpy, scikit-learn).
• Experience with BI tools (Power BI, Tableau, Looker).
• Exposure to real-time analytics or streaming-heavy platforms.
• Knowledge of cloud platforms (AWS, Azure, or Google Cloud Platform).
• Understanding of data security, encryption, and governance in Snowflake.
• Exposure to MLOps practices.

Salary Details:
CAD 105,000 - CAD 130,000 per annum as Base + benefits

ITC Infotech is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. ITC infotech is committed to providing veteran employment opportunities to our service men and women.