Lead Data Analyst with Duck creek exp is good to have

Required Technical Skills & Qualifications

·         Education: Bachelor’s degree in data Analytics, Computer Science, Information Systems, or a related field.

·         Experience: 8+ years as a Data Analyst, with at least 3 years leading data tracks for large-scale core insurance platform migrations.

·         Domain Knowledge: Deep understanding of Personal Lines (Automotive and Home) insurance lifecycles, policy structures, and standard coverages.

·         Legacy Systems: Hands-on experience working with Mainframe systems (interpreting copybooks, querying DB2, PostgreSQL or understanding flat files).

·         Target System: Prior experience working with or migrating into Duck Creek Policy, Claims, or Billing modules is highly preferred.

·         Data Tools: Advanced proficiency in SQL (writing complex joins, unions, and validation scripts)

Preferred (Nice-to-Have) Skills

·         Certification in Duck Creek (Policy or Claims training).

·         Experience utilizing Azure or AWS cloud environments as a staging area during migration.

·         Understanding of state-specific regulatory reporting requirements for Auto and Home insurance lines.

Key Responsibilities

Migration Analysis & Strategy

·         Perform source-to-target mapping (STTM) from legacy Mainframe data structures (COBOL/DB2) to Duck Creek standard data models.

·         Lead data profiling activities on historical policy, claims, and billing data to identify data gaps, redundancies, and cleansing requirements.

·         Define business transformation rules ensuring legacy Personal Lines products (Auto and Home) map accurately into Duck Creek's product configurations.

Domain Execution & Validation

·         Validate complex insurance metrics across the migration lifecycle, including Written/Earned Premium, Loss History, Policy Coverages, and Deductibles.

·         Establish automated reconciliation frameworks to verify that millions of migrated records match financial and operational balances.

·         Collaborate with Underwriting and Product Owners to ensure automated rating engine inputs function identical to or better than legacy rules.

Team Leadership & Stakeholder Management

·         Direct a team of data analysts, assigning migration streams (e.g., Auto Policy, Home Claims, Billing) and tracking delivery milestones.

·         Translate technical migration risks into business impact statements for leadership, providing weekly readiness dashboards.