Data Analyst

B-Sure Talent Solutions; Johannesburg; On-site; ZAR 300,000 - 400,000; Full time

Job summary

A dynamic recruitment firm is seeking a Data Analyst in Johannesburg. This role involves designing and deploying reporting solutions, optimizing data queries, and collaborating with the Business Intelligence team. Ideal candidates will have at least 5 years of experience, strong SQL skills, and excellent Excel proficiency. If you thrive in data analytics and have a passion for problem-solving, we want to hear from you.

Qualifications

• At least 5 years’ relevant working experience is required.
• Strong query writing and optimisation experience in MS SQL is essential.
• Cloud experience with Synapse/Data Factory is advantageous.

Responsibilities

• Design, develop and deploy reporting and analytical capabilities.
• Create visual reports for management.
• Investigate reporting queries and maintain data quality.

Skills

MS SQL query writing

Data optimisation

Power BI

Excel skills

Good communication

Education

Matric

Tools

SQL Server

SSIS

SSRS

Cloud technologies

Job description

Data Analyst required in Bedfordview, Johannesburg.

Duties and Responsibilities:

• Design, develop and deploy reporting and analytical capabilities, adhering to internal architecture and data integration standards as well as the long-term Business Intelligence technical strategy.
• Create visual reports for management.
• Investigate reporting queries.
• Maintain data quality by developing data quality scripts and investigating source data and systems.
• Understand all business processes and systems to develop reporting solutions.
• Collaborate within the Business Intelligence team to build and maintain an end-to-end Business Intelligence solution that meets business requirements.
• Make modifications to existing Business Intelligence reporting and analytical solutions to accommodate changes in source systems and new business requirements.
• Optimize reporting and analytical solutions to provide optimal performance under increasing data volumes.
• Document solutions, both technical (design & metadata) and procedural (policies and procedures) to ensure that colleagues understand how to support the solution.
• Test reporting solutions (unit testing & system integration testing) and verify that it meets business, functional and technical specifications.

Requirements:

• Matric (essential)
• At least 5 years’ relevant working experience
• Strong MS SQL query writing and optimising experience (SQL, SSIS, SSRS, Power BI)
• Database design and optimisation
• Cloud experience (Synapse/Data factory) will be advantageous.
• Relevant exposure to DevOps
• Excellent Excel skills
• Good written and verbal communication skills