Data Architect

Persistent

10+ yrs Pune Full Time Hybrid (office + remote)
Persistent logo
Posted : today
Actively hiring

Job description

Join Persistent as a Senior Data Architect, a pivotal role focused on designing and modernizing data platforms within the personal insurance sector, encompassing Automobile, Personal, and Homeowners insurance lines. This position is central to leading the transition of legacy mainframe and DB2 systems into a dynamic, high-performance Duck Creek cloud environment. The core of this role involves architecting sophisticated data solutions using Snowflake, PostgreSQL, and Python, with a keen focus on the specific data models within Duck Creek Clarity for policy, billing, and claims.

Establish and implement robust Data Quality (DQ) frameworks essential for ensuring the accuracy of underwriting analytics, risk profiling, and regulatory reporting. Your expertise will be instrumental in driving data-driven decision-making and enhancing the overall efficiency of our insurance operations.

Responsibilities

Architect comprehensive data models capable of integrating diverse data streams from Automobile (telematics, driving history) and Homeowners (property risk, geographic data) business lines.

Design and oversee the management of ingestion pipelines from Duck Creek Clarity to effectively extract, transform, and load policy, billing, and claims workflows.

Lead intricate data migration strategies to transfer high-volume personal lines historical data from legacy mainframes or relational databases to modern cloud platforms.

Implement automated data quality rules and profiling mechanisms to guarantee pristine financial reporting, precise loss-ratio calculations, and accurate claims tracking.

Develop efficient and reusable data ingestion and transformation pipelines utilizing Python and SQL.

Collaborate closely with Actuarial and Underwriting teams to structure data optimally for pricing models, geographic hazard mapping, and customer lifetime value analytics.

Qualifications

Bring a minimum of 5 years of specialized experience in Personal Lines data, including Automobile, Homeowners, and Personal Property.

Possess a deep structural understanding of Duck Creek Clarity schemas, transactional databases, and operational data stores.

Demonstrate expert-level design experience with Snowflake, including proficiency in data sharing, clustering, and cost optimization techniques.

Exhibit strong mastery of PostgreSQL implementation, indexing, and complex query optimization.

Show advanced proficiency in Python for data manipulation, scripting, data loading to Duck Creek, and ETL framework development.

Provide a proven track record of successfully executing large-scale core system migrations with zero data loss.

Have experience with data quality frameworks leveraging custom Python/PostgreSQL-based validations.

Hold a Bachelor's degree in Data Analytics, Computer Science, Information Systems, or a closely related field.

Essential Skills

Data WarehousingData MigrationSnowflakePostgreSQLPythonSQLData Quality FrameworksETL

Good to Have

Data ModelingCloud Data WarehousingRelational DatabasesData ManipulationScripting

Highlights

  • Actively hiring

More Details

RoleData Architect
IndustryInsurance
DepartmentData Architecture
Employment TypeFull Time, Hybrid (office + remote)

About the Company

Persistent Systems logo

Persistent Systems

Insurance

Data Architect at Persistent | SkillMX | SkillMX