Senior Cloud Data Warehouse Engineer

LanceSoft Inc; Montreal; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A technology solutions firm is seeking a Senior Cloud Data Warehouse Engineer in Montreal. This role involves building a next-gen data platform with a focus on Snowflake and Python. The ideal candidate will have extensive experience in data development, proficiency in SQL, and strong analytical skills to collaborate across teams effectively. This position requires onsite presence three times a week as part of a dynamic work environment.

Qualifications

• 10+ years of experience in data development and solutions.
• 7+ years of experience with SQL/PLSQL.
• 5+ years of experience developing data solutions on Snowflake.
• 3+ years of hybrid data environments experience.
• Hands-on experience with Python and Airflow.

Responsibilities

• Building next-gen data platform using Snowflake.
• Integrating data warehouse with internal platforms.
• Collaborating with various IT and Business groups.

Skills

Data analysis with SQL/PLSQL

Snowflake data solutions

Python data development

Data pipeline creation

Performance tuning

Analytical skills

Project management

Communication skills

Education

Bachelor’s degree in Computer Science or related field

Tools

Snowflake

Python

Airflow

DBT

Job description

Location: Montreal (day 1 onboarding onsite / in-office presence required 3x/week)

Job Description

Role Summary

As a Senior Cloud Data Warehouse Engineer, you will be a member of the C3 Data Warehouse team with a focus on building our next-gen data platform used for sourcing and storing data from different technology systems across the firm into a centralized data platform that empowers various reporting and analytics solutions for the Technology Risk functions within ***. In this role, you will be primarily responsible for contributing to the development of our Cloud Data Warehouse utilizing Snowflake and Python-based tooling. You will also be responsible for the design and development of our data warehouse utilizing Snowflake capabilities such as data sharing, time travel, Snow Park, workload optimization across analytic and AI use-cases, and the ingestion and storage of structured and unstructured data. Additionally, you will work on integrating our Snowflake data warehouse with existing internal platforms for data quality, cataloging, discovery, incident logging, and metric generation. You will collaborate closely with data warehousing leads, data analysts, ETL developers, infrastructure engineers, and data analytics teams to facilitate the implementation of this data platform and pipeline framework.

Skills / Qualifications:

• Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related field required.
• At least 10 years of experience in data development and solutions in highly complex data environments with large data volumes.
• At least 7 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries for data analysis.
• At least 5 years of experience developing data solutions on Snowflake.
• At least 3 years of experience with data pipelines and warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.
• At least 3 years of experience in hybrid data environments (on-Prem and Cloud).
• Hands-on experience with Python is essential.
• Hands-on experience with Airflow (or similar tools like Dagster) is essential.
• Snowflake SnowPro Core certification is required.
• Snowflake SnowPro Advanced Architect and Advanced Data Engineer certifications are a plus.
• Experience with DBT is a plus.
• Experience in performance tuning SQL queries, Spark jobs, and stored procedures.
• Understanding of E-R data models (conceptual, logical, physical).
• Knowledge of advanced data warehouse concepts (Factless Fact Tables, Temporal/Bi-Temporal models) is a plus.
• Strong analytical skills with the ability to interpret business requirements and translate them into technical solutions.
• Excellent communication skills, both verbal and written, with the ability to collaborate across IT and Business groups.
• Self-starter with the ability to manage multiple projects independently.
• Strong problem-solving skills to identify focus areas and clarify business objectives.

#NIT001

*//
EEO Employer: Minorities/Females/Disabled/Veterans/Gender Identity/Sexual Orientation
//*