Azure Synapse Engineer
About the role
Senior Synapse engineer Location: Toronto (Hybrid)
Job Description / Role Summar yThe Senior Synapse Engineer builds, optimizes, and maintains the Azure Synapse environment used to replace Alteryx workflows. The role implements pipelines, SQL transformations, orchestration, and security. They work closely with the onsite Data Modeler and Conversion Analyst to ensure end‑to‑end production-quality execution of migrated workloads .Key Responsibilitie sBuild Synapse pipelines, SQL transformations, datasets, and linked services .Translate Alteryx logic into Synapse SQL, PySpark, or Data Flows .Tune performance of dedicated SQL pools (partitioning, indexing, caching) .Implement CI/CD pipelines in Azure DevOps or GitHub .Configure and manage data security, RLS, access roles, and auditing .Optimize ADLS Gen2 folder structures, file formats, and Delta/Parquet usage .Collaborate with the Data Modeller to ensure accurate implementation of models .Monitor Synapse environments, performance, costs, and autoscaling .Troubleshoot issues across ingestion, transformation, orchestration phases .Provide architectural guidance and platform best practices .Required Experienc e8+ years in data engineering with 3+ years in Azure Synapse .Strong T‑SQL, ETL/ELT pipeline development, and workload optimization .Experience migrating Alteryx, SSIS, Databricks, or equivalent ETL systems .Knowledge of Delta Lake, Parquet, partitioning, schema evolution .CI/CD experience in Azure DevOps, Git, environment promotion .Preferred Skill sExperience with retail or loyalty analytics workloads .Familiarity with Azure Purview or similar governance solutions
.
Not the right fit? Search for Azure Synapse Engineer jobs in Toronto, Ontario, Canada
About Gala Solutions
We are happy to talk in detail about our services and how we can assist your business. We specialize in end-to-end solutions for your entire web-related needs. Self-optimizing systems and the need for new ideas powered by intelligent technologies have been a keen interest in meeting the needs of growing customer expectations. We contribute to our client's aspirations by driving real innovation and ideas that transform and grow their organizations.
We offer a wide range of services which include Application Services, Business Consulting, Infrastructure Services, IT Outsourcing Services and System Integration Services, ASIC design services, etc.
We strive to serve our clients by establishing their brand name and developing their portfolio in the market. Continuous profitable growth is a testimony to the confidence of our clients in us. The commitment of our members is to provide exponential growth to shareholders and the best return on their investment.
We systematically rethink how our clients can create an impact on their organizations by analyzing the exceptions of the end customers.
Similar Jobs
Azure Synapse Engineer
About the role
Senior Synapse engineer Location: Toronto (Hybrid)
Job Description / Role Summar yThe Senior Synapse Engineer builds, optimizes, and maintains the Azure Synapse environment used to replace Alteryx workflows. The role implements pipelines, SQL transformations, orchestration, and security. They work closely with the onsite Data Modeler and Conversion Analyst to ensure end‑to‑end production-quality execution of migrated workloads .Key Responsibilitie sBuild Synapse pipelines, SQL transformations, datasets, and linked services .Translate Alteryx logic into Synapse SQL, PySpark, or Data Flows .Tune performance of dedicated SQL pools (partitioning, indexing, caching) .Implement CI/CD pipelines in Azure DevOps or GitHub .Configure and manage data security, RLS, access roles, and auditing .Optimize ADLS Gen2 folder structures, file formats, and Delta/Parquet usage .Collaborate with the Data Modeller to ensure accurate implementation of models .Monitor Synapse environments, performance, costs, and autoscaling .Troubleshoot issues across ingestion, transformation, orchestration phases .Provide architectural guidance and platform best practices .Required Experienc e8+ years in data engineering with 3+ years in Azure Synapse .Strong T‑SQL, ETL/ELT pipeline development, and workload optimization .Experience migrating Alteryx, SSIS, Databricks, or equivalent ETL systems .Knowledge of Delta Lake, Parquet, partitioning, schema evolution .CI/CD experience in Azure DevOps, Git, environment promotion .Preferred Skill sExperience with retail or loyalty analytics workloads .Familiarity with Azure Purview or similar governance solutions
.
Not the right fit? Search for Azure Synapse Engineer jobs in Toronto, Ontario, Canada
About Gala Solutions
We are happy to talk in detail about our services and how we can assist your business. We specialize in end-to-end solutions for your entire web-related needs. Self-optimizing systems and the need for new ideas powered by intelligent technologies have been a keen interest in meeting the needs of growing customer expectations. We contribute to our client's aspirations by driving real innovation and ideas that transform and grow their organizations.
We offer a wide range of services which include Application Services, Business Consulting, Infrastructure Services, IT Outsourcing Services and System Integration Services, ASIC design services, etc.
We strive to serve our clients by establishing their brand name and developing their portfolio in the market. Continuous profitable growth is a testimony to the confidence of our clients in us. The commitment of our members is to provide exponential growth to shareholders and the best return on their investment.
We systematically rethink how our clients can create an impact on their organizations by analyzing the exceptions of the end customers.