ADF Architect – P&C Insurance

BlitzenX; India; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

A leading data solutions firm in India is seeking a seasoned data engineer with over 10 years of experience. The successful candidate will own the architecture and delivery of Azure Data Factory solutions for P&C insurance data platforms. You will design enterprise-scale data pipelines and integrate data across various systems. Expertise in SQL, data modeling, and Azure services is essential. Candidates must excel in delivering complex solutions independently with strong P&C insurance domain experience.

Qualifications

• 10+ years of data engineering or integration experience.
• 5+ years of Azure Data Factory (ADF) experience in production environments.
• Strong P&C insurance domain expertise across relevant data.

Responsibilities

• Own ADF architecture end to end — design, standards, implementation.
• Design and build enterprise-scale data pipelines for insurance data.
• Ensure data reliability, scalability, and cost control across Azure services.

Skills

Data engineering

Azure Data Factory

SQL

Data modeling

P&C insurance domain expertise

Tools

Azure Data Lake Gen2

Azure SQL

Azure Synapse

Databricks

Job description

Role Objective

Own and deliver the Azure Data Factory architecture for P&C insurance data platforms. This role is accountable for architecture decisions, hands-on delivery, and technical quality. You are expected to operate independently and drive outcomes. Guidewire experience is a plus, not a substitute for ADF expertise.

Core Responsibilities

• Own ADF architecture end to end — design, standards, implementation, and enforcement.
• Design and build enterprise-scale data pipelines handling high-volume P&C insurance data.
• Develop complex ADF pipelines, datasets, linked services, triggers, and monitoring frameworks.
• Integrate data across policy, claims, billing, underwriting, finance, and analytics systems.
• Drive data ingestion from Guidewire platforms where applicable (PolicyCenter, BillingCenter, ClaimCenter).
• Implement and enforce error handling, logging, retry mechanisms, and performance optimization.
• Ensure data reliability, scalability, and cost control across Azure services.
• Translate P&C insurance business requirements into executable technical designs.
• Review and approve designs and code from other engineers; enforce engineering discipline.
• Identify technical risks early and resolve them decisively.

Mandatory Requirements

• 10+ years of data engineering or integration experience.
• 5+ years of hands-on Azure Data Factory (ADF) experience in production environments.
• Strong P&C insurance domain expertise across policy, claims, billing, underwriting, and financial data.
• Proven experience designing and delivering complex, large-scale data integration platforms.
• Strong SQL skills and solid data modeling fundamentals.
• Hands-on experience with Azure Data Lake Gen2, Azure SQL, Synapse, and/or Databricks.
• Experience working in governed, regulated environments with strict data security controls.
• Demonstrated ability to own architecture decisions and deliver without supervision.