Job Reference: JHB003100-RC-1The purpose of the role is to manage the MDA system and processes.Duties & ResponsibilitiesRequirements:Matric Qualification required.Diploma in Accounting required.3 Years full MDA System as a superuser required.Ability to quickly learn new computer applications: Flowcentric, Qlikview etc.Advanced MDA knowledge.Understand a problem/enquiry and match it to a solution in MDA.Understand data, data tables and their relationship to each other.Must be able to extract data, reconcile and test the results for logic, accuracy, and completeness.Must be able to identify processes and identify controls and weaknesses and recommend solutions.Duties:Management of MDA system, data, support, and development.Ensure the correct set-up of options, functionality, and creation of accounts in MDA.Manage and liaise with the MDA developers on any "bugs" found, or any system enhancements and development needed.Assist with the business requirements for system development and enhancements in MDA.Review development documents, assist/perform thorough testing and ensure that deployments are done in a controlled manner.Investigate and troubleshoot for reasons when system errors occur.Ensure that support is provided to staff with regards to the use of MDA.Ensure that formal and "on-the-job" training and training manuals are given regarding the use of MDA.Ensure that the integrity of the data on MDA is maintained by conducting regular tests on MDA data.Ensure that the MDA database is kept clean by closing relevant accounts.Ensure that the monthly financial and billing run processes are done without errors.Ensure the relevant month-end agent reports and payments are processed accurately.Ensure that budget processes and Utility increases are done timeously and completed successfully.Test new versions of MDA and report any problems found to MDA before deploying new versions in a live environment.Extract Data from MDA System for Reports and Other Applications:Ensure that the Commercial lease agreement and supporting MDA data is updated correctly and kept current as well as protected.Ensure that established data extracts/reports used by other departments and applications are updated correctly and timeously.Ensure that any requirements for data to be extracted from MDA are fully understood and other options explored before data is extracted.Ensure that the correct tables, data, and rules are used.Test the accuracy of the extracted results thoroughly to the original data before the information is provided to the stakeholder.Provide assistance to the Technology Projects Department with the relevant MDA tables and data needed where applications need to integrate with MDA.Provide assistance in reviewing business requirements, development documents, and testing with regards to third-party integrations with MDA.Management of Data Capturing onto MDA:Ensure that processing of the data on MDA with regards to owners, properties, suppliers, and budgets are done accurately and within the agreed turnaround times.Ensure the timeous and correct distribution of monthly tenant statements via electronic mail.Ensure that processes are followed and documented to identify any weaknesses and recommend controls or enhancements for improvements.Prepare Payments for Letting Commission and Office Collections:Review Letting Commission reports prepared by the Systems Administrator to ensure that correct Letting Commission formulas were applied and calculations were done correctly.Ensure that manual Letting Commission for Combination Leases were included in total calculation for payment.Ensure that there are no duplicated payments from previous months.Prepare CSV imports for Finance for processing of Commission payments.Calculate Office collections for the period and compare with calculations from Systems Administrators.Ensure that correct formulas were applied in calculations.Prepare all payment requisitions for Finance to present to Data Manager.Ensure that all payment requisitions are sent to Finance timeously.Package & RemunerationMonthly
#J-18808-Ljbffr