Senior Data Engineer


Posted 8 months 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.



  • 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