Lead Azure Data Engineer

We are seeking an experienced Azure Data Engineer + (Commercial Insurance )responsible for designing, developing, and maintaining cloud-based data solutions. The candidate must have strong hands-on expertise in Azure Data Factory and JSON, with the ability to build scalable pipelines and optimize data workflows across Azure services. Key Responsibilities Design, build, and maintain ETL/ELT pipelines using Azure Data Factory (ADF – mandatory). Create and manage ADF pipelines, activities, triggers, linked services, and integration runtimes. Develop and customize JSON-based ADF pipeline definitions (mandatory). Ingest data from diverse sources (SQL, APIs, Blob, ADLS, On-premises) into Azure. Work with Azure services such as Azure SQL Database, Azure Synapse Analytics, ADLS Gen2, Databricks, etc. Implement data transformation logic using Mapping Data Flows, Databricks, or SQL. Optimize data pipelines for performance, reliability, and cost efficiency. Participate in data modeling, validation, quality checks, and CI/CD deployments (Azure DevOps). Troubleshoot pipeline failures, performance bottlenecks, and integration issues. Ensure security best practices including access control, encryption, and monitoring. Required Skills & Qualifications Strong hands-on experience with Azure Data Factory (MANDATORY). Expertise in JSON for pipeline definitions, datasets, and configurations (MANDATORY). Proficiency with Azure cloud data services (Synapse, ADLS, Key Vault, Azure SQL). Solid understanding of ETL/ELT processes and data warehousing principles. Experience with SQL (T-SQL), stored procedures, and query optimization. Familiarity with Git, CI/CD, and Azure DevOps. Strong problem-solving and debugging skills. Good communication and documentation abilities.