Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support a major data warehouse rebuild and ensure accurate data migration.
- Company: Join Tenth Revolution Group, the leading recruiter for Data & AI roles in the UK.
- Benefits: Work remotely with competitive pay and opportunities for growth.
- Other info: Dynamic role with excellent career advancement in a complex environment.
- Why this job: Make a real impact in financial services while honing your SQL skills.
- Qualifications: Strong analytical skills and deep SQL expertise required.
The predicted salary is between 50000 - 70000 £ per year.
We are seeking an experienced Data Migration Analyst / Engineer to support a major data warehouse rebuild for a wealth management firm undergoing a large-scale system and data migration programme.
Working closely with the Lead Data Engineer, this role will play a critical part in ensuring the new data warehouse accurately replicates existing outputs, while identifying and resolving any data gaps introduced during migration. This is a hands-on role requiring strong analytical capability, deep SQL expertise, and experience working in complex, regulated data environments.
- Perform source-to-target mapping, documenting field-level lineage across systems and transformation layers
- Analyse and interpret complex legacy SQL stored procedures (including multi-CTE logic, temp tables, and parameterised pipelines)
- Support data migration validation, ensuring accuracy and completeness of migrated datasets
- Conduct data reconciliation and gap analysis, identifying discrepancies between source and target systems
- Document data flows, transformations, and lineage in a clear and structured manner
- Support the design and validation of data models aligned to modern data warehouse practices
Requirements:
- Proven experience in data warehouse migration within complex environments
- Strong background in financial services, ideally wealth or asset management
- Advanced SQL skills, with the ability to independently analyse complex legacy code
- Data lineage documentation
- Migration validation and reconciliation
- Azure SQL Server
- SQL Server Management Studio (SSMS)
- Familiarity with wealth management CRMs (e.g., Azure Data Factory)
- Ability to review Power BI reports and identify field-level dependencies
Data Engineer, Home Based (remote) in London employer: Tenth Revolution Group
Contact Detail:
Tenth Revolution Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer, Home Based (remote) in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field, especially those who work in wealth management. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL expertise and any data migration projects you've worked on. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data migration scenarios. Be ready to discuss how you've tackled complex legacy systems and resolved data gaps in the past. We want to see your analytical skills in action!
✨Tip Number 4
Don't forget to apply through our website! We have loads of opportunities for data engineers like you. Plus, it’s a great way to ensure your application gets seen by the right people at Tenth Revolution Group.
We think you need these skills to ace Data Engineer, Home Based (remote) in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your SQL expertise and any experience with data migration projects, especially in regulated environments like financial services. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how your background makes you a perfect fit for our team. Don't forget to mention any relevant projects or experiences that showcase your analytical capabilities.
Showcase Your Technical Skills: When filling out your application, be sure to highlight your technical skills, especially in SQL and data migration. If you've worked with Azure SQL Server or similar tools, let us know! We love seeing candidates who can hit the ground running.
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you'll be able to keep track of your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at Tenth Revolution Group
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries and legacy code, as this role requires a deep understanding of SQL. Practise explaining your thought process when analysing stored procedures or performing data transformations.
✨Understand Data Migration Processes
Familiarise yourself with data migration methodologies and best practices. Be ready to talk about your experience with source-to-target mapping and how you've handled data validation in past projects. This will show that you can hit the ground running in this hands-on role.
✨Showcase Your Analytical Skills
Prepare examples of how you've conducted gap analysis and reconciled discrepancies in previous roles. Highlight your ability to document data flows and lineage clearly, as this is crucial for the position. Use specific scenarios to demonstrate your analytical capabilities.
✨Get Acquainted with Financial Services
Since this role is within wealth management, it’s beneficial to have a grasp of the financial services landscape. Research common challenges in data migration for this sector and be ready to discuss how your background aligns with their needs. This will help you stand out as a candidate who understands the industry.