Ness Digital Engineering

Senior Synapse Engineer (Remote)

Ness Digital Engineering  •  Ontario, CA (Remote)  •  1 day ago
Apply
Save Job
Mark Applied Mark Interviewed Mark Offered
Hide Job Report Job
AI can make mistakes so check important info. Chat history is never stored.

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.
  • Translate Alteryx logic into Synapse SQL, PySpark, or Data Flows.
  • 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
  • 8+ 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.
Ness Digital Engineering

About Ness Digital Engineering

Ness Digital Engineering is a global provider of Intelligent Data and Software Engineering services, specializing in data, AI, and cloud-powered solutions that drive innovation and deliver measurable business outcomes. With over 25 years of engineering expertise and our proprietary data and software platforms and accelerators, Ness helps enterprises modernize systems, accelerate product development, and achieve scalable impact with speed and precision.

Our differentiation lies at the intersection of Industry domain and Technology. We focus on clients across financial services, technology and ISVs, Media & Entertainment, manufacturing, transportation and retail. Ness is known for its delivery excellence, deep domain knowledge, and product engineering expertise. Ness Digital Engineering is a portfolio company of KKR, a leading global investment firm.

Industry
IT & Software
Company Size
5,001-10,000 employees
Headquarters
New York, NY
Year Founded
1999
Website
ness.com
Social Media