Data Migration Analyst

 Location: Edinburgh
 Salary: Excellent
 Job type: Permanent
 Closes: closed

Meraki Talent’s global FinTech client based in Edinburgh are looking for Data Migration Analyst to join them on a permanent basis. This is an excellent opportunity to join a fast growing global business.

Working within our specialist internal Migrations team, the Data Migrations Analyst will be responsible for ensuring all required data is identified, appropriately transformed and accurately migrated from the source system(s) to the product suite. Data Migration Analysts will be aligned to a specific customer migration and will be expected to collaborate closely with their counterparts to ensure that the customer and internal outcomes are met to the highest standard.


Responsibilities of the Data Migration Analyst;

  • Identifies source data requirements
  • Develops and maintains knowledge of target system ongoing project development with particular focus on the impact to current and future migration
  • Identifies, documents and validates target data requirements
  • Assesses source data quality including gap analysis and supporting clients with data cleansing activities
  • Working closely with the client and the Business Readiness team to analyse and understand the asset migration requirements, defining a solution which meets all parties needs
  • Defines business rules for handling source data
  • Articulating the requirements of the target data architecture to define the data transformation requirements
  • Maps source, staging and target data architectures to each other including rules and transformations
  • Creation and maintenance of key migration artefacts: entity relationship diagrams (ERD), business rules and schema
  • Support and promote the ongoing design and improvement of data migration procedures and artefacts
  • Educates and prepares customers (external and internal) on the core Migration process, functionality and business processes
  • Promotes existing functionality, processes and 3rd party agreements wherever possible
  • Ensures that any new business developments adhere to procedural and regulatory compliance requirements
  • Proactively manages changes to requirements to ensure all parties have a full understanding of the required changes and the system/ process/ project implications
  • Works with developers, analysts, managers and clients to implement the end to end migration process, ensuring all agreed scope items are migrated from source to target in line with client and propositional requirements.
  • Provides post implementation support once the migration is complete to support both the project and service & support teams in issue identification and resolution.
  • Triages and investigates service log issues in both test and production, ensuring any issues are dealt with by the appropriate person or team 


Background of the Data Migration Analyst;


  • Degree qualified 2:1 or above or equivalent;
  • Experience in Finance, IT or project management desirable but not essential;
  • Confident, and able to take initiative given client– and delivery-focused environment;
  • Independent, self-directing and delivery focused working style;
  • Superior analytical thinking;
  • Commercially aware;
  • Intermediate computer skills essential;
  • Excellent organisational, administration and time management skills;
  • Good team communication skills, confident in dealing with internal and external clients;
  • Highly developed written and oral communication skills;



  • General investment/ wealth/ life and pensions products
  • Bonds & Trusts
  • UK Financial Services Compliance
  • Corporate Actions & extended investment ranges
  • Wrap Platforms
  • Data Transformation and Mapping
  • Experience in using ETL tools e.g. Microsoft SSIS, Informatica


Is this job for you?  At Meraki, we love recruitment and love words. Is this you?

Please see our website page headed (e.g.) ‘Privacy Notice’ for an explanation about how we use information we collect about you’

Data Analyst ETL Informatica Migrations SSIS

Meraki Talent values diversity in our own workforce and we actively support our clients to build diverse and inclusive workplaces. For all our roles, both internal and those on behalf of our clients, we welcome enquiries from everyone

Apply now

Request call back

Business Manager - IT & Change

Andy MacEwan

In 2018 Andy joined Meraki Talent, with a focus on technology and change roles across Scotland. Andy is an experienced recruiter with an impressive list of successful placements having worked in the industry for over 15 years. Andy has a strong background delivering a variety of recruitment solutions covering permanent recruitment, fixed term contracts, managed services and statements of work across technology and business change.