Record Keeper (Housing Project)

Job Summary

We are looking for a precise and data-driven Record Keeper (Housing Project) to manage the documentation, allocation, and financial ledger histories for our residential housing project. You will serve as the custodian of all member and plot-holder data. Using advanced MS Excel skills, you will maintain the master registry, track transfers, and ensure that every file—from initial booking to final plot possession—is flawlessly documented and instantly retrievable.Key Responsibilities

• Master Database Management: Maintain and audit the master Excel database containing all member profiles, plot allocations (block, sector, plot size), and contact details.
• Plot Transfer & File Processing: Verify, process, and document legal records for plot transfers, change of ownership, nominations, and cancellations.
• Payment Ledger Tracking: Track installment plans, down payments, surcharges, and dues per member file, ensuring perfect synchronization with the finance team.
• Allocation Data: Prepare and organize clean datasets for physical plot boundary assignments.
• Advanced Reporting: Generate dynamic summaries using Excel Pivot Tables and XLOOKUP to report on booking statuses, vacant vs. allocated plots, and recovery collections.
• Customer Record Audits: Conduct routine checks on member files to ensure compliance with biometric verifications, CNIC/ID submissions, and legal affidavits.

Required Skills & Qualifications

• Education: Bachelor’s degree in Business Administration, Commerce, IT, or a related discipline.
• Experience: 2+ years of experience managing member files, databases, or customer records—specifically within a residential housing scheme, land development project, or cooperative housing society.
• Advanced MS Excel Mastery:
• Absolute proficiency with data filtering, cleaning large datasets, and preventing duplicate entries.
• Expert use of functions like XLOOKUP, COUNTIFS, SUMIFS, and Nested IF statements.
• Strong capability in creating complex Pivot Tables to track payment collections and allocation statistics.
• Attributes: High integrity when handling confidential customer data, a sharp eye for spotting numerical discrepancies, and strong organizational skills.

What We Offer

• Competitive monthly salary package.
• Performance incentives based on data accuracy and recovery targets.
• Stable career growth within a major landmark real estate project.

Pay: From Rs40,000.00 per month

Work Location: In person