Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Data Migration Analyst, extracting and standardising lease data for our central platform.
- Company: JLL is a global leader in real estate and investment management, shaping a better future.
- Benefits: Enjoy flexible work options, career growth opportunities, and a supportive team culture.
- Why this job: Be part of a critical project that impacts the real estate industry while developing your data skills.
- Qualifications: 2+ years in data analysis or migration; strong Excel skills and attention to detail required.
- Other info: Ideal for those passionate about data and looking to make a difference in real estate.
The predicted salary is between 36000 - 60000 £ per year.
Overview
We\\u2019re 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. Experience with data migration, data cleansing, and ETL processes is required.
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
Qualifications
- 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
- 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
About JLL
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\\u2019ve got deep experience in commercial real estate, skilled trades or technology, or you\\u2019re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.
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\\u2019s 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.
#J-18808-Ljbffr
Data Migration Analyst employer: JLL
Contact Detail:
JLL Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Migration Analyst
✨Tip Number 1
Familiarise yourself with the specific data migration tools and ETL processes that are commonly used in the industry. This knowledge will not only help you during the interview but also demonstrate your proactive approach to understanding the role.
✨Tip Number 2
Network with professionals in the real estate and data migration fields. Attend relevant webinars or local meetups to connect with others who may have insights into the hiring process at JLL or similar companies.
✨Tip Number 3
Prepare to discuss specific examples of your past experiences with data cleansing and standardisation. Be ready to explain how you approached challenges and what methodologies you used to ensure data accuracy.
✨Tip Number 4
Showcase your advanced Excel skills by being prepared to solve practical problems during the interview. Brush up on functions like VLOOKUP and Power Query, as these will likely be relevant to the tasks you'll face in the role.
We think you need these skills to ace Data Migration Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with data migration, data cleansing, and ETL processes. Use specific examples that demonstrate your proficiency with Excel and any relevant tools you've used.
Craft a Strong Cover Letter: In your cover letter, explain why you're interested in the Data Migration Analyst role at JLL. Mention your analytical mindset and problem-solving abilities, and how they align with the responsibilities outlined in the job description.
Showcase Relevant Skills: Emphasise your advanced Excel skills, including VLOOKUP and Power Query, as well as any basic SQL knowledge. Highlight your attention to detail and commitment to data accuracy, which are crucial for this role.
Prepare for Potential Questions: Think about how you would address common data quality issues and deduplication methodologies. Be ready to discuss your previous experiences in data analysis and how they relate to the responsibilities of the Data Migration Analyst position.
How to prepare for a job interview at JLL
✨Showcase Your Data Skills
Make sure to highlight your proficiency with Excel and any data manipulation techniques you've mastered. Be prepared to discuss specific examples of how you've used these skills in previous roles, especially in data migration or cleansing.
✨Understand the ETL Process
Familiarise yourself with the ETL (Extract, Transform, Load) process as it relates to lease data migration. Be ready to explain how you would approach data extraction from various formats and the importance of standardisation in this context.
✨Prepare for Problem-Solving Questions
Expect questions that assess your analytical mindset and problem-solving abilities. Think of scenarios where you've identified and resolved data quality issues or duplicates, and be ready to share your thought process.
✨Communicate Effectively
Strong communication skills are essential for liaising with stakeholders. Practice articulating complex data concepts in a clear and concise manner, and be prepared to discuss how you would collaborate with others to clarify requirements and resolve issues.