Cape Town City Centre: Technical Reporting Analyst (SQL) (Contract) (CPT)

ENVIRONMENT: PLAY a pivotal role in enhancing clients reporting experience by gathering business requirements and generating detailed specifications to implementing robust solutions and resolving queries as the next Technical Reporting Analyst wanted by an Independent Asset Management Firm. As a key member of the team, you’ll leverage technologies like data warehouses, MS SQL Server, Python, and more to implement and enhance innovative reporting solutions. DUTIES: 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 the firm 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. REQUIREMENTS: Relevant 3 – 5 years working experience. Microsoft Technologies: MS SQL Server, Excel, Transact SQL experience essential. GitHub. Advantageous – Asset Management experience. Source Control System knowledge. Some Python knowledge. ATTRIBUTES: The ability to ‘approach and own’ and continuously looks for opportunities to develop. Ability to recognise and embrace change. Can analyse, interpret and assimilate information. A curiosity about technology and its potential to drive innovation.