Junior Data Analyst

Job Overview

Key Responsibilities

• Collect, organize, validate, and analyze data from multiple entities and group companies.
• Prepare regular, ad-hoc, and management reports using Excel and other reporting tools.
• Assist in analyzing financial, operational, and real estate-related data.
• Extract and review data from Yardi and ensure the accuracy and completeness of information.
• Support the preparation and review of Trial Balance, financial reports, and other management information.
• Identify data inconsistencies, errors, and unusual trends and coordinate with relevant teams for clarification.
• Maintain accurate databases, spreadsheets, and reporting files.
• Perform basic data analysis and provide meaningful insights to management.
• Use basic SQL queries to extract, filter, and analyze data from databases.
• Support data reconciliation and validation between different systems and reports.
• Coordinate with Finance, Accounting, Operations, and other departments to obtain and verify required information.
• Handle multiple reporting tasks and deadlines efficiently.

Required Qualifications & Skills

• Basic to good understanding of the real estate industry, including property, leasing, rental, or property management concepts.
• Basic to intermediate knowledge of finance and accounting principles.
• Ability to understand financial statements, Trial Balance, reconciliations, and basic accounting concepts.
• Good proficiency in Microsoft Excel.
• Knowledge of formulas, Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, filtering, sorting, and data validation.
• Basic to intermediate knowledge of data analysis and reporting.
• Ability to identify trends, variances, and data inconsistencies.
• Basic knowledge of SQL.
• Understanding of basic queries such as SELECT, WHERE, JOIN, GROUP BY, and ORDER BY is preferred.
• Willingness to develop further technical and analytical skills.
• Good interpersonal and communication skills.
• Ability to work effectively with different departments and team members.

Preferred Experience

• 1–2 years of relevant experience in data analysis, finance, accounting, real estate, or reporting.
• Experience working with multiple entities or group companies is preferred.
• Exposure to Yardi, real estate accounting, or property management systems will be an advantage.