Experience & Qualifications:
- Grade12/Matric/Equivalent.
- BCom / BSc Computer Science/Information Systems) BTech (Information Technology) or MSc (Computer Science) essential.
- Minimum of 8 years’ relevant experience in Business Intelligence.
- Added with at least 5 years’ experience in any of Data Warehousing, Software Development Database Administration (DBA) or a combination of these:
- Knowledge & understanding of; Planning, designing and data architecting a business solution.
- Understanding and applying relevant data modeling with governance and best practices.
- Data warehouse Concepts and Techniques.
- ETL.
- Technical Documenting Business, Data Analysis and effective project management.
- Visualization tools.
- Strong Structured Query Language (SQL) with at least 2 years experience.
- Business Intelligence Suite, Cognos or Business Objects PowerBI, Qlik, tableau or any related tools.
- Any programming language including Java, C++, C#.
- Strong database understanding. Analytical skills and problem solving skills.
- Adopting a different perspective or mindset – broader and more team-oriented with an eye to impact on the enterprise.
Responsibilities:
- Receive requirements from BI Manager, business stakeholders or directly from client.
- Analyze requirements and use ability of existing data warehouse structures to meet requirements.
- Design data models or enhancements to existing data tables following best practice such as Ralph Kimball/Inmon Modeling.
- Ensure that drill-through capability to source data is always possible.
- Get sign-off from BI Manager on proposed design.
- Develop code in accordance with the department’s design conventions including naming conventions and formatting conventions.
- Test and QA data against source systems to ensure accuracy after development.
- Obtain business stakeholder and client testing of results.
- Obtain sign-off from business stakeholders and/or BI Manager on database development carried out.
- Promote scripts through version control to production data warehouse.
- Ensure no operational code relies on development environment.
- Continuously research, evaluate and test new technologies to provide more efficient and adaptable solutions.
- Adhere to POPI and privacy of information.
- Development and maintenance of dynamic BI Reports, dash boards and stories to different audiences.
- Develop and maintain efficient models within the BI framework.
- Validation of information within produced reports.
- Timely distribution of reports (within SLA and internal BI guidelines) in agreed formats.
- Constant investigation and collaboration with the company with respect to information needs.
- Feeding back information needs to BI team in order to ensure that data is available for reporting and statistics.
- In consultation with the users at whom the models are targeted, design and modify the models until they are ready for use.
- In collaboration with the company management, identify standard reporting needs and design “self-service” reports to be placed on the intranet.
- In collaboration with the company management, identify dimensional drill-through paths and develop appropriate dynamic reports.
- Ensure that client Scheme management (Board of Trustees) has access to high level statistics housed in summary tables as agreed from time to time.
- Supporting and development of Regulatory Reporting.
- Ensure that documentation is done according to internal BI rules and procedures.
- Test and validate all solutions.
- Providing technical support to users of the company suite of BI tools.
- Conduct and organize training sessions in the use of the company suite of BI tools.
- Ensure the business stakeholders are well trained and understand how to use BI solution designed for them.