Business Intelligence Developer

SUMMARY:
To take ownership for the development of the warehouse including SQL procedures, ETL jobs and their operating environment and processes.

POSITION INFO:

1. To be responsible for the development and maintenance of ETL jobs and the ETL environment.
2. To be responsible for the development of SQL procedures, functions and views.
3. To be responsible for the development of MicroStrategy reports, HyperCards, Cubes and dashboards.
4. To review data loaded into the data warehouse for accuracy.
5. To conduct peer review and quality checks.
6. To recommend maintenance enhancements to data processes in order to improve accuracy of data warehouse data.  
7. To enrich the data warehouse capabilities in line with the growth of the organisation and its information needs.
8. To develop/propose new ways to utilise/increase the volume of the data warehouse and information delivery capabilities of Ubank. 
9. To make recommendations to operational support for enhancements of systems to record and improve accuracy of operational data.
10. To support data governance business intelligence processes including BCBS239.
11. To resolve data quality problems: Identify, assess, fix, document and communicate.
12. To provide quality assurance oversight of data flows and data stores, review quality of data, entry loads, transformations, extractions, mergers or other production jobs. 
13. To provide data quality advisory services to the organisation.
14. Manage reporting metadata and data standardisation for end to end integration.
15. Ensure accuracy & integrity of data through analysis, coding, writing clear documentation & problem resolution.
16. Develop, test & implement ETL job logic.
17. To assist in all areas of data warehouse functions when and where needed. 
18. Liaise with vendors for problem resolution when needed.

NB! This job is now closed. You can apply for other jobs by uploading your CV.