Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the migration of Parliamentary digital records and ensure data integrity.
- Company: Join The National Archives, preserving the UK's rich history for future generations.
- Benefits: Enjoy hybrid working with 3 days at our beautiful Kew site and remote flexibility.
- Why this job: Make a real impact on how future generations access public records in a unique project.
- Qualifications: Strong SQL and SPARQL skills required; experience with ETL processes and handling sensitive data.
- Other info: SC clearance is needed; must have been a UK resident for at least three years.
The predicted salary is between 36000 - 60000 ÂŁ per year.
Drive the Data Migration That Will Shape the Future of UK Archives
The National Archives is the home of the nation’s history, preserving centuries of records that shape our collective memory. As we prepare for the next era of digital preservation, we need a Data Migration Engineer to take on one of the most critical data projects in our history.
This is not just another migration project. This is about ensuring that Parliamentary digital records and historic digital Public Records are seamlessly transferred to a new platform—accurately, securely, and in a way that will be accessible for future generations.
You’ll reverse-engineer, extract, transform, and migrate complex metadata, working across SQL, SPARQL, and XML-based structures to ensure that the UK’s digital history remains structured, searchable, and usable.
What You\’ll Be Doing:
- Leading the hands-on migration of Parliamentary digital records & Digital Preservation (DRI) system data.
- Extracting, transforming, and loading (ETL) complex metadata from SQL (Oracle/MySQL) and SPARQL (Jena Fuseki) databases.
- Documenting data models, identifier schemes, and relationships to support migration integrity.
- Building & optimizing SQL and SPARQL queries to ensure accurate, efficient data extraction.
- Validating and testing migration outputs to ensure completeness, accuracy, and usability.
- Collaborating with digital archivists, data engineers, and IT teams to shape best practices for digital records migration.
- Working with sensitive records in a security-controlled environment, ensuring compliance with archival standards.
What We’re Looking For:
- Strong SQL and SPARQL skills, with the ability to extract, transform, and migrate structured & unstructured data.
- Experience handling XML-based metadata within SQL databases.
- Hands-on experience in large-scale data transformations, migrations, or ETL processes.
- Ability to reverse-engineer undocumented databases, identifying data relationships & structures.
- A methodical, problem-solving mindset—you’re not afraid of messy data and love making sense of complex information.
- Confidence working independently, making critical migration decisions in a structured, well-documented way.
- Familiarity with data governance, validation, and quality assurance processes.
- Ability to work within security and compliance frameworks, handling sensitive data appropriately.
Why Join Us?
A Career-Defining Project – This is a unique, high-impact migration that will shape how the UK’s digital history is preserved.
Enjoy hybrid working (3 days per week at our beautiful Kew site, with remote flexibility).
Your work will directly impact how future generations access and understand public records.
Work alongside some of the best digital preservation specialists in the country.
This is not a routine migration—you’ll be working with unique, historically valuable datasets, requiring creative solutions and technical expertise.
This is a rare opportunity to take on a project that truly matters. If you’re ready to bring your data engineering, transformation, or archival expertise to one of the world’s leading digital archives, apply today!
How to apply:
If you are an internal applicant: please do not use the link on this page. Please apply via your employee Workday account.
If you are an external applicant: to submit your application please click the \’Apply\’ button on this page.
You will be asked to provide details of your work experience and write a personal statement, not exceeding 1200 words. In your personal statement please explain, using examples, how you meet the essential criteria given below. You may draw on knowledge, skills, abilities, experience gained from paid work, domestic responsibilities, education, leisure interests and voluntary activities. Please note selection for interview will largely be based on the information you provide in this section.
SC clearance/willingness to obtain SC clearance will be required for this role. This requires candidates to have been resident in the UK for at least the past three years. Please do not apply if you have been resident in the UK for less than three years as your application will be rejected.
Essential Skills & Experience:
- Advanced SQL and SPARQL skills, with experience handling structured and unstructured data (including XML within SQL tables).
- Knowledge of graph databases and triple stores.
- Experience in data migration, including extract, transform, and load (ETL) processes.
- Strong scripting and automation skills to improve data extraction, validation, and transformation.
- Ability to design and optimize database queries for performance and accuracy.
- Strong problem-solving skills, with a structured approach to data auditing and issue resolution.
- Experience working with sensitive or restricted data under security-controlled environments.
Desirable Skills & Experience:
- Familiarity with metadata standards such as Dublin Core.
- Experience working within digital archives or large-scale information repositories.
- Python, Shell scripting, or other automation tools such as Talend, Informatica or Pentaho for data transformation.
- Awareness of Agile methodologies and collaborative development practices.
#J-18808-Ljbffr
Data Migration Engineer employer: The National Archives
Contact Detail:
The National Archives Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Migration Engineer
✨Tip Number 1
Familiarize yourself with the specific data structures and metadata standards mentioned in the job description, such as SQL, SPARQL, and XML. Understanding these technologies will not only help you during the interview but also demonstrate your commitment to the role.
✨Tip Number 2
Showcase your problem-solving skills by preparing examples of past projects where you successfully handled complex data migrations or transformations. Be ready to discuss how you approached challenges and what solutions you implemented.
✨Tip Number 3
Network with professionals in the digital preservation and data migration fields. Engaging with experts can provide insights into best practices and may even lead to referrals that could strengthen your application.
✨Tip Number 4
Research The National Archives and their current projects. Understanding their mission and recent initiatives will allow you to tailor your discussions during the interview, showing that you are genuinely interested in contributing to their goals.
We think you need these skills to ace Data Migration Engineer
Some tips for your application 🫡
Understand the Role: Before you start writing your application, make sure you fully understand the responsibilities and requirements of the Data Migration Engineer position. Familiarize yourself with the specific skills mentioned in the job description, such as SQL, SPARQL, and ETL processes.
Craft Your Personal Statement: Your personal statement is crucial. Use it to highlight your relevant experience and skills. Provide specific examples that demonstrate how you meet the essential criteria, particularly your advanced SQL and SPARQL skills, and your experience with data migration and handling sensitive data.
Showcase Problem-Solving Skills: Since the role requires a methodical, problem-solving mindset, include examples in your application where you've successfully tackled complex data issues or migrations. This will show that you can handle the challenges of the position.
Review and Edit: After drafting your application, take the time to review and edit it thoroughly. Ensure that your writing is clear, concise, and free of errors. A well-polished application reflects your attention to detail, which is vital for this role.
How to prepare for a job interview at The National Archives
✨Showcase Your SQL and SPARQL Skills
Be prepared to discuss your experience with SQL and SPARQL in detail. Highlight specific projects where you extracted, transformed, or migrated data, especially if you worked with complex metadata or XML-based structures.
✨Demonstrate Problem-Solving Abilities
Expect questions that assess your problem-solving skills. Prepare examples of how you've tackled messy data or resolved issues during data migrations. A methodical approach will impress the interviewers.
✨Understand Data Governance and Compliance
Familiarize yourself with data governance principles and compliance frameworks relevant to handling sensitive records. Be ready to discuss how you ensure data integrity and security in your previous roles.
✨Prepare for Technical Questions
Anticipate technical questions related to ETL processes and database optimization. Brush up on your scripting and automation skills, as these may come up during the interview to gauge your technical expertise.
