Migration Data Analyst
City of London
Hybrid (3/2 split)
Contract until February 2026
£880 - £906 per day (via Umbrella)
cer Financial are working alongside an international bank who are based in the City of London. They are seeking a Migration Data Analyst to work with them on a contract.
The responsibilities of a Migration Data Analyst will include:
- Data Lineage identification and Data Mapping
- Data Transformation and Validation – use ETL tools and develop scripts to transform data to the desired format or structure
- Data Quality Control, Collection and Cleansing: Identify and collect relevant data from multiple sources, including internal databases, external vendors, and APIs.
- Data Analysis, validation and Interpretation: Utilise tools to perform data analytics, including data blending, analysis, and modelling. Collaborate with business stakeholders to understand their requirements and translate them into data analysis tasks.
- Problem Solving and Testing: Technical skills to use data to support investigations and testing, understand how to get root cause of problems, working with SMEs and team members. Review and recommend improvements to processes, data, controls to support improving the Bank.
- Semantic recognition, Data Rules and tool configuration: A number of our programmes or work have a configuration component. The ability to use software solution to write, document, evaluation, test and improve these rules.
- Data Visualization and Reporting: Create visually appealing and interactive dashboards, reports, and visualizations using Power BI, Tableau, and Excel.
- Data Governance and Quality Assurance: Ensure data integrity, data privacy, and compliance with regulatory standards.
- Advice and Innovation: Provide advice to teams within the business about tools, data and skills. Have an innovation outlook, trying to find new ways of supporting and improving our business.
- Support Cutover Planning and Runbook Management
- User Coordination: Work with users on how to use the migrated data
- Post-Migration Validation
- Tech Authoring of documents that describe the cutover and implementation process developed.
- Develop an integrated relationship with the IT teams that will help build and test the technology to support the cutover and implementation approach
- Work with operations teams to design, develop and approve setup of reference/ static data for testing and go-live
- Coordinate with business process stakeholders to ensure that the business context and impacts are considered
- Post-Migration Review
- Stakeholder Communication: Regularly communicate with all stakeholders to keep them informed about the progress of the cutover and implementation and address any concerns they may have.
The successful Migration Data Analyst will have:
- Proficiency in ETL tools – Talend, Informatica, SSIS and with Migration tools – AWS DMS, Azure Data Migration Service
- Strong SQ skills and familiarity with database technologies – Oracle, SQL Server, MySQL
- University degree with over 10 years experience in data migration , data integration or similar role
- Experience in tooling (Alteryx, Informatica, Denodo, Power Query, Power BI, Tableau)
- Experience Microsoft technology
- Ability to use JIRA or Service Now Project Management tools
- Understanding of the data sets within a Bank that has an investment arm