Job Title: Senior Cloud Data Warehouse Engineer

Experience: 10 years

Location: Montreal, Quebec, Canada

Skills: 10 years of experience in data development and solutions in highly complex data environments with large data volumes.

7 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis.

5 years of experience with developing data solutions on Snowflake.

3 years of data pipelines and data warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.

3 years of experience developing solutions in a hybrid data environment (on-Prem and Cloud)

Hands on experience with Python, Airflow (or similar tools like Dagster), DBT, Snowflake SnowPro Core, Snowflake SnowPro Advanced Architect and Advanced Data Engineer

Experience with performance tuning SQL queries, Spark job, and stored procedures.

An understanding of E-R data models (conceptual, logical, and physical).

Understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal Bi-Temporal models, etc.)