Insurance Data Migration Analyst – SSIS/SQL Expert

Tokio Marine HCC; Greater London; On-site; GBP 60,000 - GBP 80,000; Full time

Job summary

A leading specialty insurer in Greater London is seeking a Data Migration Analyst to manage data transformation tasks for the migration of legacy systems. The role requires expertise in SQL Server and SSIS, as well as collaboration with stakeholders to execute the Data Migration Framework. Ideal candidates will have a strong background in insurance data, agile methodologies, and ETL processes. Competitive salary and benefits offered in a high-growth environment.

Benefits

Competitive salary

Employee benefit package

Qualifications

• High proficiency in MS-SQL Server, TSQL, and MS-SSIS.
• Experience with common underwriting or claims systems.
• Strong understanding of ETL Control Frameworks.

Responsibilities

• Lead field-level data mapping and transformation for migration.
• Collaborate with external providers and developers.
• Generate migration code with SSIS and TSQL.

Skills

High Proficiency in MS-SQL Server

Knowledge of insurance data

Familiarity with underwriting or claims systems

Experience in unit testing code

Agile development experience

Database administration skills

Tools

MS-SSIS

SSIS packages using BIML

DevOps

TFS

Job description

A leading specialty insurer in Greater London is seeking a Data Migration Analyst to manage data transformation tasks for the migration of legacy systems. The role requires expertise in SQL Server and SSIS, as well as collaboration with stakeholders to execute the Data Migration Framework. Ideal candidates will have a strong background in insurance data, agile methodologies, and ETL processes. Competitive salary and benefits offered in a high-growth environment.