Data Analyst

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 Dev Ops
• Excellent Excel skills
• Good written and verbal communication skills