Data Analyst
JLL
About the role
JLL (Jones Lang LaSalle) is a global leader in realβestate services, operating in more than 80 countries. In India, JLL combines deep market knowledge with cuttingβedge technology to help clients optimise their realβestate portfolios, create sustainable workplaces and drive value. The companyβs culture is built around collaboration, innovation and a strong commitment to professional growth, making it an attractive destination for fresh talent looking to launch a career in corporate realβestate and data analytics.
The Workplace Data Administrator (Data Analyst) role sits within the Workplace Management / Real Estate Operations function at JLLβs Gurgaon office. Reporting to the Workplace Data Manager, the incumbent will be the custodian of the Integrated Workplace Management System (IWMS) data, ensuring that building, floor, room and workspace information is accurate, upβtoβdate and aligned with the physical environment. The role blends data administration, basic CAD drafting, and businessβintelligence reporting to support facilities, corporate realβestate and project teams.
Key Responsibilities
- Maintain and update workplace and space records in the IWMS, following global data standards and naming conventions.
- Perform data cleansing, validation and periodic quality audits to eliminate duplicates and inconsistencies.
- Collect, organise and analyse large datasets to identify utilisation trends, capacity gaps and costβsaving opportunities.
- Design and deliver dashboards and visual reports using Power BI and Excel for senior stakeholders.
- Manage floorβplan information, reconcile CAD drawings with IWMS records, and support updates after moves or refurbishments.
- Provide basic AutoCAD support β updating room boundaries, space layouts and preparing files for upload.
- Produce regular and adβhoc reports on space allocation, occupancy, desk utilisation and other workplace assets.
- Collaborate with Facilities, Projects, Moves and Corporate RealβEstate teams to gather accurate data and resolve discrepancies.
- Contribute to the implementation of dataβgovernance policies and continuousβimprovement initiatives.
- Document changes, maintain audit trails and ensure compliance with internal controls.
Tech Stack: Microsoft Excel, Power BI, AutoCAD (basic), Integrated Workplace Management System (e.g., IBM TRIRIGA, Planon, Archibus), SQL/Access for data extraction, and standard office productivity tools.
Growth Path: Starting as a Workplace Data Administrator, highβperformers can progress to Workplace Data Analyst, IWMS Administrator, Space Management Analyst, or even senior roles such as Space Management Lead. JLLβs internal mobility program and structured learning platforms provide clear pathways for skillβupgradation and leadership development.
Why Join JLL? JLL offers exposure to worldβclass realβestate projects, a collaborative multicultural environment, and a strong emphasis on technologyβdriven workplace solutions. Fresh graduates gain handsβon experience with enterpriseβgrade IWMS platforms, develop analytical and CAD skills, and receive mentorship from industry experts, positioning them for a rewarding career in realβestate analytics and facilities management.
Eligibility & process
Who can apply
Graduates (B.Tech/B.E., B.Sc., B.Com, BBA or equivalent) from any stream with a minimum of 60% aggregate. Freshers from the 2024β2025 batch are preferred. No active backlogs at the time of joining. Candidates should have basic knowledge of Excel, Powerβ―BI and an interest in CAD or data management.
Skills & stack
Selection process
- Round 1: Online aptitude & logical reasoning test
- Round 2: Technical interview (data handling, Excel/Powerβ―BI, basic CAD)
- Round 3: HR interview (fitment, communication, career goals)
Prep kit
20 resourcesStudy material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Behavioural & HR questions 3
Highlight JLL's market reputation, recent tech innovations, and how your skills in Data Administration directly solve their team's objectives.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.