Lead Data Analyst

PeopleNTech; Alexandria (VA); Hybrid; USD 108,000 - 132,000; Full time

Job summary

PeopleNTech in Hartford, CT, seeks a Lead Data Analyst to drive data strategy and validation for migrating our core insurance systems from legacy Mainframe to Duck Creek. You will bridge business stakeholders with data migration engineers to ensure data continuity and regulatory compliance.

The role requires 8+ years in data analytics with 3+ years leading migration tracks, deep Personal Lines knowledge, and strong SQL skills to deliver precise data transformations and reconciliations.

Qualifications

• Bachelor's degree in data Analytics, Computer Science, Information Systems, or a related field.
• 8+ years as a Data Analyst, with at least 3 years leading data tracks for large-scale core insurance migrations.
• Deep understanding of Personal Lines insurance lifecycles, policy structures, and coverages.

Responsibilities

• Perform source-to-target mapping from legacy Mainframe (COBOL/DB2) to Duck Creek data models.
• Lead data profiling on historical policy, claims, and billing data to identify data gaps and cleansing needs.
• Define business transformation rules for mapping Personal Lines to Duck Creek configurations.
• Validate metrics like Written/Earned Premium, Loss History, Policy Coverages, and Deductibles.
• Establish automated reconciliation frameworks to verify migrated records against balances.
• Collaborate with Underwriting and Product Owners to align rating engine inputs with legacy rules.
• Direct a team of data analysts across migration streams and track milestones.
• Translate migration risks into business impact statements with weekly dashboards.
• Liaise with Duck Creek configuration teams to troubleshoot data defects during UAT.

Skills

SQL

Leadership

Stakeholder management

Data analysis

Education

Bachelor's degree in data Analytics, Computer Science, Information Systems, or a related field

Tools

Duck Creek

DB2

PostgreSQL

Job description

Job Title: Lead Data Analyst

Location : Hartford, CT 06155 (Hybrid)

Rate : $65/hr.

Salary : $120K

We are seeking a Lead Data Analyst with specialized expertise in Personal Lines (Automotive & Home insurance) to spearhead a critical legacy modernization initiative. In this role, you will lead the data strategy, analysis, and validation for migrating our core insurance systems from a legacy Mainframe environment to Duck Creek. You will act as the key bridge between business stakeholders, data migration engineers, and system integrators to ensure flawless data continuity, regulatory compliance, and minimal business disruption.

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.
• Liaise with Duck Creek configuration teams to troubleshoot data-related defect logs during functional and user acceptance testing (UAT).

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.