Responsibilities:
Multi-Line Integration: Architect data models that unify distinct data streams across Auto (vehicle telematics, driving history) and Homeowners (property risk, geographic data) lines of business.
Duck Creek Integration: Design and manage ingestion pipelines from Duck Creek Clarity to extract, transform, and load comprehensive policy, billing, and claims workflows.
Data Migration: Lead complex migration strategies transferring high-volume personal line historical data from legacy mainframes or relational databases to contemporary cloud platforms.
Data Quality Frameworks: Establish automated DQ rules and profiling to ensure pristine financial reporting, accurate loss-ratio calculations, and claims tracking.
Pipeline Development: Build productive, reusable data ingestion and transformation pipelines using Python and SQL.
Predictive Analytics Support: Partner with Actuarial and Underwriting teams to structure data for pricing models, geographic hazard mapping, and customer lifetime value analytics.

Eligibility:
Insurance Expertise:



Minimum 5+ years of experience working specifically with Personal Lines data (Automobile, Homeowners, Personal Property).
Duck Creek Clarity: Deep structural understanding of Duck Creek Clarity schemas, transactional databases, and operational data stores.
Cloud Data Warehousing: Expert-level design experience with Snowflake, including data sharing, clustering, and cost optimization.
Relational Databases: Robust mastery of PostgreSQL implementation, indexing, and complex query optimization.
Programming: Advanced proficiency in Python for data manipulation, scripting, data loading to Duck Creek and ETL frameworks.
Data Migration Experience: Proven track record of handling large-scale core system migrations with zero data loss.
Data Quality Tools: Experience with DQ frameworks using custom Python/PostgreSQL-based validations.

Mandatory skills:

Data Architect
Snowflake
Data Migration - Mandatory Recent project Exp
SQL
Insurance Domain
AWS
Postgres
Python

📌 Data Architect Bengaluru
🏢 Persistent Systems
📍 Bengaluru