Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data mapping and transformation from legacy systems to modern platforms.
- Company: Join Tokio Marine HCC, a leading Specialty Insurer with a focus on innovation.
- Benefits: Competitive salary, dynamic work environment, and growth opportunities.
- Why this job: Make a real impact in data migration and collaborate with passionate experts.
- Qualifications: Proficiency in SQL, TSQL, and experience in data migration projects.
- Other info: Be part of a forward-thinking team driving meaningful change in the insurance industry.
The predicted salary is between 36000 - 60000 £ per year.
Overview
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 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.
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.
Essential Skills and Experience
- 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 www.tmhcc.com for more information about our companies.
Data Migration Analyst employer: Tokio Marine HCC International
Contact Detail:
Tokio Marine HCC International Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Migration Analyst
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, especially those at Tokio Marine HCC. A friendly chat can open doors that a CV just can't.
✨Tip Number 2
Prepare for interviews by brushing up on your SQL and data migration skills. Be ready to showcase how you can tackle real-world challenges in data transformation.
✨Tip Number 3
Don’t just apply; engage! When you submit your application through our website, follow up with a quick email to express your enthusiasm. It shows initiative!
✨Tip Number 4
Stay updated on industry trends and tools. Being knowledgeable about the latest in data migration and insurance will make you stand out as a candidate.
We think you need these skills to ace Data Migration Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Migration Analyst role. Highlight your experience with SQL, TSQL, and any relevant data migration projects you've worked on. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data migration and how your background makes you a great fit for our team. Keep it concise but impactful – we love a good story!
Showcase Your Technical Skills: Don’t forget to showcase your technical skills in your application. Mention your proficiency in MS-SQL Server, SSIS, and any experience with Agile methodologies. We’re keen to see how you can contribute to our Data Migration Framework!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to submit all your documents in one go. Plus, it helps us keep track of your application!
How to prepare for a job interview at Tokio Marine HCC International
✨Know Your Data Inside Out
As a Data Migration Analyst, it's crucial to have a solid grasp of data mapping and transformation processes. Brush up on your SQL skills and be ready to discuss how you've handled similar projects in the past. Familiarity with insurance data and systems like Sequel Eclipse will definitely give you an edge.
✨Showcase Your Collaboration Skills
This role involves working closely with various teams, so highlight your experience in stakeholder engagement. Be prepared to share examples of how you've successfully collaborated with IT Project Managers or QA teams to ensure smooth data migrations. Communication is key!
✨Demonstrate Your Technical Expertise
Make sure you can talk confidently about your experience with tools like MS-SSIS and TSQL. Discuss any code you've developed and how it adhered to standards. If you've worked with ETL Control Frameworks, bring that up too—it's a big plus for this position.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving abilities in real-world scenarios. Think about challenges you've faced during data migrations and how you overcame them. Being able to articulate your thought process will show your analytical skills and readiness for the role.
