Sr Cloud Data Warehouse Engineer to help a strategic banking client in various data transformation activities

Our valued client is currently seeking a Senior Cloud Data Warehouse Engineer to help a strategic banking client in various data transformation activities.

This position is hybrid - 3 times a week onsite in Montreal.

As a Senior Cloud Data Warehouse Engineer, you will be a member of the Data Warehouse team with a focus on building next-gen data platform used for sourcing and storing data from different technology systems across the firm into a centralized data platform.

Tasks include:

• To design, develop, and manage aSnowflake data warehouse.
• To contribute towards the establishment of best practices for the optimal and efficient usage of Snowflake with tooling like Airflow, DBT and Spark.
• To assist with the testing and deployment of our data pipeline framework utilizing standard testing frameworks and CI/CD tooling.
• To monitor the performance of queries and data loads and perform tuning as necessary.
• To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues.
• Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions.

Must haves:

• Bachelor’s degree in computer science, Software Engineering, Information Technology, or related field required.
• At least 7 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis.
• At least 5 years of experience with developing data solutions on Snowflake.
• At least 3 years of data pipelines and data warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.
• At least 3 years of experience developing solutions in a hybrid data environment (on-Prem and Cloud)
• Hands on experience with Python a must.
• Hands on experience with Airflow (or similar tools like Dagster) a must.
• Experience with Snowflake SnowPro Core
• 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.)

Nice-to-haves:

• Experience in financial services
• Knowledge of regulatory requirements in the financial industry
• Snowflake SnowPro Advanced Architect and Advanced Data Engineer a plus.
• Hands on experience with DBT a plus.