Azure Synapse Data Engineer

1 day ago

Winnipeg MB, Winnipeg Census Division, MB; Manitoba, Canada Gala Solutions Full-time
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 transformationsTune dedicated SQL pools through partitioning, indexing, and cachingImplement CI/CD pipelines using Azure DevOps or GitHubConfigure security, RLS, access roles, and auditingMonitor performance, costs, autoscaling, and troubleshooting across phasesRequirements:
Five-plus years in data engineeringThree-plus years working with Azure SynapseStrong T-SQL, ETL/ELT development, and workload optimizationExperience migrating Alteryx, SSIS, Databricks, or equivalent systemsKnowledge of Delta Lake, Parquet, partitioning, and schema evolutionApply Azure Synapse, PySpark, T-SQL, security, and CI/CD expertise to modernize Alteryx workloads in Toronto.
#J-18808-Ljbffr