Senior Data Engineer

HRBrain

CONTRACT
Canada
Posted 3 weeks ago

We are looking for a Senior Data Engineer! Reach out if you are interested and feel free to refer friends/colleagues!

 

Type of Employment: Contract
Title: Senior Data Engineer
Term: 6-month contract – 40 hours
Location: Toronto – Hybrid, on-site 2 days a week
Job ID number: C1009

 

Brief description of duties:

 

The Senior Data Engineer will build and support the cloud-based infrastructure for the data pipeline, including maintenance, improvement, cleansing, and manipulation of data and analytics across IMCO’s development and data platforms.  The Senior Data Engineer will be a collaborative expert in data warehousing that can drive solutions while working closely with data architects, business systems analysts, data management teams, and business stakeholders to analyze, design, and implement data-driven solutions for IMCO

The role will involve a key member in the Data Program initiative to build the Core Investment Data warehouse, working closely with the Data Architect on design and ETL development.

 

Responsibilities:

  • Contribute to designing and implementation of data architecture and technology infrastructure for new data and analytics platform with Azure data stack
  • Design and build scalable ETL workflows for all data ingestion into the data platform
  • Design and build complex SQL
  • Build dimensional data model and data warehouse

 

 

MUST haves:

  • 7+ years of experience in data warehousing: data ingestion, transformation and ETL patterns using modern data pipelines.
  • Experience with cloud data platforms with Azure data solutions including
    • Data Factory
    • Azure Databricks
    • Azure Analysis Service
    • Azure Synapse
  • Experience building data warehouse solutions using Dimensional base design (Star/Snowflake)
  • Writing complex SQL queries, views, and procedures
  • Strong understanding of relational and dimensional data modeling concepts
  • Strong communication

 

Nice to haves:

 

  • PowerBI/DAX
  • Capital Markets, Investments, Banking

 

Job Features

Job CategoryData Engineer
Data Engineering7+
Data Warehousing7+
Azure Data Solutions7+

Apply Online