Systems Accountant - MDA

About the position

The purpose of the role is to manage the MDA system and processes.
REQUIREMENTS:

• 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
• 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 weakness 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 with regards to 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 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.

Desired Skills:

• MDA system
• MDA accounting
• data management