Job Description

Azure Data Engineer Job Description Role: Azure Data Engineer Experience: Minimum 3-5 years Location: Spaze ITech Park, Sector-49, Gurugram Working Days: Monday to Friday (9:00 Am- 6:00 Pm) Joining: < 15 days About Us: Panamoure is UK based group with offshore office in Gurgaon, India. We are known to be the ultimate Business and Technology Change partner for our clients including PE groups and ambitious mid-market businesses. Panamoure is a fast paced and dynamic management consultancy delivering Business and Technology change services to the UKs fastest growing companies. Our ability to deliver exceptional quality to our clients has seen us grow rapidly over the last 36 months and we have ambitious plans to scale substantially further moving forward. As part of this growth we are looking to expand both our UK and India team with bright, ambitious and talented individuals that want to learn and grow with the business. Primary Skills The Azure Data Engineer will be responsible for developing, maintaining, and optimizing data pipelines and SQL databases using Azure Data Factory (ADF), Microsoft Fabrics and other Azure services. The role requires expertise in SQL Server, ETL/ELT processes, and data modeling to support business intelligence and operational applications. The ideal candidate will collaborate with cross-functional teams to deliver reliable, scalable, and high-performing data solutions. Key Responsibilities: · Design, develop, and manage SQL databases , tables , stored procedures , and T-SQL queries . · Develop and maintain Azure Data Factory (ADF) pipelines to automate data ingestion, transformation, and integration. · Build and optimize ETL/ELT processes to transfer data between Azure Data Lake , SQL Server , and other systems. · Design and implement Microsoft Fabric Lake houses for structured and unstructured data storage. · Build scalable ETL/ELT pipelines to move and transform data across Azure Data Lake , SQL Server , and external data sources . · Develop and implement data modeling strategies using star schema , snowflake schema , and dimensional models to support analytics use cases. · Integrate Azure Data Lake Storage (ADLS) with Microsoft Fabric for scalable, secure, and cost-effective data storage. · Monitor, troubleshoot, and optimize data pipelines using Azure Monitor , Log Analytics , and Fabric Monitoring capabilities . · Ensure data integrity, consistency, and security following data governance frameworks such as Azure Purview . · Collaborate with DevOps teams to implement CI/CD pipelines for automated data pipeline deployment. · Utilize Azure Monitor , Log Analytics , and Application Insights for pipeline monitoring and performance optimization. · Stay updated on Azure Data Services and Microsoft Fabric innovations , recommending enhancements for performance and scalability. Desired Candidate Profile: · 4+ years of experience in data engineering with strong expertise in SQL development. · Proficiency in SQL Server , T-SQL , and query optimization techniques . · Hands-on experience with Azure Data Factory (ADF) , Azure Synapse Analytics , and Azure SQL Database . · Solid understanding of ETL/ELT processes , data integration patterns , and data transformation . · Practical experience with Microsoft Fabric components : o Fabric Dataflows for self-service data preparation. o Fabric Lake houses for unified data storage. o Fabric Synapse Real-Time Analytics for streaming data insights. o Fabric Direct Lake mode with Power BI for optimized performance. · Strong understanding of Azure Data Lake Storage (ADLS) for efficient data management. · Proficiency in Python or Scala for data transformation tasks. · Experience with Azure DevOps , Git , and CI/CD pipeline automation . · Knowledge of data governance practices , including data lineage , sensitivity labels , and RBAC . · Experience with Infrastructure-as-Code (IaC) using Terraform or ARM templates . · Understanding of data security protocols like data encryption and network security groups (NSGs) . · Familiarity with streaming services like Azure Event Hub or Kafka is a plus. · Excellent problem-solving, communication , and team collaboration skills. · Azure Data Engineer Associate (DP-203) and Microsoft Fabric Analytics certifications are desirable. What We Offer: · Opportunity to work with modern data architectures and Microsoft Fabric innovations. · Competitive salary and benefits package, tailored to experience and qualifications. · Opportunities for professional growth and development in a supportive and collaborative environment. · A culture that values diversity, creativity, and a commitment to excellence. Benefits and Perks: · Provident Fund · Health Insurance · Flexible Timing · Providing office Lunch How to Apply: Interested candidates should submit their resume along with cover letter to hr@panamoure.com We look forward to adding a skilled Azure Data Engineer to our team! Show more Show less