BUSINESS DATA ANALYST
LONDON LIVERPOOL ST – HYBRID
CONTRACT UNTIL 28/02/2026
INSIDE IR35
Purpose of Job
The Data Office is looking to support all areas of the bank in making better use of data. This role is to be a Data Migration /Data Transfer – Business Data Analyst who can support migrations within multiple programmes or projects both large and small as part of the Bank’s Transformation. Working through a full lifecycle of Discovery, Definition, Design, Development, Deployment, and optimization.
The Business Data Analyst 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. Being part of a growing team, this opportunity allows the Business Data Analyst to contribute to the change on defining the migration strategy and framework, developing new core opportunities and using new tools which ultimately ensure the execution of effective migrations
The candidate must be willing to roll up their sleeves and engage in detail, as well as understand core technology and data design concepts with best practice
Background
The Data Office is requested to support and lead a number of Data Transfer and Data Migration projects which require Business Data Analyst expertise. We need to transfer and migrate various data elements eg securities clients into previously BI only IT systems and operational processes. This requires the transfer and or migration of client data, assets and liabilities both static and dynamic into new systems as well as improve referenced data configuration/ setup work in the systems to support our clients.
The intention is to use as standard a Data Transfer and Data Migration framework and approach supporting the overall strategy whilst identifying and using supporting tools for migration and trabsfer. There is also a goal to collaborate with the Data Analytics and Data Innovation teams and leverage the benefits of AI inc Generative AI to support Data Quality Assessments, Data mapping, Transformation, Anonymisation, Data validation, Optimisation of Migration paths, Predictive analysis, Migration monitoring, Semantic recognition, Data lineage and Data Migration testing.
Facts/ Scale
The data office has been established for nearly two years and is growing significantly. The bank is at the early stages of it data journey and it under going a number of programmes to change the way the bank works.
Accountabilities & Responsibilities
• Collaborate with stakeholders to gather and document business datarequirements 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.
• Wor 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.
• Collaboration and Communication: Collaborate with cross-functional teams, including business analysts, IT team, Divisions and decision-makers, communicate findings, recommendations, and insights to both technical and non-technical stakeholders effectively.
• 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: contribute to the development and execution of data migration and cutover tasks that need to be completed during the data migration preparation execution and cutover implementation
• 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
• 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: 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.
• Collaboration and Communication: Collaborate with cross-functional teams, including business analysts, IT team, Divisions and decision-makers, communicate findings, recommendations, and insights to both technical and non-technical stakeholders effectively
Knowledge, Skills, Experience & Qualifications
Essential:
• 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
Desirable:
• 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
If you believe you have the experience required, please apply with your CV now for instant consideration!
TO APPLY - PLEASE APPLY WITH AN UP-TO-DATE CV
Candidates will ideally show evidence of the above in their CV in order to be considered.
Please be advised if you haven't heard from us within 48 hours then unfortunately your application has not been successful on this occasion, we may however keep your details on file for any suitable future vacancies and contact you accordingly.
*Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone’s chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.