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
Beware of fraud agents! do not pay money to get a job
MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.