Role - Data EngineerLocation - Toronto
The Data Engineer will be responsible for designing, developing, and maintaining enterprise level data solutions with a strong focus on cloud-based ETL workflows and large-scale SQL data marts. The ideal candidate will possess deep expertise in data extraction, transformation, and loading processes, as well as advanced proficiency in Azure data technologies.
Key Responsibilities
Demonstrate strong knowledge of ETL (Extraction, Transformation, Loading) processes, utilizing frameworks such as Azure Data Factory, Azure Synapse, or Databricks, including establishing and managing cloud connectivity across systems such as ADLS \| ADF \| Synapse \| Databricks.
Develop and support T SQL programming solutions, leveraging Azure Data Factory frameworks and Python scripting.
Apply a minimum of 8 years of experience working with large SQL data marts, showing expert-level relational database knowledge.
Navigate and analyze massive data volumes to deliver efficient and effective data extraction, design, loading, and reporting solutions for business partners.
Provide at least 8 years of troubleshooting and support for large database environments, including test planning and execution activities.
Identify, report, and manage database security issues, including user access management.
Design and support database backup strategies, archiving, storage management, performance tuning, ETL processing, and capacity planning, including importing large volumes of data from multiple systems.
Experience within financial institution data marts is considered an asset.
Experience with .NET applications is considered an asset.
Experience and expertise in Tableau dashboard design is considered an asset.
Work effectively independently and within a team environment.
Demonstrate a proactive, organized approach with excellent analytical and problem solving skills.
Exhibit flexibility, willingness to learn, and a strong can do attitude.
Display strong verbal and written communication skills.
Essential Skills
Data Engineer
Desirable Skills
Experience with Tableau, .NET applications, financial data marts Advanced ETL and Azure cloud capabilities
Technical Keywords
Azure Data Factory, Synapse, Databricks
ADLS, ETL, SQL Data Marts
Python, T SQL, Database Security, Performance Tuning Tableau (Asset), .NET (Asset)
Skills (Digital)
Python