Senior Data Analysts Consultant

Role Description

The role requires a Senior Data Analyst with extensive knowledge of Excel Visual Basic for Application (Excel VBA) to support the National Treasury and mSCOA reporting submissions of the Citys (Municipality and its Municipality Owned Entities) monthly and yearly data strings. The role involves raw data validation and automation in Excel using VB code to prepare data strings for SAP Budget data uploads and generating/ validating the mSCOA reporting schedules of the City to National Treasury. As part of the requirement, the suitable candidate should also have solid understanding of SAP BPC and its modules in line with the mSCOA reporting requirements.

Key Responsibilities

• Prepare Municipality Budget upload strings for SAP BW / National Treasury.
• Validate all the BW accounting reports A/B/C and F Schedules.
• Validate all the monthly...