Senior Cloud Data Warehouse Engineer-Full Time

Vaiticka Solution; Montreal; Hybrid; CAD 90,000 - 95,000; Full time

Job summary

A leading company in Canada seeks a Senior Cloud Data Warehouse Engineer to join their C3 Data Warehouse team. The role involves developing data solutions on Snowflake and integrating complex data from various systems for reporting and analytics. Candidates should have a robust technical background, strong problem-solving skills, and the ability to work in hybrid environments.

Qualifications

• At least 10 years of experience in data development.
• 7+ years of SQL / PLSQL experience.
• 5+ years of experience with Snowflake.

Responsibilities

• Build next-gen data platform for sourcing and storing data.
• Develop data solutions in a hybrid environment.
• Collaborate with IT and business groups.

Skills

ETL

ELT

Data Warehouse

Snowflake

Python

Airflow

SQL

Problem-solving skills

Communication

Education

Bachelor's degree in Computer Science

Tools

Snowflake

Airflow

DBT

Job description

Senior Cloud Data Warehouse Engineer-Full Time

Direct message the job poster from Vaiticka Solution

SR US IT RECRUITER AT Vaiticka Solutions.#Talksaboutrecruitment #Coreitrecruitmentspecialist#usrecruitment#EndtoEndrecruitment #Alwayshiring

Senior Cloud Data Warehouse Engineer

Montreal, QC

Full Time

Info

• Mode of Interview : Virtual (4 technical rounds)
• HYBRID : 3 days / week onsite (Relocation from Day-01 is required)
• Salary : $90K to $95K (don’t hold any good profiles because of the salary)
• Client : Large Investment Bank in Montreal

Pointers

• Strong ETL / ELT experience.
• Exp. 7+ years.
• Data Warehouse / DWH.
• Snowflake.
• Consulting Background preferred.

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.

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 must.
• Hands on experience with Airflow (or similar tools like Dagster) a must .
• Snowflake SnowPro Certification is a must.
• Snowflake SnowPro Advanced Architect and Advanced Data Engineer a plus.
• Hands on experience with DBT a plus.
• Experience with performance tuning SQL, 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 skills including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions.
• Strong communication 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, ability to manage multiple, concurrent projects with minimal supervision. Can manage a complex ever changing priority list and resolve conflicts to priorities.
• Strong problem-solving skills Ability to identif

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

IT Services and IT Consulting

Referrals increase your chances of interviewing at Vaiticka Solution by 2x

Data Engineer, Digital & Artificial Intelligence Department

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr

Create a job alert for this search

Cloud Data Warehouse • Montreal, Montreal (administrative region), Canada