> Markdown version of [/jobs/ext/2218271-data-architect](https://www.wearedevelopers.com/jobs/ext/2218271-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect - **Company:** e-IT Professionals Corp. - **Location:** Hartford, CT, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Geographic Information Systems, Cloud Database, Cluster Analysis, Computer Programming, Databases, Data Architecture, Data Cleansing, Data Governance, Extract Transform Load (ETL), Data Loss, Data Migration, Data Sharing, Data Systems, IBM DB2, Relational Databases, Python (Programming Language), PostgreSQL, Mainframes, Operational Data Store, Duckcreek Integration, Query Optimization, SQL Databases, Data Streaming, Data Processing, Scripting, Data Ingestion, Snowflake, Indexer, Data Management, Data Pipelines - **Published:** August 25, 2026 - **Apply:** https://www.dice.com/job-detail/1d85d872-c4ab-4f82-8432-aa061e741ae6 ## About the Role * 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. ## 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., * 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. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)