Role : Azure Data Engineer
Exp : 6+ Years
Location : Pune / Gurugram (Hybrid)
About the Role :
Azure Data Engineer with Property & Casualty Insurance Domain.
Key Responsibilities :
- Design and develop ETL / ELT pipelines using Azure Data Factory, Snowflake, and DBT.
- Build and maintain data integration workflows from various data sources to Snowflake.
- Write efficient and optimized SQL queries for data extraction and transformation.
- Work with stakeholders to understand business requirements— especially within insurance processes such as policy, claims, underwriting, billing, and customer data —and translate them into technical solutions.
- Monitor, troubleshoot, and optimize data pipelines for performance and reliability.
- Maintain and enforce data quality, governance, and documentation standards.
- Collaborate with data analysts, architects, and DevOps teams in a cloud-native environment.
Must-Have Skills :
Strong experience with Azure Cloud Platform services.Proven expertise in Azure Data Factory (ADF) for orchestrating and automating data pipelines.Proficiency in SQL for data analysis and transformation.Hands-on experience with Snowflake and SnowSQL for data warehousing.Practical knowledge of DBT (Data Build Tool) for transforming data in the warehouse.Experience working in cloud-based data environments with large-scale datasets.Mandatory : Strong insurance domain knowledge, including understanding of policy administration, claims processing, underwriting workflows, actuarial data, and regulatory / compliance standards (e.g., IRDAI, HIPAA where applicable).
Good-to-Have Skills :
Experience with DataStage, Netezza, Azure Data Lake, Azure Synapse, or Azure Functions.Familiarity with Python or PySpark for custom data transformations.Understanding of CI / CD pipelines and DevOps for data workflows.Exposure to data governance, metadata management, or data catalog tools.Knowledge of business intelligence tools (e.g., Power BI, Tableau).Qualifications :
Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field.6+ years of experience in data engineering roles using Azure and Snowflake.Strong problem-solving, communication, and collaboration skills.