AI-Driven .NET & SQL Analyst Programmer

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

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.