Analyst Programmer (Prescient Securities)

Prescient Limited; Cape Town; On-site; ZAR 540,000 - 900,000; Full time

Job summary

Prescient Securities in Cape Town seeks an Analyst Programmer with strong C#/.NET, SQL, debugging, and application support. You'll collaborate with business users, developers and the Head of Technology to deliver enhancements across web, desktop, services and Excel-based tools.

You will contribute to AI-assisted development, cloud deployments (AWS), testing, documentation and controlled delivery, while ensuring data quality and security.

Qualifications

• Minimum 3 years' hands-on experience developing, maintaining or supporting C#/.NET applications.
• Minimum 3 years' practical experience with SQL, including querying, troubleshooting, data validation and investigation.
• Experience supporting or enhancing business applications in a production environment.
• Exposure to web applications, desktop applications, Windows services, APIs, integrations or Office/Excel-based solutions.
• Experience with source control, debugging, testing, release practices and structured deployment support.
• Experience working directly with business users to clarify requirements, investigate issues, document outcomes and validate solutions.
• Comfortable using AI-assisted tools for coding, documentation, analysis, testing and problem solving.

Responsibilities

• Develop, maintain and enhance C#/.NET applications, services, desktop tools, integrations and internal business systems using SQL and related technologies.
• Investigate production issues, data discrepancies, user queries and system failures using SQL, logs, debugging tools and application knowledge.
• Engage business users to understand problems, clarify requirements, document current-state and future-state processes, and translate business needs into practical technical requirements.
• Support functional testing, regression testing, UAT, output validation, test evidence and user sign-off across enhancements, fixes and operational changes.
• Use AI tools to improve productivity across coding, testing, documentation, analysis, summarisation and troubleshooting, while applying appropriate data-sensitivity and validation controls.
• Support cloud-hosted workloads, monitoring and deployment activities where required, with exposure to AWS services such as S3, Lambda, ECS, EC2, RDS and CloudWatch.
• Use SQL and analytical thinking to investigate data, validate results, compare outputs and support reporting, market data, trading or operational processes.
• Produce clear technical notes, user guides, process diagrams, handover notes, support documentation and reusable templates that help users and the technology team operate consistently.

Skills

C#/.NET

SQL

Debugging

AI-assisted tools

Cloud services

Excel-based solutions

Education

Software development degree

Tools

Git

Debugging tools

Job description

Analyst Programmer (Prescient Securities)

The role requires strong practical capability in C#/.NET, SQL, debugging and application support, with exposure to AI-assisted development tools, cloud services and modern delivery practices. The individual will work closely with business users, developers, quantitative resources and the Head of Technology to understand requirements, investigate issues, validate outputs and deliver practical enhancements across web, desktop, service, integration and Excel-based solutions.

DUTIES & RESPONSIBILITIES

• Technical delivery and development: Develop, maintain and enhance C#/.NET applications, services, desktop tools, integrations and internal business systems using SQL and related technologies.
• Application support and troubleshooting: Investigate production issues, data discrepancies, user queries and system failures using SQL, logs, debugging tools and application knowledge.
• Business analysis as a delivery component: Engage business users to understand problems, clarify requirements, document current-state and future-state processes, and translate business needs into practical technical requirements.
• Testing and validation: Support functional testing, regression testing, UAT, output validation, test evidence and user sign-off across enhancements, fixes and operational changes.
• AI-assisted delivery and automation: Use AI tools to improve productivity across coding, testing, documentation, analysis, summarisation and troubleshooting, while applying appropriate data-sensitivity and validation controls.
• Cloud and modern delivery exposure: Support cloud-hosted workloads, monitoring and deployment activities where required, with exposure to AWS services such as S3, Lambda, ECS, EC2, RDS and CloudWatch.
• Data, analysis and reconciliation: Use SQL and analytical thinking to investigate data, validate results, compare outputs and support reporting, market data, trading or operational processes.
• Documentation and enablement: Produce clear technical notes, user guides, process diagrams, handover notes, support documentation and reusable templates that help users and the technology team operate consistently.

REQUIRED EXPERIENCE

• Minimum 3 years' hands‑on experience developing, maintaining or supporting applications using C#/.NET.
• Minimum 3 years' practical experience with SQL, including querying, troubleshooting, data validation and investigation.
• Experience supporting or enhancing business applications in a production environment.
• Exposure to web applications, desktop applications, Windows services, APIs, integrations or Office/Excel-based solutions.
• Experience with source control, debugging, testing, release practices and structured deployment support.
• Experience working directly with business users to clarify requirements, investigate issues, document outcomes and validate solutions.
• Comfortable using AI‑assisted tools for coding, documentation, analysis, testing and problem solving.

REQUIRED QUALIFICATIONS

• Relevant degree, diploma or equivalent practical experience in software development, information systems, data, engineering or a related technical field.
• Strong problem‑solving and analytical skills.
• Good communication skills and ability to work with both technical and business stakeholders.
• Willingness to learn across development, support, cloud, automation, AI tools and business analysis.

KEY COMPETENCIES

• Strong practical C#/.NET and object‑oriented programming capability.
• Good working knowledge of SQL, data investigation, validation and troubleshooting.
• Ability to debug, support and enhance applications across multiple technology stacks.
• Practical understanding of testing, UAT support, documentation and controlled delivery.
• Business analysis as a sub‑component of delivery: requirements clarification, process understanding and acceptance criteria.
• Responsible use of AI tools to accelerate development, analysis, testing, documentation and troubleshooting.
• Exposure to cloud services, APIs, automation and modern software delivery practices.
• Understanding of security, privacy, operational control and audit requirements.

WHY THIS ROLE?

This role is an opportunity to work across a broad technology estate that supports trading, operations, reporting, market data, client servicing and internal decision‑making. The successful candidate will help reduce key‑person dependency, improve support resilience and increase delivery capacity by combining hands‑on technical execution with practical business understanding. The role is suited to someone who wants to grow beyond pure development or pure analysis into a cross‑functional delivery capability across C#/.NET, SQL, support, automation, AI‑assisted productivity, cloud exposure and controlled change delivery.