Technical Reporting Analyst (SQL) (Contract) (CPT)

DataFin; Cape Town; On-site; ZAR 400,000 - 600,000; Full time

Job summary

An Independent Asset Management Firm in Cape Town seeks a Technical Reporting Analyst to enhance clients' reporting experience. You will gather business requirements and implement robust reporting solutions using technologies like MS SQL Server and Python. The ideal candidate has 3-5 years of experience in a relevant role. This is a 9-month maternity cover contract offering an opportunity to thrive in a dynamic environment.

Qualifications

• 3-5 years of relevant working experience in a reporting role.
• Proficiency in Microsoft Technologies: MS SQL Server and Transact SQL.
• Experience with GitHub for source control.

Responsibilities

• Create detailed reports and queries based on requirement specifications using SQL.
• Analyse and optimise stored procedures for efficiency.
• Collaborate with business areas to gather and translate requirements.

Skills

SQL

Data analysis

Understanding of data architecture

Microsoft Excel

Tools

MS SQL Server

Transact SQL

GitHub

Python

Job description

Overview

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. Please note this is a 9-Month Maternity Cover Contract.

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.