Technical Reporting Analyst

Ninety One; Cape Town; On-site; ZAR 300,000 - 600,000; Full time

Job summary

A leading investment management firm in Western Cape, Cape Town is seeking a Technical Reporting Analyst to enhance client reporting experiences. The ideal candidate has 3-5 years of experience in data analysis, proficiency in SQL, and is comfortable collaborating with various business areas. This role involves creating reports, optimizing SQL procedures, and ensuring effective communication of findings. Attractive opportunities for growth and innovation await you.

Qualifications

• 3 - 5 years of relevant working experience.
• Experience with Microsoft SQL Server, Excel, and Transact SQL.
• Asset management experience is desirable.

Responsibilities

• Create detailed reports and queries based on specifications.
• Analyse and optimise performance of stored procedures.
• Collaborate with business areas to gather requirements.

Skills

SQL

Data analysis

MS SQL Server

Excel

Python

Tools

GitHub

Job description

Overview

Job title: Technical Reporting Analyst

Job Location: Western Cape, Cape Town

Deadline: October 08, 2025

About the team: Our dynamic Reporting Solutions team at Ninety One plays a pivotal role in enhancing our clients reporting experience, both internally and externally. As a key member of our team, you'll leverage technologies like data warehouses, MS SQLServer, Python, and more to implement and enhance innovative reporting solutions. Your responsibilities will span from gathering business requirements and generating detailed specifications to implementing robust solutions and resolving queries. If you're passionate about working with, investigating, and transforming data into useful reports and thrive in a collaborative environment, this is the perfect opportunity for you!

In this role you will :

• Create detailed reports, extracts, and queries based on requirement specifications using technologies like SQL.
• Analyse and optimise the performance of stored procedures to ensure efficiency.
• Understand the data architecture within Ninety One to meet the reporting solution and query resolution needs.
• Collaborate with various business areas to gather requirements and translate them into clear specifications.
• Identify and resolve issues in existing reports and implement corrective actions.
• Effectively communicate analysis findings to internal stakeholders.

You should consider applying if you have :

• Relevant 3 - 5 years working experience
• Microsoft Technologies: MS SQL Server, Excel, Transact SQL experience essential
• Asset management experience desirable
• Some Python knowledge will be an advantage
• Source Control System knowledge desirable, GitHub

Some of the attributes we look for in a person are :

• The ability to ‘approach and own’ and continuously look for opportunities to develop
• Ability to recognise and embrace change
• Ability to analyse, interpret and assimilate information
• A curiosity about technology and its potential to drive innovation
• Research / Data Analysis jobs