Job Description
We are recruiting for a Data Migration Analyst, you will be responsible for supporting the Implementation Leads in migrating data from the legacy operating systems to the commercial insurance partnered integrated systems, primarily supporting implementations in the United Kingdom and Ireland.
Overview of duties
* 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 cleanup 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 cleanup needed
* 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
* 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/SQ
Person specification
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
* 3 or more years of Broker Management experience
* 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
Key information:
Hours: Monday – Friday, 35 Hours
Location: Remote, occasional travel to UK and US offices when required
If this sounds like something you are interested in please apply, or contact Lucy Reed for further information.