Lead Data Analyst – Insurance Core Migration (Hybrid)

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

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.