Posted 5 days ago
Synapse Engineer
@ Cyber Space Technologies LLC
Toronto, Ontario
Overview
Canadian Tire is hiring a Synapse Engineer on a contract basis for a hybrid role based in Toronto, with four days a week on site. The engineer builds, optimizes and maintains the Azure Synapse environment that replaces Alteryx workflows, covering pipelines, SQL transformations, orchestration and security. Candidates need 5+ years in data engineering, including 3+ years in Azure Synapse.
Responsibilities:
- Build Synapse pipelines, SQL transformations and linked services
- Tune dedicated SQL pool performance
- Implement CI/CD pipelines in Azure DevOps or GitHub
- Configure data security, RLS and auditing
- Troubleshoot ingestion, transformation and orchestration issues
Requirements summary:
- 5+ years in data engineering, 3+ in Azure Synapse
- Strong T-SQL and ETL/ELT pipeline development
- Experience migrating Alteryx, SSIS or Databricks
- Knowledge of Delta Lake, Parquet and partitioning
- CI/CD experience in Azure DevOps and Git
Tools & skills
Source and dates
Source type not verified · apify-linkedin
- Employer posting date
- 2026-11-05
- First seen by our source
- 2026-11-10
- Source record updated
- 2026-11-10
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 5+ years |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Cyber Space Technologies LLC
| Field | Value |
|---|---|
| Open jobs on Jobsy | 3 |
Synapse Engineer
Canadian Tire
Toronto hybrid (4 days a week)
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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.