Data Migration Administrator

JLL; City Of London; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading real estate firm is seeking a Data Migration Specialist for a 6-month contract in London. The role involves extracting, analyzing, and standardizing lease data from various sources, requiring strong Excel skills and attention to detail. Candidates with experience in data analysis or real estate are encouraged to apply, as this is a unique opportunity to contribute to a critical data migration project.

Qualifications

• Strong proficiency with Excel and data manipulation techniques.
• Familiarity with data quality principles and deduplication methodologies.

Responsibilities

• Extract lease data from various source documents.
• Cleanse and standardize data according to established guidelines.
• Develop and execute data mapping strategies.
• Identify and resolve duplicate records.
• Document data migration processes and solutions.

Skills

Advanced Excel skills (VLOOKUP, Power Query, pivot tables)

Data validation and verification techniques

Excellent documentation skills

Strong communication abilities to liaise with stakeholders

Time management and organizational skills

Education

3+ years experience in data analysis, data migration, or similar role

Prior experience in real estate or property management systems

Tools

Excel

Job description

JLL empowers you to shape a brighter way

Our people at JLL and JLL Technologies are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.

Job Description

We're seeking a detail-oriented Data Migration Specialist to join our team for a critical lease data migration initiative. This role will be responsible for the extraction, analysis, and standardisation of lease data from multiple source formats (Excel, Word, PowerPoint, etc.) to be executed in an ETL process to our central leasing platform.

Key Responsibilities

• Extract lease data from various source documents including spreadsheets, text documents, and presentations
• Cleanse and standardize data according to established guidelines and quality standards
• Develop and execute data mapping strategies between source documents and target system fields
• Enrich data with additional attributes as required by the target system
• Identify and resolve duplicate records through systematic deduplication processes
• Perform comprehensive testing of migrated data to ensure accuracy and completeness
• Document data migration processes, issues encountered, and solutions implemented
• Collaborate with stakeholders to resolve data quality issues and clarify requirements
• Support UAT (User Acceptance Testing) of the migrated data

Requirements

• Strong proficiency with Excel and data manipulation techniques
• Familiarity with data quality principles and deduplication methodologies
• Attention to detail and commitment to data accuracy
• Analytical mindset with strong problem-solving abilities
• Experience working with lease documentation preferred
• Knowledge of real estate data structures a plus
• Ability to work independently and as part of a team

Skills

• Advanced Excel skills (VLOOKUP, Power Query, pivot tables)
• Data validation and verification techniques
• Excellent documentation skills
• Strong communication abilities to liaise with stakeholders
• Time management and organizational skills to handle multiple data sources

Education/Experience

• 3+ years experience in data analysis, data migration, or similar role
• Prior experience in real estate or property management systems beneficial

Project Duration

This position is a 6 month contract role with potential for extension based on project needs and performance.

Location

On-site – London, GBR

If this job description resonates with you, we encourage you to apply, even if you don’t meet all the requirements. We’re interested in getting to know you and what you bring to the table! If you require any changes to the application process, please email [e-mail] or call [phone] to contact one of our team members to discuss how to best support you throughout the process. Please note, the contact details provided are to discuss or request for adjustments to be made to the hiring process. Please direct any other general recruiting inquiries to our Contact Us page.

JLL Privacy Notice

Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.

For more information about how JLL processes your personal data, please view our Candidate Privacy Statement.

For additional details please see our career site pages for each country.

For candidates in the United States, please see a full copy of our Equal Employment Opportunity policy here.