Hirejobs Canada
Register
Auckland Jobs
Canterbury Jobs
Northland Jobs
Otago Jobs
Southland Jobs
Tasman Jobs
Wellington Jobs
West Coast Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Senior Cloud Data Warehouse Engineer - Jobs in Montreal

Job LocationMontreal
EducationNot Mentioned
SalaryNot Mentioned
IndustryNot Mentioned
Functional AreaNot Mentioned
Job TypeFull time

Job Description

Job DescriptionJob Description 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 QAamp; 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 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 is 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 with a Proven ability to manage multiple, concurrent projects with minimal supervision and can manage a complex ever changing priority list and resolve conflicts to competing priorities.
  • Strong problem-solving skills with an ability to identify where focus is needed and bring clarity to business objectives, requirements, and priorities.

APPLY NOW

© 2021 HireJobsCanada All Rights Reserved