Closed listing
Azure Synapse Engineer
- Toronto, ON, Canada
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Job Title:Synapse Engineer
Location: Toronto, ON hybrid (2 days a week)
Duration: 12 Months+
Job Description / Role Summary:
The Synapse Engineer (Remote) 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 Responsibilities:
- Build Synapse pipelines, SQL transformations, datasets, and linked services.
- Transformation exp in Synapse SQL, PySpark, or Data Flows.
- Synapse notebooks/pipelines, SQL, Pyspark, ADO for CI/CD, ESP scheduling
- 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 Experience:
- 5+ 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 Skills:
- Experience with retail or loyalty analytics workloads.
- Familiarity with Azure Purview or similar governance solutions.
More about this job
Responsibilities
The Synapse Engineer builds, optimizes, and maintains Azure Synapse environments to replace legacy workflows. They implement pipelines, SQL transformations, and security measures while collaborating with data modelers to ensure production-quality execution.
Requirements
Candidates must have 5+ years of data engineering experience, including at least 3 years specifically with Azure Synapse. Strong proficiency in T-SQL, ETL/ELT development, and CI/CD practices in Azure DevOps is required.
Skills
- Azure Synapse
- T-SQL
- PySpark
- ETL/ELT
- Data Pipelines
- Azure DevOps
- CI/CD
- Data Modeling
- ADLS Gen2
- Delta Lake
- Parquet
- SQL Transformations
- Performance Tuning
- Data Security
- Autoscaling
- Cloud Architecture
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Engineering
- Retail
Keywords
- Azure Synapse
- Data Engineering
- T-SQL
- ETL
- ELT
- PySpark
- Azure DevOps
- CI/CD
- ADLS Gen2
- Delta Lake
- Parquet
- Data Modeling
- SQL Pools
- Cloud Migration
- Data Security
- Performance Optimization
- Retail Analytics
- Azure Purview
- Orchestration
- Data Transformation
- Git
- Autoscaling
- Data Governance
- Infrastructure
- Workload Optimization