Business Data Analyst - Migration

London Temporary £800 - £900 per day View Job Description
Business Data Analyst - Migration role will play a critical role in ensuring smooth data migrations between legacy and target systems by analysing business requirements, validating data accuracy, and collaborating with technical teams to drive data integrity and compliance.
  • Join a rapidly growing data function as a Business Data Analyst.
  • Experience in Business Analysis, data migration and technical data analysis.

About Our Client

A large international bank based in London.

Job Description

Business Data Analyst - Migration Responsibilities:

  • Collaborate with stakeholders to gather and document business data requirements for data migration and data transfer.
  • Analyse current and future data structures, business processes, dataflows, and dependencies to identify gaps and risks and ensure smooth data transition /transfer
  • Define data mapping, transformation rules, validation criteria and business logic for data transfer and data migration projects
  • Work closely with data engineers and migration teams to ensure accurate data extraction, transformation, and loading (ETL).
  • Support data reconciliation, integrity checks , validation, and cleansing activities to ensure quality and consistency.
  • Identify and resolve data discrepancies and ensure alignment with business rules.
  • Assist in data profiling and data lineage documentation to track historical changes and data movements
  • Act as a liaison between business users, data architects, IT teams, and vendors to facilitate smooth data transitions.
  • Translate business requirements into actionable data specifications for the transfer/ migration team.
  • Provide reports, dashboards, and insights to track data transfer/data migration progress and data integrity.
  • Ensure all data transfer/data migration activities align with data governance policies and regulatory compliance requirements.
  • Maintain data documentation, including data dictionaries, lineage, and standards.
  • Work with risk and compliance teams to ensure migrated data meets audit and reporting standards
  • Assist in developing strategies for data retention, archiving, and decommissioning of legacy systems.
  • Data Lineage identification and Data Mapping - map source data fields to target field. Document transformation rules and logic
  • Data Quality Control, Collection and Cleansing: Identify and collect relevant data from multiple sources, including internal databases, external vendors, and APIs. Perform data cleaning, transformation, and standardization processes to ensure data accuracy and consistency.
  • Problem Solving and Testing: 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.
  • Data Governance and Quality Assurance: Ensure data integrity, data privacy, and compliance with regulatory standards. Adhere to data governance processes to maintain data quality, consistency, and security. Identify and resolve data quality issues by conducting data audits and implementing appropriate data cleansing techniques.
  • User Coordination: Work with users on how to use the migrated data
  • Post-Migration Validation: Validate the migrated data in the target system to ensure it meets the required quality standards and supports the organisation's operations. Coordinate validation for the other systems as defined by other respective leads
  • Develop an integrated relationship with the IT teams that will help build and test the technology to support the cutover and implementation approach
  • Post-Migration Review: Conduct a post-migration review to identify any lessons learned and areas for improvement in future migrations
  • 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 Applicant

Business Data Analyst - Migration Skills and Experience

  • Proven experience in data migration or data transfer/ transition projects, preferably within financial services or regulated industries.
  • Strong SQL skills for data querying, validation, and reconciliation.
  • Experience with ETL tools and data transformation techniques.
  • Solid understanding of data modelling, data structures, and relational databases.
  • Proficiency in BI/reporting tools (e.g., Power BI, Tableau) for data visualisation.
  • Strong stakeholder management and ability to translate technical concepts for business users.
  • Knowledge of data governance, data quality, and compliance frameworks (e.g., GDPR, BCBS 239).
  • Experience with cloud data platforms (AWS, Azure, or Google Cloud) is a plus.
  • Principles of Data Governance and Data Quality
  • Data Remediation
  • Data Security and Handling within a Bank.
  • Documentation and Requirements Gathering
  • The Ability to solve problems, develop options and champion change
  • The ability to identify, manage and maintain Risk (RAID) Logs
  • The ability to defined and realise benefits
  • You must be able to work on multiple projects at one time, and be able to organise and priories work
  • University degree or equivalent with strong experience in data migration , data integration or similar role
  • Familiarity with 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



What's on Offer

  • £800 - 900 per day inside IR35 under an umbrella.
  • Opportunity to work within a respected organisation in the financial services industry.
  • Standard benefits associated with a temporary role.
  • Chance to enhance your career in data migration and analysis in London.



This is an excellent opportunity to contribute to significant projects within a dynamic industry. Interested candidates are encouraged to apply promptly.

Contact
David Stansfield
Quote job ref
JN-062025-6774038
Phone number
+44 207 776 5949

Job summary

Job function
Banking & Financial Services
Subsector
Business Analysis / Change / PMO
Sector
Financial Services
Location
London
Contract type
Temporary
Consultant name
David Stansfield
Consultant phone
+44 207 776 5949
Job reference
JN-062025-6774038