Quick Summary
Overview
Job Description / Role Summary The Senior Synapse Engineer (Remote) builds, optimizes, and maintains the Azure Synapse environment used to replace Alteryx workflows. The role implements pipelines,
Technical Tools
OtherEngineer
Job Description / Role Summary
The Senior 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.
Location & Eligibility
Where is the job
Ontario, Canada
Remote within one country
Who can apply
CA
Listing Details
- Posted
- September 10, 2026
- First seen
- September 26, 2026
- Last seen
- September 28, 2026
Posting Health
- Days active
- 2
- Repost count
- 0
- Trust Level
- 32%
- Scored at
- September 28, 2026
Signal breakdown
freshnesssource trustcontent trustemployer trust
External application
Newsletter
Stay ahead of the market
Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.
A
B
C
D
No spam. Unsubscribe at any time.