Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead complex data migration projects and ensure data accuracy and integrity.
- Company: Join a forward-thinking organisation transforming data systems.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic role with opportunities to work on large-scale datasets.
- Why this job: Make a real impact by modernising data systems and enhancing data quality.
- 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
- Data Migration Delivery
- 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
- Data Analysis & Design
- 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
- ETL & Technical Delivery
- 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
- Data Quality & Governance
- 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
- Testing & Reconciliation
- 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
- Stakeholder Engagement
- 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
Key Skills & Experience Required
Essential
- 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
Desirable
- 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
Personal Attributes
- 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
Data Migration Lead in Northampton employer: Sheer Jobs Ltd
Contact Detail:
Sheer Jobs Ltd 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! Reach out to your connections in the industry, attend meetups, and engage in online forums. You never know who might have the inside scoop on a Data Migration Lead role that’s not even advertised yet!
✨Tip Number 2
Show off your skills! Create a portfolio or a GitHub repository showcasing your SQL scripts, ETL processes, and any data migration projects you've led. This gives potential employers a tangible look at what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common data migration scenarios. Be ready to discuss how you’ve tackled complex datasets and resolved data quality issues in the past. Real-life examples will make you stand out!
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, it’s a great way to ensure your application gets the attention it deserves.
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 our needs!
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 hit the ground running with their technical know-how.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
How to prepare for a job interview at Sheer Jobs Ltd
✨Know Your Data Inside Out
Before the interview, dive deep into your past data migration projects. Be ready to discuss specific challenges you faced, how you tackled them, and the tools you used, especially SQL and ETL processes. This will show your technical expertise and give you confidence.
✨Speak Their Language
Familiarise yourself with the terminology and key concepts mentioned in the job description. Use terms like 'data mapping', 'data quality', and 'reconciliation' during your conversation. This demonstrates that you understand the role and can communicate effectively with both technical and non-technical stakeholders.
✨Prepare for Scenario Questions
Expect scenario-based questions where you'll need to explain how you'd handle specific data migration challenges. Think of examples from your experience where you had to analyse complex datasets or resolve data quality issues, and be ready to walk them through your thought process.
✨Engage with Stakeholders
Showcase your stakeholder management skills by preparing to discuss how you've worked with SMEs and business users in the past. Highlight any workshops you've facilitated or how you've communicated complex issues clearly. This will illustrate your ability to bridge the gap between technical teams and business needs.