Azure Data Engineer - ETL, SQL

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A technology solutions provider in Toronto, Ontario is seeking an Azure Data Engineer specializing in ETL and cloud-based data solutions. The role requires 6-8 years of experience and involves designing and maintaining robust data workflows, developing T-SQL solutions, and managing large SQL data marts. Ideal candidates will have deep expertise in Azure data technologies and excellent problem-solving skills. Join a dynamic team dedicated to tackling complex data challenges and leveraging advanced technologies.

Qualifications

• Minimum 6-8 years of experience in data engineering, with deep expertise in ETL processes.
• Expert-level knowledge of relational databases and large SQL data marts.
• Strong analytical skills and problem-solving abilities.

Responsibilities

• Design and maintain enterprise-level data solutions focused on ETL workflows.
• Develop T-SQL programming solutions using Azure Data Factory and Python.
• Manage database security, performance tuning, and capacity planning.

Skills

Data Engineer

Python

ETL

T-SQL

Database Security

Tools

Azure Data Factory

Synapse

Databricks

Tableau

.NET

Job description

6–8 years (with minimum 8 years noted for several responsibilities)

Job Description

Job Title: Azure Data Engineer - ETL, Azure

Experience Required

• 6–8 years (with minimum 8 years noted for several responsibilities)

Role Description

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