Data Migration Analyst

Jones Lang LaSalle

  • London
  • Permanent
  • Full-time
  • 2 days ago
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.We're seeking a detail-oriented Data Migration Analyst 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
  • Experience with data migration, data cleansing, and ETL processes
  • 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
  • Basic SQL knowledge preferred
  • Excellent documentation skills
  • Strong communication abilities to liaise with stakeholders
  • Time management and organizational skills to handle multiple data sources
Education/Experience
  • 2+ 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 for a 6 month contract role with potential for extension based on project needs and performance.Location:On-site –London, GBRIf 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 or call +44 (0)20 7493 4933 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 page
I want to work for JLL.JLL Privacy NoticeJones 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 .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 .

Jones Lang LaSalle