Azure Data Engineer - Synapse Analytics

Job Summary :

Key Responsibilities :

- Implement data ingestion, transformation, and integration processes from diverse on-premises and cloud-based sources.

- Configure and manage Azure resources including storage accounts, databases, and compute services.

- Develop and optimize SQL scripts, stored procedures, and views for data transformation,

analytics, and reporting.

- Ensure compliance with data quality, governance, and security standards using Azure Purview, Key Vault, and Role-Based Access Control (RBAC).

- Collaborate with Data Scientists, BI Developers, and other stakeholders to deliver end-to-end data solutions.

- Monitor, troubleshoot, and resolve pipeline failures and performance issues.

- Document technical designs, implementation details, and maintain best practices.

Technical Skills Required :

- Azure Data Factory (ADF) : Expertise in pipelines, triggers, linked services, and data flows.

modeling.

- Azure Databricks (Spark/PySpark) : Hands-on experience in large-scale data processing.

- Azure Data Lake (Gen2) storage and data organization best practices.

- Strong proficiency in SQL, T-SQL, query optimization, and performance tuning.

- Experience with ETL/ELT frameworks and data modeling (Star/Snowflake schema).

- Familiarity with Azure SQL, Cosmos DB, and SQL Server.

- CI/CD implementation using Azure DevOps; familiarity with Git, ARM templates, Terraform is a plus.

- Exposure to Power BI integration is an advantage.

Soft Skills & Additional Qualifications :

- Strong analytical and problem-solving skills.

- Ability to work independently and mentor junior team members.

- Preferred Certification : Microsoft Certified : Azure Data Engineer Associate (DP-203) or

equivalent