Syspro Reporting Analyst

Zest Worx; Johannesburg; On-site; ZAR 200,000 - 300,000; Full time

Job summary

A dynamic business solutions company in Johannesburg is seeking a Syspro Reporting Analyst. The role involves managing Syspro ERP administration, generating performance reports, and providing user support and training. The ideal candidate should have strong Syspro and Excel skills, along with experience in Power BI and SQL. This position also emphasizes process improvement and internal control compliance.

Qualifications

• Strong understanding of Syspro ERP modules and administration duties.
• Ability to extract, clean, and analyze various databases.
• High attention to detail and process orientation.

Responsibilities

• Manage user access rights, roles, and permissions within Syspro.
• Generate and analyze reports from Syspro and other tools.
• Provide user support across Syspro modules.
• Identify areas for process improvement through automation.

Skills

Strong understanding of Syspro ERP modules

Excellent Excel skills

Experienced in Power BI

SQL experience

Strong communication skills

Education

Matric

Completed relevant courses

Tools

Power BI

Syspro

Excel

Job description

Syspro Reporting Analyst required in Johannesburg.

The purpose of this position is to ensure optimal performance, integrity and security of the Syspro ERP system, while supporting the business with accurate and timely reporting for decision-making purposes.

Duties and Responsibilities:

1. Syspro Administration:

• Manage user access rights, roles, and permissions within Syspro.
• Maintain system configuration, including modules.
• Troubleshot Syspro-related system issues and coordinate with external Syspro support team where necessary.
• Monitor system performance and be part of any software update / module implementation process.
• Support data integrity through regular system backups, reconciliations and data validations.
• Work with external Syspro support team to create and maintain workflows (incl. documenting the related processes) that support a strong internal control environment.

2. Data and Reporting Support:

• Generate, analyze and share with management requested reports from Syspro, Excel, Power BI and other tools.
• Build and maintain recurring financial, operational, and performance reports:
• Sales (e.g. Purchase Orders, Credit Notes, Quotations, Credit Sales)
• Inventory (Product type, location, quantities)
• Production (Dates, batches, product type, volumes, factory)
  etc.
• Assist various departments in terms of ad-hoc data analysis and performance reporting.
• Verification of data accuracy in reports and assist in resolving data integrity issues noted.
• Updates to product prices / discounts on Syspro.
• Updates to product weights on Syspro.

3. User Support and Training:

• Be the first point of contact for any Syspro-related queries and issues experienced by staff.
• Provide user support across modules such as sales, inventory, purchasing, finance and manufacturing (once implemented).
• Training to be provided to both new and existing staff members – Functionalities, best practices and navigation.
• Develop and maintain standard operating procedures and basic user manuals covering all areas.

4. Process Improvement and Internal Controls:

• Identify areas for process improvement through system enhancements and automation.
• Streamline workflows and data sharing / flow of data between the different departments for process optimization.
• Support internal audits by providing system access logs, transactional reports, and system / data change historical information.
• Ensure compliance with internal controls, data policies and security protocols.

Minimum Requirements:

• Strong understanding of Syspro ERP modules and systems administration duties.
• Ability to extract, clean, and analyze various databases.
• Excellent excel skills (Pivot Tables, Vlookups, Charts, etc.)
• Experienced in the use of Power BI reporting tools.
• SQL experience.
• High attention to detail and process orientation.
• Strong communication and user-support skills.
• Matric
• Completed relevant courses