Job Title Senior Cloud Data Warehouse Engineer

Work Location Montreal, Quebec, Canada (Day 1 onboarding onsite /in-office presence required 3x/week)

KEY RESPONSIBILITIES:

• To design, develop, and manage our Snowflake 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.

SKILLS / QUALIFICATIONS:

• Bachelor's degree in Computer Science, Software Engineering, Information Technology, or 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 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.

• Snowflake SnowPro Core a must

• Snowflake SnowPro Advanced Architect and Advanced Data Engineer a plus.

• Hands on experience with DBT a plus.

• 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.) a plus.

• Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions.

• Strong communication skills both verbal and written. Capable of collaborating effectively across a variety of IT and Business groups, across regions, roles and able to interact effectively with all levels.

• Self-starter. Proven ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to competing priorities.

• Strong problem-solving skills. Ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities.