Jobs → Engineering → Synapse Engineer

About the Role The Synapse Engineer builds, optimizes, and maintains the Azure Synapse environment to replace Alteryx workflows. This role focuses on implementing pipelines, SQL transformations, orchestration, and security while collaborating with Data Modelers and Conversion Analysts. Key Responsibilities • Build Synapse pipelines, SQL transformations, datasets, and linked services • Implement transformation experience in Synapse SQL, PySpark, or Data Flows • Utilize Synapse notebooks/pipelines, SQL, Pyspark, ADO for CI/CD and ESP scheduling • Tune performance of dedicated SQL pools through partitioning, indexing, and 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 Data Modellers to ensure accurate implementation of models • Monitor Synapse environments, performance, costs, and autoscaling • Troubleshoot issues across ingestion, transformation, and orchestration phases • Provide architectural guidance and platform best practices Requirements • 5+ years in data engineering with 3+ years in Azure Synapse • Strong T‑SQL, ETL/ELT pipeline development, and workload optimization skills • Experience migrating Alteryx, SSIS, Databricks, or equivalent ETL systems • Knowledge of Delta Lake, Parquet, partitioning, and schema evolution • CI/CD experience in Azure DevOps, Git, and environment promotion