Senior Data Engineer - AI-Enabled Development, Snowflake, Python, SQL

Data Engineer – AI-Enabled Development, Snowflake, Python, SQL  

Location: Montreal: 3 days a week on-site

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.

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.

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.