Overview
Skills
Job Details
JOB: Senior Cloud Data Warehouse Engineer
EXPERIENCE : 10 Years
LOCATION: Montreal 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.)