Lead Data Engineer, Azure – Guidewire

Jobtailor

Gurugram District

On-site

INR 4,500,000 - 7,500,000

Full time

14 days+

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Jobtailor is seeking an experienced Lead Data Engineer in India to architect and oversee scalable ETL/ELT data pipelines using Azure Data Factory, Snowflake, DBT, and related services. You will drive data integration from Guidewire and insurance platforms into cloud environments.

You will analyze Guidewire data models, optimize SQL, mentor the data engineering team, and ensure data quality, governance, and secure operations across CI/CD pipelines in a cloud-native setup.

Qualifications

8+ years of experience in Data Engineering or related roles.
Strong hands-on expertise with the Azure Cloud Platform and Azure data services.
Proven expertise in Azure Data Factory (ADF) for designing, orchestrating, automating, and monitoring complex data pipelines.
Strong experience with Azure Data Lake Storage (ADLS) and cloud-based data integration architectures.
Extensive experience with SQL, including complex queries, performance optimization, and data transformation.
Hands-on experience with Snowflake and SnowSQL for cloud data warehousing and data engineering.
Strong working knowledge of DBT (Data Build Tool) for data transformation, testing, and documentation.
Experience working with insurance domain data, including Guidewire data models and integrations.

Responsibilities

Lead the design and development of scalable ETL/ELT data pipelines.
Design and manage data integration workflows from Guidewire and insurance platforms into Snowflake and Azure environments.
Analyze Guidewire data models and related insurance datasets.
Develop efficient SQL queries for data extraction, transformation, validation, and reporting.
Lead technical discussions with stakeholders to translate requirements into scalable solutions.
Provide technical leadership and review code, data models, and pipeline designs.
Monitor, troubleshoot, and optimize data pipelines for performance and reliability.
Implement and enforce data quality, governance, metadata, lineage, and documentation standards.

Skills

Azure Data Factory

Snowflake

SQL

Guidewire Data Integration

Data Governance

Data Modeling

CI/CD

Education

Bachelor’s Degree in Computer Science

Master’s Degree in Data Engineering

Tools

DBT

Azure Synapse Analytics

Power BI

Tableau

Python

PySpark

Databricks

Job description

Lead the design and development of scalable ETL/ELT data pipelines using Azure Data Factory, Snowflake, DBT, and other Azure data services
Design and manage data integration workflows from multiple source systems, including Guidewire applications and insurance data platforms, into Snowflake and Azure-based data environments
Analyze and understand Guidewire data models, business entities, policy, claims, billing, underwriting, and related insurance datasets
Develop efficient and optimized SQL queries for data extraction, transformation, validation, and reporting
Lead technical discussions with business stakeholders, Guidewire teams, architects, and data consumers to translate business requirements into scalable technical solutions
Provide technical leadership and guidance to data engineering team members and review code, data models, and pipeline designs
Monitor, troubleshoot, and optimize data pipelines to ensure high performance, reliability, scalability, and availability
Implement and enforce data quality, governance, metadata, lineage, and documentation standards
Develop and maintain reusable data engineering frameworks and best practices
Collaborate with data architects, analysts, DevOps, QA, and cloud engineering teams in a cloud-native environment
Support migration and modernization of legacy insurance data platforms into Azure and Snowflake
Implement and support CI/CD processes for data engineering workflows
Ensure data solutions comply with enterprise security, governance, and regulatory requirements

Requirements

8+ years of experience in Data Engineering, Data Integration, or related roles
Strong hands-on experience with the Azure Cloud Platform and Azure data services
Proven expertise in Azure Data Factory (ADF) for designing, orchestrating, automating, and monitoring complex data pipelines
Strong experience with Azure Data Lake Storage (ADLS) and cloud-based data integration architectures
Extensive experience with SQL, including complex queries, performance optimization, and data transformation
Hands-on experience with Snowflake and SnowSQL for cloud data warehousing and data engineering
Strong working knowledge of DBT (Data Build Tool) for data transformation, testing, and documentation
Experience working with large-scale and complex enterprise datasets
Strong understanding of Guidewire InsuranceSuite, Guidewire data models, or Guidewire-based data integrations
Experience working with insurance domain data such as Policy, Claims, Billing, Customer, Producer, and Underwriting data
Experience integrating data from Guidewire applications into enterprise data platforms
Strong understanding of Guidewire data structures and insurance business processes
Ability to work with Guidewire APIs, extracts, events, or integration mechanisms where applicable
Experience in designing downstream data pipelines and analytics solutions for Guidewire-generated data
Understanding of insurance data governance, reconciliation, and data quality requirements
Experience with Azure Synapse Analytics, Azure Functions, Python and/or PySpark, Databricks, DataStage or Netezza, CI/CD pipelines, DevOps practices, data governance, metadata management, data catalog, data lineage tools, Power BI, Tableau, or other BI and analytics tools is advantageous or preferred
Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related field
Demonstrated experience leading data engineering teams or providing technical leadership on enterprise data projects
Strong understanding of modern cloud data architecture, ETL/ELT, data warehousing, and data governance
Excellent communication and collaboration skills with the ability to work across business and technical teams

Core Competencies

Demonstrates expertise in designing and developing scalable ETL/ELT data pipelines using Azure Data Factory and Snowflake, with a strong focus on data integration, governance, and quality. Proven ability to lead technical discussions and provide guidance to data engineering teams while ensuring compliance with enterprise standards.

Highest-signal resume keywords