SeniorSynapseEngineer

## Accountabilities In this role, you will design, implement, and optimize Azure Synapse-based data solutions, ensuring efficient migration of legacy workflows and high-quality data processing at scale. Build and maintain Azure Synapse pipelines, SQL transformations, datasets, and integration components to support enterprise data workflows. Translate legacy Alteryx and ETL logic into scalable Synapse solutions using SQL, PySpark, and data flow technologies. Optimize performance of dedicated SQL pools through tuning strategies such as partitioning, indexing, caching, and workload management. Design and implement CI/CD pipelines using Azure DevOps or Git-based workflows to support automated deployments. Manage data security, including role-based access control (RBAC), row-level security, auditing, and compliance requirements. Optimize data lake structures in ADLS Gen2, including file formats such as Delta and Parquet for efficient storage and processing. Monitor system performance, costs, and scalability while troubleshooting issues across ingestion, transformation, and orchestration layers. Collaborate closely with data modeling and analytics teams to ensure accurate implementation of business and technical requirements. Provide architectural guidance and promote best practices for Synapse platform usage and data engineering standards. Requirements The ideal candidate brings deep data engineering expertise with strong experience in Azure Synapse and modern cloud data platform architecture. 8+ years of experience in data engineering or related roles, including at least 3+ years working with Azure Synapse. Strong expertise in SQL (T-SQL), ETL/ELT pipeline development, and data transformation at scale. Proven experience migrating or modernizing ETL systems such as Alteryx, SSIS, or Databricks. Solid understanding of cloud data architecture concepts, including Delta Lake, Parquet, partitioning, and schema evolution. Hands-on experience with CI/CD pipelines using Azure De