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

PEBAL BRIGHT TECHNOLOGIES LLC
Chicago, IL, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

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
+22 more
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

Job 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.

Requirements

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…