Data Migration Technical Analyst (18 Month FTC)

Merlin Jobs ,
Basingstoke, Hampshire

Overview

Job Description

Data Migration Technical Analyst (18 Month FTC) A job with Merlin isn't like a job anywhere else. With attractions around the world, from roller coasters to wax figures, we don't trade in suits, handshakes or briefcases. We trade in fun. In smiles, shrieks and spine-tingles. In Memories. In magic. But there are no tricks behind our magic. Instead, there are people like you. Passionate, dedicated people who are committed to making sure our worldwide attractions and guests' experiences are the best they can be. We are currently recruiting for a Global Process Analyst to join our Finance Project Team based in Basingstoke. SCOPE "Finance 21" is a key strategic programme for Merlin. The Data Migration Technical Analyst exists to deliver the data migration effort for the implementation of the global finance system , NetSuite. This is achieved through he effective planning, capture and translation of data migration requirements into the design and execution of the migration effort for the NetSuite solution. MAIN RESPONSIBILITIES * Responsible for all aspects of Data Migration, supporting the Data Migration approach. * To work with the ERP System Integrator, supplier and internal resources to deliver the migration of data from F21 legacy finance systems, onto a new consolidated ERP SaaS System (NetSuite) as well as dependent data updates in legacy systems. * To identify, document and validate data migration scope, risks, constraints, dependencies and assumptions. Ensuring a thorough and controlled documentation process.To coordinate the delivery of all aspects of the data migration plan utilising internal and supplier resources. To include definition of all data requirements for the build, test and cutover project phases. * Enforce policies for the effective management of data, and the migration of data to the organisation's new ERP system. * Legacy data identification and mapping from legacy systems to the new system. * Managing to extract, stage, cleanse, transform and load of the data into the target solution (transactional and master). * Work with the system integrator to ensure an optimal approach to the upload of legacy data into the new system, together with ensuring a smooth process for the resolution of upload issues. * To co-ordinate all aspects of data cleansing, including coordinating BAU resources within the business functions. SKILLS, EXPERIENCE & QUALIFICATIONS Essential * Microsoft SQL Server (2008 and beyond) * Advanced T-SQL Query Skills * T-SQL Performance tuning * Experience of ERP Level or similar Data Migration Projects * Experience of working with Oracle NetSuite or similar finance SaaS ERP * Knowledge of legacy systems * Demonstrable knowledge of Data Migration and Data Management Techniques * Experience in working with in-house and supplier resources to deliver to programme timescales * Ability to co-ordinate and supervise resources that will assist with data cleansing and mapping Desirable * SQL Integration Services (SSIS) * Oracle NetSuite * Cloud Technologies * Confident in your ability to learn new systems and to get up to speed quickly * Eye for detail without losing sight of the overall outcome of the deliverable you are working on COMPETENCIES * Strong analytical skills * Strong verbal and written communication skills, along with well-developed interpersonal skills and an ability to relate to a variety of individuals * Strong personal organisation and time management skills * Effective, professional relationships and partnerships are developed and maintained with internal and external contacts * Confident dealing with senior stakeholders * Ability to be flexible * Ability to self-manage THE BENEFITS We're growing fast and alongside a fun and friendly environment, we offer a fabulous package and amazing prospects - ideal if you're already fantastic and can quickly become even better (our magic can help here). Benefits include: * Pension; * Life Assurance; * Discretionary company bonus; * 33 days' holiday (including bank holidays); * Merlin Magic Pass which gives you and your friends and family free admission to all of our attractions worldwide, as well as 25% discount in our retail shops and restaurants and 40% discount on LEGO. * Excellent working environment located in our new offices on a vibrant Business Park which offers facilities such as a cafe, gym and nursery.