Data Migration Analyst

Data Migration Analyst

Location: Remote (Occasional travel to Birmingham)
Salary: up to £70,000

Please note - the company will only consider applicants who have a full right to work in the UK, and they can't offer any sponsorship! 

A fantastic opportunity has come up for a Data Migration Analyst to join an exciting and innovative organisation as they continue to grow all areas of their teams, with a huge focus on Data.

They are looking for someone who will be responsible for supporting the implementation leads and migrating data from legacy to operating systems.

Responsibilities

• Facilitate data reviews to ensure on-time completion and data quality
• Become knowledgeable in the flow of information (data/documents/transactions/messages)
• Track migration issues to ensure these are reported, fixed and validated
• Ensure various milestones are met in accordance with the project plan and timeline
• Determine where custom scripting may be required, clarify the details and validate the results
• Obtain data from legacy broker management systems in various formats 
• Format the data into a standard template, often using Microsoft Excel, Microsoft SQL, Alteryx or other analytics applications
• Collaborate with the business, the onboarding brokerage and/or Implementation leads to facilitate clean-up and complete mapping the data from source to destination
• Prepare and format Insurer and Employee lists for discussions with the brokerage and configuration into the destination broker management system
• Validate data using various reports and migration tools to determine any migration issues or further clean-up needed
• Liaise with our conversion vendor to ensure project requirements are specified and discuss any conversion questions and impacts
• Liaise with business representatives, developers, and Project Leads to address any data issues and ensure compliance with migration standards
• Write database extracts, analyse tables, and write extraction procedures using technologies such as Oracle PL/SQL

Knowledge, skills and abilities:

• Advanced Microsoft Excel skills including lookups, other formulas and pivot tables
• Ability to communicate complex migration issues to non-technical stakeholders
• Strong analytical skills and creative problem-solving capabilities
• Ability to take on a variety of projects and adapt to changing business needs
• Professional presentation skills and strong interpersonal skills
• Willingness and flexibility to adjust to and conform with changing timelines and schedules
• Ability to work with colleagues and clients across all time zones as necessary

 Education and/or Experience: 

• Alteryx experience is preferred
• Microsoft SQL Server experience
• Experience with migration of data from one system to another
• Prior involvement with an organization’s system implementation
• Ability to self-teach and mentor others in data migration processes
• Experience in Applied Systems Epic software

If you feel you have the required skills and experience and would like to be considered for this opportunity, please forward an up-to-date version of your cv, and someone will contact you back within 48 hours.