Title: Subcontractor
Area(s) of responsibility
Key Responsibilities
Azure Synapse & Data Engineering
- Design, develop, and optimize solutions using Azure Synapse Analytics.
- Build and maintain data integration solutions using Azure Data Factory (ADF) and Synapse Pipelines.
- Design and implement scalable Data Lake architectures (ADLS Gen2).
- Develop high-performance ETL/ELT frameworks for enterprise data platforms.
- Monitor and troubleshoot large-scale data ingestion, transformation, and processing workloads.
- Identify performance bottlenecks and implement optimization strategies across data movement and transformation processes.
- Ensure data quality, availability, and reliability across analytics ecosystems. These responsibilities align with internally referenced practices around data warehousing, ETL optimization, data lakes, and Synapse performance tuning. [25543668-c...3291332387 | Word]
SQL & Data Warehouse Performance
- Perform advanced SQL query analysis and optimization.
- Analyze and optimize execution plans for complex analytical workloads.
- Configure and tune Synapse Dedicated SQL Pools.
- Design and implement efficient partitioning strategies for large datasets.
- Optimize indexing, statistics, and workload distribution.