About the Position

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

• To be responsible for the development and maintenance of ETL jobs and the ETL environment.
• To be responsible for the development of SQL procedures, functions and views.
• To be responsible for the development of Business Objects Crystal reports as well as Universes.
• To review data loaded into the data warehouse for accuracy.
• To conduct peer review and quality checks.
• To recommend maintenance enhancements to data acquisition processes in order to improve accuracy of data warehouse data.
• To enrich the data warehouse capabilities in line with the growth of the organisation and its information needs.
• To develop/propose new ways to utilise/increase the volume of the data warehouse and information delivery capabilities of Ubank.
• To make recommendations to operational support for enhancements of systems to record and improve accuracy of operational data.
• To review referential and historical integrity of datawarehouse data.
• To resolve data quality problems: Identify, assess, fix, document and communicate.
• To provide quality assurance oversight of data flows and data stores, review quality of data, entry loads, transformations, extractions, mergers or other production jobs.
• To provide data quality advisory services to the organisation.
• Manage reporting metadata and data standardisation for end to end integration.
• Ensure accuracy & integrity of data through analysis, coding, writing clear documentation & problem resolution.
• Develop, test & implement ETL job logic.
• To assist in all areas of data warehouse functions when and where needed.
• Liaise with vendors for problem resolution when needed.

Desired Skills

Desired Work Experience

Desired Qualification Accreditation

Employer & Job Benefits