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.
