Permanent
SQL & SSRS Developer & Reporter
Persona Staff
Unknown, Western Cape
unknown
About this role
Employer: Persona Staff
SQL & Reporting Developer – Cape TownFinance Systems | ERP Reporting | Data & AutomationPermanent | On-site Our client, a well-established manufacturing and engineering company based in Cape Town, is seeking a skilled SQL & Reporting Developer to design, build, and maintain a centralized reporting environment across the business. This role focuses on replacing manual Excel-based reporting with automated, system-driven reports linked directly to SYSPRO and validated data sources. The successful candidate will play a key role in ensuring accurate, consistent, and real-time reporting for operational, financial, and management decision-making.
Key Responsibilities:
* Develop and implement automated reports aligned to business requirements and KPI definitions
* Identify and migrate recurring Excel-based reports into structured system reports
* Build and maintain SQL-based reporting data structures to ensure accuracy and performance
* Ensure all reports reconcile with SYSPRO transactions and validated data sources
* Develop and maintain live dashboards for operations, production, and finance
* Support SYSPRO reporting requirements and identify data integrity issues
* Perform ad-hoc data analysis and convert recurring requests into automated reports
* Implement data validation, reconciliation checks, and KPI monitoring processes
* Investigate discrepancies and coordinate corrective actions with relevant teams
* Monitor reporting system performance, resolve failures, and ensure uptime
* Implement alerts for critical KPIs and reporting issues
* Maintain documentation of report logic, definitions, and data structures for audit purposes
* Support structured release processes and maintain reporting environment stability
Requirements:
* Relevant qualification in IT, Computer Science, Information Systems, or similar
* Proven experience in SQL development and reporting environments
* Strong experience with Microsoft SQL Server and reporting tools (SSRS or similar)
* Experience working with ERP systems (SYSPRO preferred)
* Advanced Excel skills (for transition and validation purposes)
* Strong understanding of data structures, reporting logic, and KPI design
* Experience building dashboards and automated reporting solutions
* Ability to troubleshoot data discrepancies and ensure data integrity
* Fluent in English and Afrikaans
To apply, please send your CV to craig@personastaff.co.za
Â
Persona Staff (Pty) Ltd is POPIA compliant. All personal information is processed in accordance with the Protection of Personal Information Act for recruitment purposes only.