Role Purpose
To develop, test, deploy, document and maintain highvalue reporting solutions and dashboards across the business using a variety of tools.
Requirements
- 3 - 5 years Business Intelligence development experience (essential)
- Experience in programming and data warehousing (essential)
- Matric (Grade 12) certificate
- Degree in Information Technology/ Data Science/ Computer Science and or relevant equivalent qualification
- Understanding of SQL and RDBMS technology (MySQL, MS SQL Server, DB2)
- Analytic software applications (e.g. Microsoft SQL Reporting Services)
- Knowledge of business intelligence tools (e.g. SSRS, Business Objects, PowerBI, Tableau, Quick sight etc.)
- Relational database design - operational data stores and warehouses
- Demonstrated detailed knowledge of BI areas including; ETL design, analytics, reporting and data modelling
- Knowledge of and experience in advanced excel
- Knowledge of OLTP/OLAP systems, Dimensional Modelling, business rule transformations and data analysis
- Knowledge of debugging & troubleshooting techniques
- Knowledge of Software Development Lifecycle
Duties and Responsibilities
- Design, develop, and maintain data warehouses that serve as the central repositories of integrated data for reporting and analysis purposes.
- Develop and maintain Business Intelligence and reporting technologies and processes
- Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.
- Translate stakeholder requirements into functional and non-functional specifications for Business Intelligence (BI) reports.
- Extract user specifications and transform and load data using the relevant tools.
- Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications.
- Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions.
- Verify the quality of the data provided and build security into solutions as per Business Intelligence specifications.
- Conduct User Acceptance Testing (UAT) and resolve all issues/queries.
- Monitor performance of solutions and make recommendations to improve the performance and functionality of the solution.
- Log issues found in existing systems as internal change controls and ensure successful resolution of issues.
- Complete change control on change control list as per level of priority including maintaining and oversee the administration and maintenance of the data warehouse.
- Ensure data accuracy, consistency, and reliability across systems by implementing data quality checks, validations, and governance processes.
As an applicant, please verify the legitimacy of this job advert on our company career page.-346021296