Data Migration Analyst

London - UK

Monthly Salary: Not Disclosed

Posted on: 22 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title: Data Migration Analyst Data Migration Project

Reporting to: Head of Data Governance

Position Type: 6 month contract Outside IR35

Why Tokio Marine HCC

Standing still is not an option in the current world of Insurance. TMHCC are one of the worlds leading Specialty Insurers. With deep expertise in our chosen lines of business our unparalleled track record and a solid balance sheet TMHCC evaluates and manages risk like no one else in the industry. Looking beyond profit empowering our people and delivering on our commitments are at the core of our customer values and so is a desire to grow and provide creative and innovative solutions to our clients.

About Operations

Operations sits at the heart of TMHCC we ensure the smooth running of all business processes from policy administration and claims handling to data technology and delivery. We focus on driving efficiency which enables our teams across the business to deliver exceptional results every day. Our value statement: Ops makes it happen.

Operations is made up of 7 functions this role sits within: Data Office

The TMHCC Data Office is a dynamic forward-thinking team where data analytics data design & engineering and data governance come together to drive meaningful impact across the business. Youll collaborate with passionate experts who champion innovation empower decision-making and help get the right data to the right people at the right times to shape decision making at TMHCC.

Job Purpose:

As a Data Migration Analyst you will lead the field-level data mapping and transformation from legacy Policy Admin System (PAS) to the target Verisk Eclipse/Claims system and supporting programs.

Your role will involve creating releasing and unit testing migration code for each of these data migrations including:

Developing SQL logic to support transformation and validation of policy and claims data
Supporting reconciliation during test and cutover phases
Working closely with QA and TO SME to validate outputs

You will be working immediately with the technical lead on the project and report into the Data Migration PM. You will be required to have strong collaboration with Business and IT Project Managers a Test Manager and Change Readiness teams.

The role would suit a delivery focused Data Migration Analyst who enjoys working through the challenges of large-scale transformation delivery.

Key Responsibilities:

Data Migration Framework: Collaborate with the Data Migration Lead external providers and in-house developers to design implement and execute the Data Migration Framework (DMF).
Stakeholder Engagement: Represent the Data Migration team in meetings with senior stakeholders.
Code Development: Generate migration code using SSIS and TSQL ensuring compliance with TMHCC standards.
Review Mapping Documents: Provide positive & constructive feedback
Code Management: Maintain code and release processes according to TMHCC standards.
Subject Matter Expertise: Become the main developer and subject matter expert (SME) for source system data identified in all systems in within Surety Part 2 migration projects.
Support Migration Execution: Assist in the execution of data migrations and participate in Agile & waterfall scenarios.

Performance Objectives:

Contribute to the successful implementation of the Data Migration Framework.
Become an SME for the underwriting system in allocated projects.
Develop high-quality code that adheres to TMHCC development standards.

Skills and Experience Specification:

Essential:

High Proficiency in MS-SQL Server TSQL MS-SSIS MS-SQL MS-SSRS
Knowledge of insurance data including London Markets and general insurance
Familiarity with common underwriting or claims systems (e.g. Sequel Eclipse Guidewire Iris)
Experience in unit testing code
Strong understanding of code management and deployment tools (e.g. DevOps Bitbucket TFS)
Confident working in an Agile development environment
Hands on experience of ETL Control Frameworks (extract cleanse enrich transform and load routines)
Database administration skills and performance tuning databases

Desirable:

Previous experience working in financial services preferably Specialty Insurance
Confident creating SSIS packages using BIML or similar tools
High proficiency in maintaining reference and master data sets in SQL Server MDS
Confident deploying code to environments using TFS or similar tools
Good understanding of finance systems (e.g. Peoplesoft Bottomline)
Good knowledge of reinsurance data (e.g. XLPRO)
Experience with Autorek reconciliation software
Knowledge of HVR data access/integration tools
Familiarity with cloud data archiving solutions (AWS S3 and Athena)

What We Offer

The Tokio Marine HCC Group of Companies offers a competitive salary and employee benefit package. We are a successful dynamic organization experiencing rapid growth and are seeking energetic and confident individuals to join our team of professionals.

The Tokio Marine HCC Group of companies is an equal opportunity employer. Please visit for more information about our companies.

#LI-HJ1

Required Experience:

Job Title: Data Migration Analyst Data Migration ProjectReporting to: Head of Data GovernancePosition Type: 6 month contract Outside IR35Why Tokio Marine HCCStanding still is not an option in the current world of Insurance. TMHCC are one of the worlds leading Specialty Insurers. With deep expert...