Data Migration Analyst

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., * 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.

Do you have experience in Unit testing?, * 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)

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.

Standing still is not an option in the current world of Insurance. TMHCC are one of the world's 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. You'll 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.