Data & AI Engineer – Snowflake, SQL, Python, Cloud, Generative AI

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Montreal (administrative region); On-site; CAD 90,000 - 130,000; Full time

Job summary

Astra-North Infoteck Inc. seeks a Data & AI Engineer to design and implement scalable data solutions using Snowflake, SQL, and Python. The role focuses on cloud data architectures, data governance, and AI-enabled development with Claude and Copilot to boost productivity and automation.

You will build data pipelines, optimize queries, and collaborate with cross‑functional teams to deliver data-driven outcomes. Relevant Snowflake, cloud, and AI experience are highly valued.

Qualifications

• Strong Snowflake Data Warehouse experience.
• Advanced SQL proficiency for extraction, transformation, and analytics.
• Strong Python skills for data processing and automation.
• Experience with Cloud Platforms (AWS, Azure, GCP).
• Knowledge of AI/Generative AI tools like Claude and Copilot.

Responsibilities

• Design, develop, and optimize data solutions with Snowflake as the primary platform.
• Create and maintain complex SQL queries, views, and data models.
• Develop scalable data processing and automation using Python.
• Build cloud-based data architectures with reliability, security, and performance.
• Collaborate with business and tech teams to deliver data-driven solutions.
• Leverage Claude and Copilot to accelerate development and knowledge management.
• Implement data governance, quality, security, and performance best practices.
• Troubleshoot data-related issues and optimize processes.
• Stay updated on cloud, data engineering, and AI trends.

Skills

Snowflake

SQL

Python

Cloud platforms

AI / Generative AI

ETL/ELT

Data modeling

Data governance

Agile

Communication

Tools

Claude

Microsoft Copilot

Job description

Data & AI Engineer – Snowflake, Python, SQL, Cloud, Generative AI

Job Description:

Role: Data & AI Engineer / Developer

We are seeking a highly skilled Data & AI Engineer with expertise in Snowflake, SQL, Python, Cloud Technologies, and AI-powered development tools. The ideal candidate will have hands‑on experience designing and implementing scalable data solutions, developing data pipelines, and leveraging modern AI platforms such as Claude and Microsoft Copilot to enhance productivity, automation, and business outcomes.

Key Responsibilities

• Design, develop, and optimize data solutions using Snowflake as the primary cloud data platform
• Create and maintain complex SQL queries, stored procedures, views, and data models to support reporting and analytics needs
• Develop scalable data processing, automation, and integration solutions using Python
• Build and manage cloud‑based data architectures, ensuring reliability, security, and performance
• Collaborate with business and technology teams to gather requirements and deliver data‑driven solutions
• Utilize AI technologies, including Claude and Microsoft Copilot, to accelerate development, automate workflows, improve code quality, and enhance knowledge management
• Implement best practices for data governance, data quality, security, and performance optimization
• Troubleshoot and resolve data‑related issues while continuously improving existing processes and solutions
• Stay current with emerging cloud, data engineering, and AI technologies to drive innovation and operational efficiency

Required Skills & Experience

• Strong experience with Snowflake Data Warehouse and related data engineering concepts
• Advanced proficiency in SQL for data extraction, transformation, optimization, and analysis
• Strong programming skills in Python for data processing, automation, scripting, and API integrations
• Experience working with Cloud Platforms such as AWS, Azure, or Google Cloud
• Knowledge of AI/Generative AI technologies and practical experience using tools such as Claude and Microsoft Copilot
• Understanding of data warehousing, ETL/ELT processes, data modeling, and analytics solutions
• Strong analytical, problem‑solving, and communication skills
• Experience working in Agile development environments is preferred

Preferred Qualifications

• Experience integrating AI capabilities into business or data engineering workflows
• Familiarity with machine learning, LLMs, prompt engineering, or AI‑assisted software development
• Relevant certifications in Snowflake, Cloud Platforms, or AI technologies are a plus

Role Summary

The position requires a technology professional who can combine strong data engineering expertise with modern AI-enabled development practices to deliver scalable, secure, and innovative data solutions that drive business value.