Build Azure Synapse pipelines and SQL transformations in a Toronto hybrid contract requiring four onsite days weekly. Optimize migrated workloads with Synapse, PySpark, and CI/CD expertise.

This Synapse Engineer role supports replacing Alteryx workflows with production-quality Azure Synapse execution. You will implement pipelines, orchestration, security, and transformations using Synapse SQL, PySpark, or Data Flows. Collaboration with the onsite data modeller and conversion analyst supports accurate end-to-end workload migration.

Key Responsibilities

Build Synapse pipelines, datasets, linked services, and SQL transformations

Tune dedicated SQL pools through partitioning, indexing, and caching

Implement CI/CD pipelines using Azure DevOps or GitHub

Configure security,



RLS, access roles, and auditing

Monitor performance, costs, autoscaling, and troubleshooting across phases

Requirements

Five-plus years in data engineering

Three-plus years working with Azure Synapse

Solid T-SQL, ETL/ELT development, and workload optimization

Experience migrating Alteryx, SSIS, Databricks, or equivalent systems

Knowledge of Delta Lake, Parquet, partitioning, and schema evolution

Apply Azure Synapse, PySpark, T-SQL, security, and CI/CD expertise to modernize Alteryx workloads in Toronto.

📌 Azure Synapse Data Engineer (Winnipeg)
🏢 Gala Solutions
📍 Winnipeg