Remote Azure Synapse Optimization Architect

Sesheng, LLC; United States; Remote; USD 96,000 - 165,000; Full time

Job summary

A consulting firm is seeking an experienced Azure Synapse Optimization Specialist for an urgent high-impact contract. Your role will involve auditing, tuning, and stabilizing a large-scale Azure Synapse environment while leading complex technical projects to ensure performance and cost-efficiency. The ideal candidate will have over 5 years of experience in large-scale data warehousing, including expertise in Azure Synapse and pipeline optimization. The position is fully remote, US-based, and requires immediate availability.

Qualifications

• 5+ years in large-scale data warehousing.
• 3+ years hands-on experience with Azure Synapse.
• Proven record optimizing high-volume data ingestion and CDC pipelines.

Responsibilities

• Evaluate DWU sizing and workload management.
• Refine table designs using advanced distribution strategies.
• Identify and resolve data movement issues.

Skills

Large-scale data warehousing expertise

Hands-on experience with Azure Synapse

Massively Parallel Processing (MPP) concepts

Pipeline Optimization

Consultative Leadership

Tools

Azure Data Factory (ADF)

Azure Storage

Azure Monitor

Job description

A consulting firm is seeking an experienced Azure Synapse Optimization Specialist for an urgent high-impact contract. Your role will involve auditing, tuning, and stabilizing a large-scale Azure Synapse environment while leading complex technical projects to ensure performance and cost-efficiency. The ideal candidate will have over 5 years of experience in large-scale data warehousing, including expertise in Azure Synapse and pipeline optimization. The position is fully remote, US-based, and requires immediate availability.