The Role
Builds and optimizes Azure Synapse environments replacing Alteryx workflows. Responsibilities include developing pipelines, SQL transformations, orchestration, CI/CD, security, performance tuning, ADLS optimization, monitoring, troubleshooting, and architectural guidance. The engineer collaborates with data modeling and conversion teams to deliver production-quality migrated workloads.
Summary Generated by Built In
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.
Skills Required
- 5+ years of experience in data engineering
- 3+ years of experience with Azure Synapse
- Strong T-SQL skills
- ETL/ELT pipeline development experience
- Workload optimization experience
- Experience migrating Alteryx, SSIS, Databricks, or equivalent ETL systems
- Knowledge of Delta Lake, Parquet, partitioning, and schema evolution
- CI/CD experience with Azure DevOps, Git, and environment promotion
- Experience with retail or loyalty analytics workloads
- Familiarity with Azure Purview or similar governance solutions
Ness Digital Engineering Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Ness Digital Engineering and has not been reviewed or approved by Ness Digital Engineering.
-
Healthcare Strength — Healthcare coverage is often positioned as comprehensive, with medical and dental described as strong in North America. Wellness programs are also emphasized as part of the core package.
-
Flexible Benefits — Flexible or remote work options are frequently highlighted as part of the overall rewards experience. Learning and upskilling support is repeatedly framed as a meaningful benefit tied to the employee value proposition.
-
Fair & Transparent Compensation — Pay is characterized as generally “okay to good,” with stronger packages appearing for certain senior roles and some U.S. positions. This suggests compensation can be market-aligned when role level and geography are favorable.
Ness Digital Engineering Insights
What's It Like to Work at Ness Digital Engineering?
Ness Digital Engineering Culture & Values
Ness Digital Engineering Career Growth & Development
What's the Work-Life Balance Like at Ness Digital Engineering?
Ness Digital Engineering Leadership & Management
Ness Digital Engineering Company Growth, Stability & Outlook
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Ness Digital Engineering, acquired by global investment firm KKR in 2022, is a full-lifecycle digital engineering firm offering digital advisory through scaled engineering services. Headquartered in New York, Ness serves our customers across 11 innovation hubs in the US, Eastern Europe, and India. Combining our core competence in engineering with the latest in digital strategy and technology, we seamlessly manage Digital Transformation journeys from strategy through execution to help businesses thrive in the digital economy. For more information, visit www.ness.com
