Senior Synapse Engineer

Ness Digital Engineering

. Build Synapse pipelines, SQL transformations, datasets, and linked services .

Posted 9/18/2026full-timeCanadaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and optimizing Azure Synapse pipelines, SQL transformations, and data security management. Proficient in CI/CD implementation and performance tuning for data engineering workloads.

Highest-signal resume keywords

Azure SynapseT-SQLETL/ELT Pipeline DevelopmentCI/CD in Azure DevOpsData Security Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL TransformationsWorkload OptimizationPerformance TuningPartitioningIndexingCachingDelta LakeParquetSchema EvolutionData Ingestion

Soft Skills

CollaborationTroubleshootingArchitectural Guidance

Tools & Technologies

Azure DevOpsGitAlteryxSSISDatabricksAzure Purview

Industry Keywords

Retail AnalyticsLoyalty AnalyticsData Governance

Tech Stack

Tools & technologies

AzureETLSQLSSIS

About the role

Key responsibilities & impact

Build Synapse pipelines, SQL transformations, datasets, and linked services
Implement pipelines, SQL transformations, orchestration, and security
Tune performance of dedicated SQL pools using 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 the Data Modeller 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
Work closely with the onsite Data Modeler and Conversion Analyst to ensure end-to-end production-quality execution of migrated workloads

Requirements

What you’ll need

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, and schema evolution
CI/CD experience in Azure DevOps, Git, and environment promotion
Experience with retail or loyalty analytics workloads (preferred)
Familiarity with Azure Purview or similar governance solutions (preferred)