Senior Azure Synapse Engineer (Remote) — Data Pipelines

Ness Digital Engineering; United States; Remote; CAD 120,000 - 150,000; Full time

Job summary

Ness Digital Engineering is seeking a Senior Synapse Engineer (Remote) to build, optimize, and maintain the Azure Synapse environment that replaces Alteryx workflows. You will implement pipelines, SQL transformations, orchestration, and security, collaborating with the Data Modeler and Conversion Analyst for production-quality migrated workloads.

The role requires 5+ years in data engineering with 3+ years in Synapse, plus CI/CD experience and knowledge of Delta Lake/Parquet.

Qualifications

• 5+ years in data engineering with 3+ years in Azure Synapse.
• Strong T-SQL, ETL/ELT development, and workload optimization.
• 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, or environment promotion.

Responsibilities

• Build Synapse pipelines, SQL transformations, datasets, and linked services.
• Tune performance of dedicated SQL pools and manage data security.
• Implement CI/CD pipelines in Azure DevOps or GitHub.
• Monitor Synapse environments, costs, and autoscaling.
• Collaborate with Data Modeller to ensure accurate model implementation.

Skills

Azure Synapse

T-SQL

ETL/ELT

CI/CD

Databricks

Tools

Azure DevOps

Git

Delta Lake

Parquet

Job description

Ness Digital Engineering is seeking a Senior Synapse Engineer (Remote) to build, optimize, and maintain the Azure Synapse environment that replaces Alteryx workflows. You will implement pipelines, SQL transformations, orchestration, and security, collaborating with the Data Modeler and Conversion Analyst for production-quality migrated workloads.

The role requires 5+ years in data engineering with 3+ years in Synapse, plus CI/CD experience and knowledge of Delta Lake/Parquet.