Azure Synapse Optimization Specialist

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.
• Strong knowledge of Azure Data Factory, Storage, and Monitor.
• Able to lead stakeholders through technical transformations independently.

Responsibilities

• Evaluate DWU sizing and workload management.
• Refine table designs using advanced distribution strategies.
• Identify and resolve data movement issues.
• Capacity planning: develop scaling strategies for initial loads, ongoing CDC pipelines, and concurrent BI workloads.
• Governance & documentation: create actionable runbooks and cost-control frameworks for long-term health.

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

Oracle GoldenGate

Job description

We are seeking a high-level Azure Synapse Optimization Specialist for an urgent, high-impact contract. This role is designed for a self-starting consultant capable of leading a client through complex technical hurdles. Your primary mission is to audit, tune, and stabilize an existing Azure Synapse environment, specifically focusing on large-scale data ingestion and CDC-based replication. You will act as the technical authority to ensure performance, cost-efficiency, and operational stability.

As a subject matter expert, you will diagnose performance bottlenecks and implement architectural refinements within Azure Synapse Dedicated SQL Pools. You will bridge the gap between high-volume data ingestion (specifically Oracle-to-Synapse CDC) and seamless BI reporting.

Key Responsibilities

• Infrastructure Tuning: Evaluate DWU sizing, workload management, and pause/resume automation to balance performance with cost
• Architecture Optimization: Refine table designs using advanced distribution strategies (Hash, Round Robin, Replicated) and partitioning for large-scale fact tables.
• Performance Engineering: Identify and resolve data movement issues, skew, and tempdb pressure; optimize complex joins and aggregations to reduce shuffles.
• Capacity Planning: Develop scaling strategies tailored for initial loads, ongoing CDC pipelines, and concurrent BI workloads.
• Governance & Documentation: Create actionable runbooks and cost-control frameworks to ensure long-term operational health.

Required Experience & Skills

• Expertise: 5+ years in large-scale data warehousing; 3+ years of deep, hands-on experience with Azure Synapse (Dedicated SQL Pools).
• MPP Mastery: Advanced understanding of Massively Parallel Processing (MPP) concepts, including data movement and parallel execution.
• Pipeline Optimization: Proven track record of tuning high-volume data ingestion and Change Data Capture (CDC) pipelines.
• Azure Ecosystem: Proficiency in Azure Data Factory (ADF), Azure Storage, and Azure Monitor.
• Consultative Leadership: Ability to operate independently and lead stakeholders through technical transformations.

Preferred Qualifications

• Experience with Oracle GoldenGate or similar CDC tools.
• Understanding of Power BI concurrency and its impact on Synapse performance.
• Background in regulated or high-availability environments.

Type: Contract.

Location: Remote (US-Based).

Start Date: Immediate.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.