Data Architect
Persistent
Persistent
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.
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.
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.
Persistent Systems
Insurance