Azure Synapse Data Engineer (Alteryx Migration)
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Hi,
Role : Synapse Engineer
Location : Toronto hybrid (4 days a week)
Contract
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.
Nagendar Mula
Talent Acquisition Lead
www.cyberspaceinc.com
https://www.linkedin.com/in/nagendar-goud-38680ba6/
33 Wood Ave, Suite 419, Iselin, NJ 08830, USA
4300 Punjab Way, Suite 280, Frisco, TX 75033, USA
More about this job
Responsibilities
Build, optimize, and maintain Azure Synapse pipelines and SQL transformations to migrate and run Alteryx workflows, including orchestration, security, and performance tuning. Collaborate with data modeling and conversion teams, monitor platform performance and costs, troubleshoot workloads, and provide architectural guidance.
Requirements
Requires 5+ years of data engineering experience, including 3+ years with Azure Synapse, strong T-SQL and ETL/ELT development skills, and workload optimization experience. Candidates should have experience migrating ETL systems such as Alteryx, SSIS, or Databricks, and knowledge of Delta Lake, Parquet, partitioning, schema evolution, and CI/CD.
Skills
- Azure Synapse
- T-SQL
- ETL/ELT Pipeline Development
- Synapse Pipelines
- SQL Transformations
- PySpark
- Azure Data Flows
- Azure DevOps
- Git
- CI/CD
- Dedicated SQL Pool Optimization
- Data Security
- Row-Level Security
- ADLS Gen2
- Delta Lake
- Parquet
Visa sponsorship
Not detected in the job text
Hiring contact
Nagendar Mula
Categories
- Data & Analytics
- Technology
- Software
Keywords
- Azure Synapse
- Alteryx Migration
- Synapse Pipelines
- T-SQL
- PySpark
- Azure Data Flows
- Azure DevOps
- GitHub
- CI/CD
- ETL
- ELT
- Dedicated SQL Pools
- Partitioning
- Indexing
- Caching
- Data Security
- Row-Level Security
- Auditing
- ADLS Gen2
- Delta Lake
- Parquet
- Schema Evolution
- SSIS
- Databricks
- Azure Purview
- Data Modeling
- Workload Optimization
- Environment Promotion
- Retail Analytics
- Loyalty Analytics