Data Architect

Persistent Systems; Pune District; Hybrid; INR 2,000,000 - 5,200,000; Full time

Benefits offered by this job

Hybrid work

Flexible work hours

Education sponsorship

Insurance coverage

Job summary

Persistent Systems is seeking a Senior Data Architect to design and modernize data platforms across personal insurance lines, specifically Auto, Homeowners, and Personal Property. You will lead the migration of legacy Mainframe/DB2 into a Duck Creek Clarity cloud ecosystem using Snowflake, PostgreSQL, and Python.

Role focuses on unifying data models across lines, delivering data quality frameworks for underwriting analytics, risk profiling, and regulatory reporting.

Qualifications

• Minimum 10+ years of experience in data architecture for insurance.
• Deep knowledge of Duck Creek Clarity schemas and data stores.
• Expertise in Snowflake data sharing, clustering, and cost optimization.
• Strong PostgreSQL performance tuning and SQL development.
• Proficiency in Python for data pipelines and ETL.

Responsibilities

• Multi-Line Integration: architect data models unifying Auto and Homeowners data streams.
• Duck Creek Integration: manage ingestion from Duck Creek Clarity for policy, billing, and claims workflows.
• Data Migration: lead migration of high-volume personal lines history from legacy systems to cloud.
• Data Quality Frameworks: implement automated DQ rules for accurate reporting.
• Pipeline Development: build data ingestion/transformation pipelines with Python and SQL.
• Predictive Analytics Support: partner with Actuarial and Underwriting for pricing and risk analytics.

Skills

Duck Creek Clarity

Snowflake

PostgreSQL

Python

ETL

SQL

Education

Bachelor's degree in Data Analytics / CS / IS

Tools

Duck Creek Clarity

Snowflake

PostgreSQL

Job description

We are seeking a Senior Data Architect to design and modernize data platforms across personal insurance lines, specifically Automobile, Personal, and Homeowners insurance. You will lead the modern migration of legacy core systems Mainframe and DB2 into a high-performance Duck Creek cloud ecosystem. Your primary focus will be architecting data solutions using Snowflake, PostgreSQL, and Python, with a specific emphasis on Duck Creek Clarity policy, billing, and claims data models. You will establish robust Data Quality (DQ) frameworks to ensure accurate underwriting analytics, risk profiling, and regulatory reporting.

• Role: Data Architect
• Location: All Persistent Locations
• Experience: 10+yrs
• Job Type: Full-Time Employment

What You'll Do:

• 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 lines historical data from legacy mainframes or relational databases to modern 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 efficient, 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.

Expertise You'll Bring:

• 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: Strong 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.
• Bachelor’s degree in data Analytics, Computer Science, Information Systems, or a related field.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.