At a Glance
- Tasks: Lead complex data migration activities and ensure data accuracy across systems.
- Company: Join a forward-thinking company transforming data management.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic role with potential for career advancement in a supportive environment.
- Why this job: Make a significant impact by modernising data systems and enhancing data quality.
- Qualifications: Experience in data migration, SQL, and stakeholder engagement required.
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
What Success Looks Like
- 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 employer: SHEER JOBS LIMITED
As a Data Migration Lead at our company, you will thrive in a dynamic and collaborative work environment that prioritises innovation and employee development. We offer competitive benefits, including professional growth opportunities and a supportive culture that values your contributions, all while working on impactful projects that enhance our systems and services. Join us in a location that fosters creativity and teamwork, making it an ideal place for those seeking meaningful and rewarding employment.
StudySmarter Expert Advice🤫
We think this is how you could land Data Migration Lead
✨Tip Number 1
Get your networking game on! Reach out to folks in your industry, especially those who work with data migration. You never know who might have a lead on a job or can give you insider info about the company.
✨Tip Number 2
Prepare for interviews by brushing up on your SQL and ETL skills. Be ready to discuss specific projects where you've led data migrations, and how you tackled challenges like data quality issues. We want to see your expertise shine!
✨Tip Number 3
Don’t forget to showcase your stakeholder management skills! Be prepared to share examples of how you've engaged with SMEs and technical teams to ensure successful data migration outcomes. Communication is key!
✨Tip Number 4
Finally, apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive and take the initiative to connect directly with us.
We think you need these skills to ace Data Migration Lead
Some tips for your application 🫡
Get to Know the Job:Before you start writing, take a good look at the job description. Make sure you understand what we're looking for in a Data Migration Lead. Tailor your application to highlight your relevant experience and skills that match our needs.
Show Off Your Skills:We want to see your technical expertise shine! Be sure to mention your experience with SQL, ETL processes, and any data transformation techniques you've mastered. Use specific examples to demonstrate how you've successfully led data migration projects in the past.
Keep It Clear and Concise:When writing your application, clarity is key. Avoid jargon and keep your language straightforward. We appreciate a well-structured application that gets straight to the point while showcasing your qualifications.
Apply Through Our Website:Don't forget to apply through our website! This ensures your application goes directly to us and maximises your chances of being considered for an interview. We can't wait to hear from you!
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 to face 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 Attention to Detail
Data accuracy and integrity are crucial in this position. Prepare to discuss how you've identified and resolved data quality issues in the past. Sharing specific instances where your attention to detail made a difference will help you stand out as a candidate who prioritises quality.
