Back to Jobs
Recently postedTechnology

Job Title: Azure ETL Engineer – Synapse Analytics & Strong SQL

Pebal Bright Technologies LLCChicago, IL🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationChicago, IL, United States
SQLT-SQLApache SparkETLApacheDatabricksPythonAzurePower BICI/CDAzure DevOpsAzure Data Factory

Job description

Job Title: Azure ETL Engineer – Synapse Analytics & Strong SQL
Chicago, IL Onsite
Final round interview F2F
Job Summary
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.
Key Responsibilities
  • 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.
Required Technical Skills
  • 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.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs