Record Keeper (Housing Project)

We are seeking a detail-oriented and data-driven Record Keeper for our residential housing project. The ideal candidate will be responsible for managing all documentation, allocation records, and financial ledger histories related to member and plot-holder data. Utilizing advanced MS Excel skills, you will maintain the master registry, track plot transfers, and ensure that every file—from initial booking through to final plot possession—is accurately documented and easily accessible.

Key Responsibilities

- Master Database Management: Maintain and regularly audit the master Excel database containing member profiles, plot allocations (including block, sector, and plot size), and contact information.

- Plot Transfer and File Processing: Verify, process, and document all legal records related to plot transfers, ownership changes, nominations, and cancellations.

- Payment Ledger Tracking: Monitor installment plans, down payments, surcharges, and outstanding dues for each member file, ensuring full alignment with the finance team.

- Allocation Data Preparation: Organize and prepare clean datasets for physical plot boundary assignments to support project operations.

- Advanced Reporting: Create dynamic reports using Excel Pivot Tables and XLOOKUP functions to summarize booking statuses, compare vacant versus allocated plots, and track recovery collections.

- Customer Record Audits: Conduct routine audits of member files to ensure compliance with biometric verifications, CNIC/ID submissions, and legal affidavits.

Required Qualifications

- Education: Bachelor’s degree in Business Administration, Commerce, Information Technology, or a related field.

- Experience: Minimum of 2 years managing member files, databases, or customer records, preferably within a residential housing scheme, land development project, or cooperative housing society.

- Advanced MS Excel Mastery: Demonstrated expertise in data filtering, cleaning large datasets, and eliminating duplicate entries. Proficient in functions such as XLOOKUP, COUNTIFS, SUMIFS, and Nested IF statements. Skilled in creating complex Pivot Tables to monitor payment collections and allocation statistics.

- Attributes: High integrity in handling confidential customer data, keen attention to numerical accuracy, and excellent organizational skills.

Preferred Qualifications and Benefits

- Competitive monthly salary starting from Rs40,000.

- Performance-based incentives tied to data accuracy and recovery targets.

- Opportunities for stable career growth within a prominent real estate development.

- Work location requires in-person attendance to ensure hands-on management of records and coordination with project teams.

This role offers a unique opportunity to contribute to a landmark housing project by ensuring the accuracy and integrity of critical data. If you have a passion for meticulous record-keeping and advanced Excel capabilities, this position will allow you to thrive in a dynamic real estate environment.