Sign upLog in
Data Analysis Jobs in Irvine, CA

Lead Data Analyst – Personal Lines Insurance

Tanisha Systems
  • Hartford, CT, CT
  • Temporary
  • Contractor
  • Part-time
  • Instant Apply
1 day ago

Job Description

Hi,

Hope You are doing well.

This is Piyush from Tanisha Systems. I have a job opportunity for you, if you are interested, please share your Resume and details ASAP.

Lead Data Analyst – Personal Lines Insurance
Location: Hartford, CT 06155 – Hybrid
Industry: Property & Casualty Insurance
Note: Duck Creek experience is highly preferred.

Position Overview
We are seeking an experienced Lead Data Analyst with strong expertise in Personal Lines Insurance, specifically Automotive and Home Insurance, to lead a critical legacy modernization initiative.
The successful candidate will drive the data strategy, analysis, mapping, reconciliation, and validation required to migrate core insurance systems from a legacy Mainframe environment to Duck Creek.
This role will serve as a key bridge between business stakeholders, data migration teams, engineering teams, and system integrators, ensuring data integrity, regulatory compliance, business continuity, and minimal disruption throughout the migration.
Key Responsibilities
Data Migration Analysis & Strategy
  • Lead data analysis and migration activities for large-scale modernization of legacy insurance systems.
  • Perform Source-to-Target Mapping (STTM) from legacy Mainframe data structures, including COBOL/DB2, to Duck Creek standard data models.
  • Analyze and interpret legacy data structures, COBOL copybooks, DB2 tables, flat files, and related data sources.
  • Lead data profiling activities across historical policy, claims, and billing data to identify data gaps, duplicates, inconsistencies, quality issues, and cleansing requirements.
  • Define and document business transformation rules to ensure legacy Personal Lines products, including Auto and Home, are accurately mapped to Duck Creek product configurations.
  • Identify migration risks, data dependencies, transformation requirements, and potential downstream impacts.
  • Develop data migration strategies that support business continuity, data integrity, and operational readiness.
Insurance Domain & Data Validation
  • Apply strong knowledge of Personal Lines Insurance, including Auto and Home policy lifecycles, policy structures, coverages, deductibles, claims, billing, and related business processes.
  • Validate complex insurance metrics throughout the migration lifecycle, including:
  • Written Premium
  • Earned Premium
  • Loss History
  • Policy Coverages
  • Deductibles
  • Claims and Billing Data
  • Establish and execute data validation and reconciliation processes to ensure migrated data accurately reflects legacy business records.
  • Develop automated reconciliation frameworks to validate millions of migrated records and confirm financial and operational balances.
  • Investigate data discrepancies and coordinate corrective actions with migration, development, business, and integration teams.
  • Collaborate with Underwriting, Product Owners, Claims, Billing, and business stakeholders to validate migrated functionality and business rules.
  • Ensure automated rating engine inputs and outputs perform consistently with legacy rules or provide improved business outcomes.
Team Leadership
  • Lead and mentor a team of Data Analysts supporting multiple migration workstreams.
  • Assign and manage data migration streams such as Auto Policy, Home Policy, Claims, and Billing.
  • Establish priorities, track deliverables, monitor progress, and ensure migration milestones are achieved.
  • Review analytical outputs, mapping documents, validation results, and reconciliation reports for accuracy and completeness.
  • Identify resource requirements, delivery risks, dependencies, and potential project impacts.
Stakeholder Management & Reporting
  • Serve as the primary data liaison between business stakeholders, data migration engineers, system integrators, and technical teams.
  • Translate complex technical data migration issues into clear business impact statements for leadership.
  • Communicate data quality issues, migration risks, dependencies, and readiness status to project leadership.
  • Develop and maintain weekly migration readiness dashboards, status reports, and data quality metrics.
  • Facilitate working sessions with business and technical teams to resolve data mapping, transformation, and validation issues.
  • Ensure stakeholders have clear visibility into migration progress, risks, issues, and remediation plans.
Required Qualifications
  • Bachelor's degree in Data Analytics, Computer Science, Information Systems, or a related field.
  • 8+ years of experience as a Data Analyst, Data Consultant, or similar data-focused role.
  • At least 3 years of experience leading data workstreams for large-scale core insurance platform migrations.
  • Strong domain expertise in Personal Lines Insurance, particularly:
  • Auto Insurance
  • Home Insurance
  • Policy Administration
  • Claims
  • Billing
  • Coverages and Deductibles
  • Premium and Loss Data
  • Hands-on experience working with Mainframe environments, including COBOL copybooks, DB2, flat files, and legacy data structures.
  • Strong experience with SQL, including complex joins, unions, subqueries, data profiling, reconciliation, and data validation scripts.
  • Experience performing Source-to-Target Mapping (STTM) and defining data transformation rules.
  • Demonstrated experience with data profiling, cleansing, migration validation, reconciliation, and data quality management.
  • Strong analytical, problem-solving, communication, and stakeholder management skills.
  • Experience leading data analysts or data migration workstreams.
Preferred Qualifications
  • Duck Creek experience is highly preferred, particularly experience with Duck Creek Policy, Claims, or Billing.
  • Duck Creek certification or formal Duck Creek Policy/Claims training.
  • Experience migrating legacy insurance platforms to Duck Creek.
  • Experience working with Azure or AWS as staging or supporting environments during data migration initiatives.
  • Knowledge of state-specific regulatory reporting requirements for Auto and Home insurance.
  • Experience with large-scale insurance modernization and core platform transformation programs.
  • Experience developing automated data reconciliation and validation frameworks



Piyush Chowdhary
Sr. Delivery Manager/Account Manager
Tanisha Systems Inc
Desk no. 732-944-0375
Email:

piyush.chowdhary@tanishasystems.com


Web: www.tanishasystems.com
Linkedin URL: Piyush Chowdhary - Irvine, California, United States | Professional Profile | LinkedIn
Address:99 Wood Ave South Suite # 308,Iselin, NJ 08830
E-Verify, Certified Minority Business Enterprise MBE, Dun & Bradstreet CREDIBILITY

"Tanisha Systems, Inc. is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, (including pregnancy, childbirth, or related medical conditions), sexual orientation, national origin, *, physical or mental disability, or any other status protected by applicable federal, state, or local law. We are committed to providing an accessible work environment for all candidates. Reasonable accommodation will be provided during the application and hiring process upon request."


Numbers & Facts

LocationHartford, CT, CT
Job TypeTemporary, Contractor, Part-time

Skills

  • Amazon Web Services (AWS)unmatched
  • Analysis Skillsunmatched
  • Auto Insuranceunmatched
  • Billingunmatched
  • Business Processesunmatched
  • Business Supportunmatched
  • Business Transformationunmatched
  • Cobol Programming Languageunmatched
  • Computer Scienceunmatched
  • Consultingunmatched
  • Corrective Actionunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Mappingunmatched
  • Data Migrationunmatched
  • Data Modelingunmatched
  • Data Profilingunmatched
  • Data Qualityunmatched
  • Data Structuresunmatched
  • Database Technologyunmatched
  • Delivery Managementunmatched
  • Establish Prioritiesunmatched
  • Financial Operationsunmatched
  • Functional Testingunmatched
  • IBM DB2unmatched
  • Information Technology & Information Systemsunmatched
  • Insuranceunmatched
  • Leadershipunmatched
  • LinkedInunmatched
  • Mainframe Computerunmatched
  • Mentoringunmatched
  • Metricsunmatched
  • Microsoft Windows Azureunmatched
  • Migration Strategyunmatched
  • Policy Developmentunmatched
  • Problem Solving Skillsunmatched
  • Process Improvementunmatched
  • Project Trackingunmatched
  • Property Insuranceunmatched
  • Property and Casualty Insuranceunmatched
  • Quality Managementunmatched
  • Quality Metricsunmatched
  • Reconciliationunmatched
  • Regulatory Complianceunmatched
  • Regulatory Reportsunmatched
  • Regulatory Requirementsunmatched
  • Reporting Dashboardsunmatched
  • Risk Analysisunmatched
  • SQL (Structured Query Language)unmatched
  • Sales Managementunmatched
  • Scripting (Scripting Languages)unmatched
  • State Laws and Regulationsunmatched
  • Status Reportsunmatched
  • Strategic Analysisunmatched
  • Strategic Planningunmatched
  • System Integration (SI)unmatched
  • System Migrationunmatched
  • Team Lead/Managerunmatched
  • Underwritingunmatched
  • Validation Documentationunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder