SQL & SSRS Developer & Reporter

Cape Town Northern Suburbs
Salary: Market Related
Job Type: Permanent
Sectors: IT
Reference: CPT006456/CS

Apply before Apr 22 2026 | 30 Days left

Apply

External Application

Vacancy Details

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

craig@personastaff.co.za

Apply

30 people have viewed this job.

About Persona Staff

Vision
PERSONA’s vision is to allow our Clients to focus on their core activities, and let PERSONA manage the responsibility of staff recruitment; ensuring the perfect fit between candidate and client for the most efficient and effective workforce.
PERSONA is committed to delivering the best service to our clients and candidates.

We recruit in the following industries:
Financial Services, Manufacturing, Engineering, Retail, Banking, Telecommunications, Information technology, Electronics, Logistics, Mechanical, Sales & Marketing, Office Support, Warehousing, Distribution and Supervision Staff

Services offered:
To our clients:-
Recruitment of permanent staff at all levels
In depth staff selection
Salary surveys
Advertising of available positions
Comprehensive interviewing
Screening of potential candidates according to client’s specifications
Reference checks (on possible candidate)
ITC checks (on possible candidate)
Criminal checks (on possible candidate)
More background checks on request.
Psychometric testing (additional services)
Preparing of Job descriptions
PERSONA commits to adhere to industry standards and policies.

To possible candidate and job seekers:-
Professional resume
Regular correspondence
Interviewing tips
Summary of client information
Assistance to find the perfect job