Senior Lead Data Analyst (Insurance) (Legacy to Guidewire Data Migration Exp)

HTC Global Services; Lansing (MI); On-site; USD 100,000 - 130,000; Full time

Job summary

HTC Global Services is seeking a Senior Lead Data Analyst to spearhead data migration initiatives in the insurance sector. In this hands-on leadership role, you will drive the transition from legacy systems to Guidewire ClaimCenter, optimizing ETL processes and ensuring data quality. Candidates should have over 10 years of relevant experience, particularly with insurance domain expertise and a solid technical background in Java, Python, and SQL. Successful applicants will join a collaborative team focused on advancing data transformation efforts critical to our clients' success.

Benefits

Paid-Time-Off

401K matching

Life Insurance

Short & Long Term Disability Insurance

Qualifications

• 10+ years of experience in data analysis and migration projects.
• Strong background in insurance and legacy systems.
• Proven leadership in distributed teams.

Responsibilities

• Lead end-to-end design and ETL workflow execution.
• Guide teams and act as liaison for technical delivery.
• Collaborate with clients on data assessment and solutions.

Skills

Data Analysis

ETL Development

Data Migration

Java

Python

SQL

Stakeholder Management

Technical Leadership

Education

Bachelor's Degree in Computer Science or related field

Job description

Senior Lead Data Analyst (Insurance) (Legacy to Guidewire Data Migration Exp)

Join to apply for the Senior Lead Data Analyst (Insurance) (Legacy to Guidewire Data Migration Exp) role at HTC Global Services

Continue with Google Continue with Google

Senior Lead Data Analyst (Insurance) (Legacy to Guidewire Data Migration Exp)

3 days ago Be among the first 25 applicants

Join to apply for the Senior Lead Data Analyst (Insurance) (Legacy to Guidewire Data Migration Exp) role at HTC Global Services

HTC Global Services wants you. Come build new things with us and advance your career. At HTC Global you'll collaborate with experts. You'll join successful teams contributing to our clients' success. You'll work side by side with our clients and have long-term opportunities to advance your career with the latest emerging technologies.

At HTC Global Services our employees have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks.

Drive the Future of Insurance Data Transformation

Are you a seasoned data expert with a passion for solving complex migration challenges in the insurance domain? We’re looking for a Senior Lead Data Analyst to spearhead critical enterprise data migration initiatives from legacy IMS/DB2 mainframe systems to Guidewire ClaimCenter v10.0.

This is a hands-on leadership role for someone who thrives in high-impact environments, excels at technical execution, and has the ability to drive clarity and results across globally distributed teams.

What You’ll Do

Data Migration Strategy & Execution:

• Lead the end-to-end design and execution of robust ETL workflows using a custom framework built in Python and Kotlin.
• Oversee data extraction, transformation, and loading processes from legacy systems to Guidewire.
  
  

Hands-On Technical Development

• Develop and optimize ETL scripts using Java, Python, SQL, and Shell scripting.
• Implement complex data transformations, ensuring accuracy, consistency, and high performance.
  
  

Performance Tuning & Troubleshooting

• Write and refine advanced SQL queries for data validation, analysis, and troubleshooting.
• Investigate and resolve data quality issues, ensuring high data fidelity throughout migration.
  
  

Team & Stakeholder Leadership

• Guide and mentor both onshore and offshore teams; provide technical oversight and best practices.
• Act as a key liaison between internal teams and client stakeholders to align technical delivery with business objectives.
  
  

Client-Facing Planning & Analysis

• Collaborate with clients to assess legacy data systems, identify migration gaps, and design scalable solutions.
• Drive migration planning, prioritization, and reporting to meet tight project timelines.
  
  

System & Data Architecture Understanding

• Deep-dive into Guidewire ClaimCenter data models to ensure proper integration and alignment with business needs.
• Analyze data from multiple sources and recommend appropriate transformation strategies.
  
  

Documentation & Knowledge Sharing

• Create and maintain clear, comprehensive documentation for ETL logic, data mapping, and system integration.
• Lead team walkthroughs and provide hands-on support for deliverables.
  
  

What You Bring

• 10+ years of hands-on experience in data analysis, ETL development, and large-scale data migration projects.
• Strong background in the insurance domain, particularly with legacy mainframe platforms (IMS/DB2).
• Deep expertise in Java, Python, SQL, and scripting languages (e.g., Bash, Shell).
• Proven track record working with or migrating to Guidewire ClaimCenter v10.0.
• Demonstrated experience leading distributed development teams, including offshore coordination.
• Excellent communication, documentation, and stakeholder management skills.
  
  

Why Join Us?

• Be at the forefront of digital transformation in the insurance industry.
• Work on mission-critical projects that directly impact business operations.
• Collaborate with top-tier professionals in a culture that values innovation, ownership, and knowledge sharing.
• Enjoy flexibility, autonomy, and clear career growth opportunities.
  
  

Apply Now

Ready to lead a transformation that matters? Apply today and become part of a high-performing team driving the next generation of insurance data systems.

Our success as a company is built on practicing inclusion and embracing diversity. HTC Global Services is committed to providing a work environment free from discrimination and harassment, where all employees are treated with respect and dignity. Together we work to create and maintain an environment where everyone feels valued, included, and respected. At HTC Global Services, our differences are embraced and celebrated. HTC is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce. HTC is proud to be recognized as a National Minority Supplier.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at HTC Global Services by 2x

Get notified about new Lead Data Analyst jobs in Lansing, MI.

Business Anslyst 5 w/ JAD, LEO knowledge

i-team Data Analytics Manager, Lansing - 117719

East Lansing, MI
$60,000.00
-
$80,000.00
15 hours ago

Departmental Analyst 12 - Licensing Business Analyst (CCWIS)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.