Job Title: Azure ETL Engineer - Synapse Analytics & Strong SQL
PEBAL BRIGHT TECHNOLOGIES LLC
Chicago, IL, United States
2 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦