Data Architect

Arkhya Tech Inc.; Connecticut; On-site; USD 120,000 - 180,000; Full time

Job summary

Arkhya Tech Inc. in Connecticut is seeking a senior data professional with 5+ years of experience in Personal Lines data, Snowflake design, and PostgreSQL efficiency. The role emphasizes Python-based data manipulation, ETL loading to Duck Creek, and robust data migration with zero data loss.

The candidate will work with advanced data quality frameworks and custom Python/PostgreSQL validations to ensure data integrity across large-scale migrations and warehousing initiatives.

Qualifications

• Minimum 5+ years of experience with Personal Lines data (Automobile, Homeowners, Personal Property).
• Expert-level Snowflake design (data sharing, clustering, cost optimization).
• Strong PostgreSQL mastery (indexing, complex queries).
• Advanced Python for data manipulation, scripting, ETL loading to Duck Creek.
• Proven track record of large-scale core system migrations with zero data loss.
• Experience with Python/PostgreSQL-based data quality validations.

Skills

Insurance Expertise

Cloud Data Warehousing

Relational Databases

Programming

Data Migration

Data Quality Tools

Job description

Insurance Expertise: Minimum 5+ years of experience working specifically with Personal Lines data (Automobile, Homeowners, Personal Property).

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.