SUMMARY:
SQL & Reporting Developer – Cape Town
Finance Systems | ERP Reporting | Data & Automation
Permanent | 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.
POSITION INFO:
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
Please note that only shortlisted candidates will be contacted. Should you not receive feedback within 48 hours, please accept your application as unsuccessful.
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.
