Data Migration Consultant
Edinburgh / £50000 - £53000 annum
INFO
£50000 - £53000
LOCATION
Edinburgh
Permanent
Consultant - Data Migration
Location: Edinburgh (Hybrid, 2 days per week in the office)
Salary: Up to £53,000
The Company
A specialist consultancy team within a global professional services firm is seeking a Consultant to join their Investment Management & Wealth (IM&W) practice. The team focuses on end-to-end technology transformation projects for clients across the wealth management, savings, and retirement sectors. This role provides the opportunity to work on multi-year programmes at the intersection of business operations and data strategy.
The Role
As a Consultant - Data Migration, you'll play a key role in helping clients successfully transition from legacy systems to modern wealth platforms. You'll work closely with client and vendor teams to support the data aspects of large-scale technology transformation programmes. From handling data sets and validating data constructs to enabling seamless migrations, your work will directly impact business operations and client outcomes.
Key Responsibilities
- Data Migration & Transformation
- Handle large datasets and ensure integrity throughout the migration lifecycle.
- Support ETL processes and prepare data for transition into modern wealth platforms.
- Liaise with client and vendor teams to understand data structures and define mapping logic.
- Business Insight & Client Engagement
- Interpret client data to identify gaps and suggest improvement areas.
- Provide technical support and documentation for data migration processes.
- Collaborate with internal consultants and external stakeholders to ensure successful delivery.
Skills & Experience
- Essential:
- 1-4 years of experience in consulting, data migration, or transformation projects.
- Strong understanding of data structures within a wealth management or financial context.
- Familiarity with ETL processes and data validation techniques.
- Effective communicator with the ability to manage stakeholders and explain data insights clearly.
- Desirable:
- Exposure to leading wealth management platforms such as FNZ, SS&C, Avaloq, GBST.
- Experience with data migration or software delivery tooling (e.g. JIRA).
- Background in consultancy or advisory firms supporting financial services.
Benefits
- Salary up to £53,000
- Hybrid working - 2 days per week in Edinburgh office
- Structured learning and development in a globally recognised firm
- Exposure to high-impact transformation projects with tier-one clients
How to Apply
Interested? Send your CV to Mohammed Buhariwala at Harnham via the Apply link on this page.
Keywords
Data Migration, ETL, FNZ, Avaloq, SS&C, Wealth Management, Data Consultant, Platform Transformation, Financial Services, Hybrid Working, Edinburgh

SIMILAR
JOB RESULTS

Analytics Consultant
Manchester
£50000 - £60000
+ Advanced Analytics & Marketing Insights
PermanentManchester, Greater Manchester
Analytics Consultant
Up to £60,000
Hybrid – Manchester (2x days per week)
THE COMPANY
Our client is a digital marketing agency that delivers analytical solutions to enhance their clients’ digital performance.
THE ROLE
In this role, you will support clients by leveraging analytical and data techniques to improve their advertising and marketing campaigns.
SKILLS
Expertise across Marketing, Digital and Customer Analytics
SQL
Python
Google Analytics or Adobe Analytics
APPLY
Register your interest by sending an email

Technical CRM Automation Manager
Leicester
£50000 - £60000
+ Advanced Analytics & Marketing Insights
PermanentLeicester, Leicestershire
To Apply for this Job Click Here
Technical CRM Automation Manager
Up to £60,000 + bonus
Hybrid – Leicester (2x days in the office)
THE COMPANY
We are working with a Software Development company that offer a global platform to over 4 millions users.
THE ROLE
In this role, you will have the opportunity to manage the customer lifecycle, with a strong focus on automating lifecycle journeys. The ideal candidate will have experience coding in Liquid within Braze, optimizing push campaigns, managing Braze APIs, and building HTML templates.
SKILLS
Liquid within Braze
HTML
Experience optimizing push campaigns
APPLY
To register your interest, send an email
To Apply for this Job Click Here

Data Engineer (Contract)
London
£400 - £450
+ Data Engineering
ContractLondon
To Apply for this Job Click Here
We are partnering with a client undergoing a critical transformation of their data infrastructure and CRM capabilities. They are seeking a hands-on Data Engineer with strong AWS experience to support two key initiatives: finalising a Braze CRM integration and migrating legacy R-based data pipelines to a modern cloud-native stack.
Phase 1: CRM Data Engineering (Month 1)
-
Support the CRM team with data engineering requests.
-
QA, deploy, and monitor data pipelines that push third-party formatted data into Braze.
-
Manage ad hoc CRM data tasks including journey updates and API integrations.
-
Work extensively within AWS using Lambda, API Gateway, and Python to maintain and enhance integrations.
Phase 2: Legacy Pipeline Migration (Months 2-3)
-
Analyze and understand existing R-based data pipelines created by data scientists.
-
Migrate these pipelines into Airflow, dbt, and Terraform workflows.
-
Modernize and scale legacy infrastructure running on AWS.
-
Collaborate with engineering teams to ensure a smooth transition and system stability.
Languages & Scripting:
-
Python (primary scripting language for Lambda functions)
-
SQL (BigQuery, Redshift)
-
R (not essential but beneficial for interpreting existing scripts)
Cloud & Infrastructure:
-
AWS services including Lambda, API Gateway, S3, CloudWatch, Kinesis Firehose
-
Terraform for infrastructure as code
Orchestration & Transformation:
-
Apache Airflow
-
dbt
CRM & Marketing Tools:
-
Braze (preferred)
-
Familiarity with other CRM/marketing automation tools such as Iterable or Salesforce Marketing Cloud is a plus
Candidate Profile
-
Proven commercial experience as a data engineer; industry background is not critical.
-
Hands-on, pragmatic, and able to deliver quickly with minimal supervision.
-
Strong communicator, able to clearly explain technical decisions and project status.
-
Willing to take on essential but sometimes “tedious” tasks without hesitation.
-
Practical attitude, especially when working with legacy systems or imperfect code.
-
Ideally, experience migrating legacy scripting environments (e.g., R to Python) to modern pipelines.
To Apply for this Job Click Here

AWS Engineer
London
£400 - £450
+ Data Engineering
ContractLondon
To Apply for this Job Click Here
AWS DATA ENGINEER
3-MONTH CONTRACT
£400-£450 PER DAY OUTSIDE IR35
FULLY REMOTE
This role offers a great opportunity for an AWS Data Engineer to join a fast-paced media company working on a cutting-edge data ingestion and transformation project. You’ll take ownership of end-to-end pipeline development, integrating real-time data streams and third-party APIs into a modern analytics stack. The environment promotes autonomy, modern tooling, and close collaboration across technical and business teams.
THE COMPANY
This is a leading media organisation leveraging data to drive audience insights, engagement strategies, and targeted content delivery. They are investing heavily in their data platform and tooling, with an emphasis on real-time decision-making and scalable infrastructure. You’ll be joining a team focused on delivering data into key business systems including CRM and analytics layers.
THE ROLE
You’ll be part of a cross-functional data engineering team responsible for ingesting, transforming, and delivering data to critical internal systems. This includes designing scalable AWS-based pipelines, integrating external APIs, and orchestrating transformations using DBT and Airflow. You’ll also support the transition of R-based data streams into more maintainable Python workflows.
Your responsibilities will include:
-
Building and maintaining ingestion pipelines using AWS Lambda, API Gateway, and Kinesis.
-
Integrating third-party APIs into the data platform and transforming data for CRM delivery.
-
Migrating R-based data streams into modern Airflow-managed Python/DBT pipelines.
-
Ensuring observability and reliability using CloudWatch and automated monitoring.
-
Supporting both BAU and new feature development within the data engineering function.
KEY SKILLS AND REQUIREMENTS
-
Proven experience with AWS services including Lambda, API Gateway, S3, Kinesis, and CloudWatch.
-
Strong programming ability in Python and data transformation skills using SQL and DBT.
-
Experience with Airflow for orchestration and scheduling.
-
Familiarity with third-party API integration and scalable data delivery methods.
-
Excellent communication and the ability to work in a collaborative, agile environment.
HOW TO APPLY
Please register your interest by sending your CV via the apply link on this page.
To Apply for this Job Click Here

CAN’T FIND THE RIGHT OPPORTUNITY?
STILL
LOOKING?
If you can’t see what you’re looking for right now, send us your CV anyway – we’re always getting fresh new roles through the door.