Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead complex data migration activities and ensure data accuracy across multiple systems.
- Company: Join a forward-thinking organisation focused on major systems transformation.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic work environment with a focus on innovation and collaboration.
- Why this job: Make a real impact by transforming data and enhancing business operations.
- Qualifications: Experience in data migration, SQL, and strong stakeholder engagement skills.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking an experienced Data Migration Lead to take ownership of complex data migration activities as part of a major systems transformation programme. The successful candidate will be responsible for leading the end-to-end migration of data from multiple legacy systems into a modern target platform, ensuring accuracy, integrity, and full reconciliation across all datasets.
This role requires strong technical expertise in SQL, ETL processes, and data transformation, combined with the ability to work closely with business stakeholders, SMEs, and third-party suppliers to define and deliver migration requirements. The environment includes large-scale housing, financial, and operational datasets, often originating from multiple legacy systems with varying levels of data quality and structure.
Key Responsibilities- Lead the full lifecycle of data migration activities from legacy systems to target platforms
- Analyse and profile complex datasets across multiple source systems
- Design and implement data migration strategies, processes, and execution plans
- Develop and maintain data mapping specifications and transformation logic
- Ensure alignment with supplier-led migration frameworks and delivery schedules
- Work with SMEs and business users to gather and define data migration requirements
- Analyse legacy data structures and define business rules for migration
- Contribute to the development of target data models and architecture
- Identify gaps, inconsistencies, and structural issues in legacy datasets
- Design and implement ETL processes using SQL Server, SSIS, or equivalent tools
- Extract, transform, cleanse, and load data from multiple legacy systems
- Write and optimise SQL scripts, stored procedures, and data transformation logic
- Ensure high performance and scalability of migration processes
- Identify and resolve data quality issues, duplicates, and inconsistencies
- Define and enforce data validation and cleansing rules
- Ensure all migrated data meets required quality, integrity, and compliance standards
- Support GDPR and data protection requirements when handling personal data
- Lead unit testing, system integration testing (SIT), and user acceptance testing (UAT) of data loads
- Produce detailed reconciliation reports comparing legacy vs target systems
- Support defect resolution and reprocessing of data loads where required
- Ensure full auditability of migration outputs
- Act as primary interface between business SMEs, technical teams, and suppliers
- Facilitate workshops to define data definitions, mapping rules, and migration scope
- Communicate complex technical issues in a clear, business-friendly manner
- Provide regular progress updates and risk/issue reporting
- Proven experience as a Data Migration Lead or Senior Data Migration Specialist
- Strong background in migrating data from legacy systems into enterprise platforms
- Advanced knowledge of SQL and relational databases (SQL Server preferred)
- Experience with ETL processes and data transformation techniques
- Strong experience in data mapping, profiling, and cleansing
- Experience working with multiple legacy data sources and complex datasets
- Ability to work independently and lead migration workstreams
- Strong stakeholder management and SME engagement experience
- Experience in housing, public sector, or asset management systems
- Knowledge of systems such as Capita Open Housing, Dynamics 365, Unit4, SAP
- Experience with SSIS, Oracle, DB2, or PostgreSQL
- Understanding of financial data structures (GL, AR/AP, fixed assets, tenancy data)
- Experience contributing to data architecture and target system design
- Detail-oriented with a strong focus on data accuracy and integrity
- Logical and methodical approach to complex problem solving
- Comfortable working in high-pressure, delivery-focused environments
- Strong communicator with both technical and non-technical stakeholders
- Proactive, self-directed, and solution-focused mindset
- Successful migration of data from multiple legacy systems into target platform
- Fully reconciled datasets with zero critical data loss
- Clear, validated data mapping and transformation logic
- Strong stakeholder confidence in data quality and migration outcomes
- Smooth transition through testing, UAT, and go-live phases
Data Migration Lead in Northampton employer: SHEER JOBS LIMITED
Contact Detail:
SHEER JOBS LIMITED Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Migration Lead in Northampton
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even just grab a coffee with someone who’s already in the data migration game. You never know who might have a lead on your dream job!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your past data migration projects. Include details about the challenges you faced and how you overcame them. This will give potential employers a clear picture of what you can bring to the table.
✨Tip Number 3
Don’t be shy about reaching out directly! If you see a company you love, drop them a message on LinkedIn or their website. Express your interest in the Data Migration Lead role and share a bit about your experience. It shows initiative and can really make you stand out.
✨Tip Number 4
Keep learning and stay updated! The tech world is always changing, especially in data migration. Take online courses or attend workshops to sharpen your SQL and ETL skills. This not only boosts your confidence but also makes you more attractive to employers.
We think you need these skills to ace Data Migration Lead in Northampton
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Migration Lead role. Highlight your experience with SQL, ETL processes, and any relevant projects you've led. 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 the perfect fit for this role. Share specific examples of your past successes in data migration and how you’ve tackled complex datasets.
Showcase Your Technical Skills: Don’t hold back on showcasing your technical expertise! Mention your experience with SQL Server, SSIS, or any other tools you've used. We love seeing candidates who can demonstrate their hands-on skills in data transformation.
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 SHEER JOBS LIMITED
✨Know Your Data Inside Out
Before the interview, dive deep into your understanding of data migration processes. Brush up on your SQL skills and be ready to discuss specific ETL techniques you've used in past projects. Being able to articulate your experience with complex datasets will show that you’re the right fit for the role.
✨Prepare for Technical Questions
Expect technical questions about data mapping, profiling, and cleansing. Prepare examples from your previous work where you successfully led data migration activities. This will demonstrate your hands-on experience and problem-solving abilities in real-world scenarios.
✨Engage with Stakeholders
Since stakeholder engagement is key in this role, think of examples where you’ve effectively communicated complex technical issues to non-technical stakeholders. Be ready to discuss how you facilitated workshops or gathered requirements, as this will highlight your interpersonal skills.
✨Showcase Your Problem-Solving Skills
Be prepared to discuss challenges you faced during data migrations and how you overcame them. Highlight your logical approach to problem-solving and your ability to maintain data integrity under pressure. This will reassure the interviewers of your capability to handle high-stakes situations.