Data Migration Specialist
- Work closely with the Data Migration Lead to interpret and understand stakeholder requirements in relation to data migration and document how these are to be realised (with reference to the target environment).
- Work closely with other New Core colleagues (e.g. data cleansing staff, subject matter experts) and business stakeholders to interpret and understand stakeholder requirements in relation to data migration and document how these are to be realised (with reference to the target environment).
- Analysis and design of migration code using the standard programming team documentation where appropriate
- Provide support and advice to key business stakeholders with respect to particular data migrations
- Work within the standards and constraints of the team and New Core programme operating procedures.
- Carry out application development using appropriate combinations of PL/SQL, T-SQL, classic ASP and ASP.NET (C# or VB).
- Management of code projects using the standard New Core Team source control systems.
- Management, prioritisation and progressing of defect recording, management, prioritisation and resolution.
- In conjunction with the Data Migration Lead utilise ITIL change management processes to manage deployment of migration code to the required platforms.
- Testing of migration code against appropriate test target environments, again using ITIL change management disciplines as appropriate.
- Prioritise workloads to ensure data migrations run to schedule at a known and agreed level of data cleanliness.
- Utilise the Universitys Service Now facility for recording problems and changes as advised by the Data Migration Lead.
- The post holder is required to conduct the majority of the work on his/her own and as such the post holder must have good communication skills and be able to show initiative and flexibility.
Required Knowledge, Skills, Qualifications, Experience
- A minimum of 1-2 years experience of development using classic ASP and/or VB.NET and/or C# in creating ASP.NET systems.
- Demonstrable experience of database programming for either Oracle (PL/SQL) or SQL Server (Transact-SQL).
- Able to communicate technical matters to people with a wide range of computer literacy.
- Able to work to deadlines, without close supervision and within a team.
- Willingness to acquire new skills and understanding.
- An understanding of the importance of testing and quality control.
- Good broad knowledge of IT, including latest technology industry trends, particularly in the area of application software.
- Ability to communicate and engage with non-IT staff effectively using oral and written skills.
- Strong technical and analytical, problem solving skills.
- Experience in working with projects teams to deliver complex solutions within agreed timescales.
- Communicate proactively and regularly with team members and the wider organisation regarding progress.
- Identify, clarify, and resolve issues and risks, escalating them as needed.
- The ability to work using their own initiative and manage own workload within agreed deadlines and tolerances.
- Educated to degree level in a technical discipline
- An ITIL qualification or experience of applying ITIL frameworks and disciplines.
- Exposure to project management methodologies such as Agile (e.g. working using Scrum, Kanban).
- Knowledge and working experience of Master Data Management concepts and processes.
- Database knowledge and experience
- Personal characteristics:
- Strong intellectual abilities.
- Detail oriented individual with proven analytical skills.
- Judgement and resilience.
- Critical thinking and excellent problem solving skills.
- Honesty and integrity, energy and resilience.
- An understanding of and empathy for the activities/objectives of the University.
- The postholder will be required to work closely with members across the other New Core workstreams, in particular Data and BI, to achieve the outcomes and benefits of the New Core programme.
- The business processes and technical changes arising from the preparation, integration, migration and release of the New Core functionality are likely to have university-wide implications on current practices and processes.
- The post holder will deliver continuing support and development (where required and agreed) for wider support and development of data migration requirements across the University.
Planning and organising:
- The broad remit of the role will be presented to the postholder, who will then be expected to define and manage workload to achieve that remit. Guidance will be available from the New Core workstream leads, in particular the IT and Data workstreams.
Problem solving and decision making:
- The postholder will need to demonstrate significant problem analysis and solving skills, both relating to the design and migration to new business processes in the New Core release. In dealing with problems, the postholder will be expected to liaise with key stakeholders, taking responsibility when required to identify solutions and make recommendations that meet business requirements.
- The postholder will be required to take decisions without reference to others that relating to the day to day support of the New Core data migration provision.
- After consultation with others, the postholder will be required to take decisions on change design as part of the regular programme Working Group activity, development of data migration aspects of the project plan with the IT and Data workstream leads.
Internal and external relationships:
- The postholder will be required to communicate with a wide range of stakeholders across the University and provide both formal and informal feedback to stakeholders in the New Core project. Additionally, the postholder will work closely and maintain relationships with the representatives of the selected New Core implementation partner.