Senior Data Migration Architect – Transfer Agency Expert

DB Recruitment; Dublin; On-site; EUR 105,000 - 145,000; Full time

Job summary

DB Recruitment is seeking an experienced Senior Data Migration Consultant to support a major financial services transformation in Ireland. The role focuses on transferring agency data, data mapping, validation and reconciliation across legacy and target systems, with AI/automation enhancements.

The candidate will lead complex migrations, work with TA operations teams and SMEs, and drive end-to-end data governance and quality controls throughout the project lifecycle.

Qualifications

• Significant experience delivering large-scale data migration or data conversion programmes within financial services.
• Strong hands-on experience migrating data between legacy and modern financial services platforms.
• Transfer Agency data migration experience is highly desirable/preferred.
• Excellent SQL skills and ability to work with large, complex datasets.

Responsibilities

• Lead and execute complex data migrations from legacy financial services platforms to new target systems.
• Analyze source and target data structures and develop detailed migration and mapping requirements.
• Extract, transform, cleanse and load large volumes of financial services data.
• Take responsibility for Transfer Agency data migration, including investor, account, transaction, fund and related reference data.
• Develop and execute data mapping, transformation and conversion rules.
• Perform data profiling and identify data-quality issues ahead of migration.
• Design and execute migration reconciliation and validation processes to ensure completeness and accuracy.
• Work closely with Transfer Agency operations teams and SMEs to understand complex business and data requirements.
• Support migration rehearsals, mock conversions, cutover planning and production migration.
• Investigate and resolve migration defects, exceptions and reconciliation breaks.
• Ensure appropriate controls, audit trails and documentation are maintained throughout the migration lifecycle.
• Support data governance, lineage and regulatory requirements.
• Work closely with programme managers, business analysts, developers, architects, testing teams and vendors.
• Identify opportunities to use AI, machine learning and automation to improve data mapping, cleansing, reconciliation, testing and migration efficiency.

Skills

SQL

Transfer Agency data migration

Data migration

Stakeholder management

Tools

ETL/ELT

Data integration technologies

Job description

DB Recruitment is seeking an experienced Senior Data Migration Consultant to support a major financial services transformation in Ireland. The role focuses on transferring agency data, data mapping, validation and reconciliation across legacy and target systems, with AI/automation enhancements.

The candidate will lead complex migrations, work with TA operations teams and SMEs, and drive end-to-end data governance and quality controls throughout the project lifecycle.