Azure Lead Data Engineer + Guidewire

Job description

Key Role and Responsibilities: • 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. Must Have: • 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 Insurance Suite, Guidewire data models, or Guidewire-based data integrations. EXL Service • Experience working with insurance domain data such as Policy, Claims, Billing, Customer, Producer, and Underwriting data. • Strong problem-solving, communication, stakeholder management, and technical leadership skills. Guidewire-Specific Requirements • Experience integrating data from Guidewire applications into enterprise data platforms. • Strong understanding of Guidewire data structures and insurance business processes. • Experience with Guidewire PolicyCenter, ClaimCenter, and/or BillingCenter data is highly preferred. • 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.