> Markdown version of [/jobs/ext/4787048-job-title-azure-etl-engineer-synapse-analytics-strong-sql](https://www.wearedevelopers.com/jobs/ext/4787048-job-title-azure-etl-engineer-synapse-analytics-strong-sql). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Job Title: Azure ETL Engineer - Synapse Analytics & Strong SQL - **Company:** PEBAL BRIGHT TECHNOLOGIES LLC - **Location:** Chicago, IL, United States - **Experience:** Experienced - **Contract:** Contract - **Skills:** Microsoft Azure, Big Data, Cloud Database, Continuous Integration, Data Validation, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Systems, Data Warehousing, Database Queries, Database Theory, Software Debugging, Dimensional Modeling, Python (Programming Language), Performance Tuning, Query Optimization, Power BI, Standard Sql, Azure Data Lake, SQL Stored Procedures, SQL Databases, Transact-SQL, Freeform SQL, Data Ingestion, Azure Data Factory, Sql Optimization, Apache Spark, Microsoft Fabric, Pyspark, Semi-structured Data, Azure Synapse Analytics, Data Pipelines, Databricks - **Published:** November 19, 2026 - **Apply:** https://www.dice.com/job-detail/1e2d75df-2d5d-4c98-a665-75d70c6eaa8a ## About the Role * Strong hands-on experience with Azure Synapse Analytics. * Excellent proficiency in SQL and T-SQL, including complex queries, joins, CTEs, window functions, stored procedures, and query optimisation. * Strong experience in ETL/ELT development and data warehousing concepts. * Hands-on experience with Azure Data Factory and Synapse Pipelines. * Experience working with Azure Data Lake Storage Gen2. * Good understanding of data modelling, dimensional modelling, and database concepts. * Experience handling large volumes of structured and semi-structured data. * Strong debugging, performance tuning, and problem-solving skills. Good to Have * Experience with Azure Databricks. * Knowledge of Python, PySpark, or Apache Spark. * Experience with Microsoft Fabric or Power BI. * Understanding of CI/CD and Azure DevOps. * Knowledge of cloud-based data architecture. Experience * 5-8+ years of overall IT experience. * 3+ years of hands-on experience in Azure Data Engineering. * Strong practical experience in SQL and Azure Synapse Analytics. ## Description We are seeking an experienced Azure ETL Engineer with strong hands-on expertise in Azure Synapse Analytics, advanced SQL, and data integration. The ideal candidate will be responsible for designing, developing, and maintaining scalable ETL/ELT pipelines, transforming large datasets, and delivering high-quality data solutions within the Azure ecosystem., * Design, develop, and maintain ETL/ELT pipelines using Azure Synapse Analytics. * Develop complex SQL queries, stored procedures, views, and performance-optimised data transformations. * Build and manage data pipelines to extract, transform, and load data from multiple source systems. * Work with Azure Data Lake Storage Gen2 for data ingestion and storage. * Implement data transformation and processing using Synapse SQL and Azure services. * Perform data validation, reconciliation, and troubleshooting to ensure data accuracy. * Optimise SQL queries, ETL workflows, and pipeline performance. * Collaborate with data architects, analysts, and business stakeholders to understand data requirements. * Monitor pipeline execution, identify failures, and implement corrective actions. * Ensure data quality, security, and reliability across data engineering solutions.