Role Purpose:

To support data migrations from 3rd party systems into the ALPHA system in a timely and controlled manner.  To provide subject matter expertise in the source and target data structures and support the data migration team.  To conduct IT Study, data discovery, assess source quality and identify strategies for dealing with deficiencies.  To gain assurance of the integrity and protection of the data throughout the migration.  To contribute to the identification and analysis of underlying data problems that causes issues in production.

͏Your Responsibilities:

Conduct & Fair Customer Outcome responsibilities - Putting customer’s interests at the heart of how we conduct business. Demonstrated through your individual behaviours with a clear focus on treating our customers fairly and delivering the right outcomes at all stages throughout the product lifecycle.

͏Key Responsibilities:

Role Accountabilities:

• Provide guidance to the other workstream migration specialists to deliver data migration services across multiple source system to ALPHA migrations, ensuring consistent approach across streams, compliance with ITGCs, and appropriate use of migration methodologies Design and implement appropriate migration controls to provide assurance on the integrity of the data migration and ALPHA data.
• Provide consultancy and technical expertise to Support the Migration team in working within clients data migration methodology.
• Act as the conduit between the IT Migration department and the business working with development, Products & Calcs, testing and other collaborators
• Transpose all input requirements and into Migration requirements in a timely fashion.
• Work with personnel in the source organisation to build understanding of the source data and the structure within which it is held.  This will involve facilitating workshops and meetings.
• Maintain an up-to-date understanding of the ALPHA data schema and update the ALPHA Data Dictionary as directed.
• Assist the migration team with the mapping of the source data to the ALPHA migration staging tables and resolve issues identified in a timely manner to ensure that there are no delays in the migration process.
• Support the data migration team in resolving mapping and migration issues and identify and alert the Migration Manager to new risks and issues.
• Assess the output of functional, calcs and data testing to ensure that the migration is accurate and meets go live criteria.
• Assist in the design and implementation of appropriate migration controls to provide assurance on the integrity of the data migration and ALPHA data.
• Identify opportunities for improvements to the data migration methodology
• Develop personal subject matter expertise in connection with each source system and share this knowledge with colleagues whom it could benefit
• Ensure that this knowledge is captured in a structured way, for example within a repository of data mapping documents to encourage reuse for the sake of efficiency and consistency

Accountabilities:

Risk Accountabilities:

• Contribute to the Risk & Control Self-Assessment (RCSA) for their consultative role in line with RCSA guidelines.
• To actively review, understand and articulate risk exposure within IT escalating concerns appropriately to the Migration & Specialist Projects Manager.

Change/Project Management Accountabilities:

• Contribute to and deliver data migrations to Servaada's client 
• Ensure all business needs are addresses and transposed into the migration deliverable
• Deliver proposed additional data assurance processes which would bring benefit
• Responsible for the consistent delivery of service and projects in order to safeguard delivery now and in the future
• To proactively identify areas/processes for change to continuously improve the Migration process, customer outcomes and our organisation

S͏kills:

Essential: 

• Excellent interpersonal, communication, and organisational skills
• Excellent stakeholder management, with the ability to upward manage communications and status
• Excellent task/delivery management with strong attention to detail
• Ability to manage multiple priorities in parallel, ensuring prioritisation on the most important/urgent topics 
• Proactive, tenacious, pragmatic problem solver
• Self-starter; ability to drive his/her own function day-to-day
• Able to communicate effectively at all levels within the organisation, with developers at a technical level and with the business in plain English
• Ability to make effective decisions and give direction under pressure
• Works co-operatively with people from other departments and builds value from relationships
• Proactively removes blockages to collaboration
• Gives accountability to Managers to form relationships and solve issues
• Shares best practice with other teams
• Breaks down barriers between teams
• Clear strength in working with data at the detailed level

Desirable:

• Good presentation and facilitation skills
• Tactful influencer and negotiator
• Conflict resolution
• Ability to work with diverse teams of professionals across organisations to plan for mutual success and to adapt plans as more information is discovered 

͏Knowledge:

• Extensive knowledge and understanding of Life and Pensions industry and asscoiated products, legislation/regulations
• Understanding of data analysis and migration techniques and concepts
• In-depth knowledge of ALPHA data structures and processes
• Awareness of the core components of the ALPHA system
• Keeping up to date with latest industry legislation/regulations
• Evidence of continuing professional development within professional field
• Experience of working in a regulated environment
• Good knowledge of project management processes
• Extensive knowledge and experience of use of  ETL concepts
• Knowledge of key factors influencing our business and the IT industry.
• Knowledge of migration cutover activities

Experience:

• Extensive hands-on experience of data analysis & migration techniques (ETL) and concepts.
• Experience in analysis, design, builds or manipulation of ALPHA data through approved tools and methodologies.
• Data mapping experience and experience of data/data structures within multiple L&P systems
• Experience of strategies for handling imperfect data
• Experienced in working within a risk control framework and contributing to successful risk outcomes
• Experience in continuous improvement in delivered implementations
• Proven experience of developing strategies for handling imperfect data
• Experience of working in a regulated environment
• IT Experience within Life and Pensions industry with the ALPHA system
• Experience of Waterfall and Agile development methodoligies
• Experienced in solution estimating.
• Experience working with third parties
• Experience in continuous improvement in delivered implementations
• Experience of working to tight deadlines in demanding situtations.
• Hands on experience of implementing IT solutions, partulary for a system cutover or migration.
• Experience of working in a regulated environment
• Previous experience as a Migration Specialist
• Good exposure to It project management processes
• Proven experience of migrating data
• A hands-on pragmatic approach to problem solving combined with good theoretical and practical experience of techniques and approaches

Application of Individual Conduct Rules:

Standard of conduct is reasonable under all circumstances relating to:

• Must act with integrity
• Must act with due skill, care and diligence
• Must be open and cooperative with the FCA and other regulators
• Must pay due regard to the interests of customers and treat them fairly
• Must observe proper standards of market conduct