Analyst Programmer at Prescient

Purpose of role:

• We are looking for an Analyst Programmer to support the delivery, maintenance and improvement of Prescient Securities' technology estate. This is an intermediate technical delivery role where business analysis is one part of the job, but the primary focus is hands-on contribution across development, support, testing, documentation, automation and delivery execution. 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 and 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.

Advantageous experience:

• Exposure to AWS cloud services such as Lambda, S3, ECS, EC2, RDS, EventBridge or CloudWatch.
• Experience with CI/CD pipelines, Docker, deployment automation or environment promotion.
• Experience with Excel/VBA, Office add-ins, Python, scripting, workflow automation or API-based integrations.
• Experience in financial services, stockbroking, trading, market data, operations or regulated environments.
• Understanding of testing discipline, reconciliation, operational control processes and audit requirements.
• Maths, statistics, quantitative analysis or data-modelling exposure.
• Experience using AI tools, LLMs or automation platforms to improve business or technology workflows.

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.