SQL Developer/Analyst (Contract) (CPT)

DataFin; Cape Town; On-site; ZAR 200 000 - 300 000; Full time

Job summary

An Independent Asset Management Firm in Cape Town is seeking a SQL Developer/Analyst for a 9-month maternity cover contract. The role involves creating reports and optimising stored procedures, requiring 3-5 years of experience with MS SQL Server and Transact SQL. Ideal candidates will have a curiosity for technology and strong analytical skills. This role offers an opportunity to enhance reporting solutions in a dynamic environment.

Qualifications

• 3 - 5 years of relevant working experience.
• Experience with Microsoft Technologies essential.

Responsibilities

• Create detailed reports based on requirement specifications using SQL.
• Analyse and optimise performance of stored procedures.
• Understand data architecture to meet reporting and query needs.

Skills

MS SQL Server

Transact SQL

Data analysis

Tools

Excel

GitHub

Python

Job description

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 SQL Developer/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.