Data Warehouse Specialist

Purpose of the Job: Maintain and support existing MIS databases; reports and dashboards, data warehouses. Develop, test, deploy, maintain and support new databases, and reporting, data warehouse and business intelligence applications from high-level business requirements and designs, through the Software Development Life Cycle.

Duties and responsibilities
Develop, implement and document Business Intelligence Solutions (Internal Process):
o Contribute to the overall data warehouse architecture and data base designs
o Maintain and oversee the administration and maintenance of the data warehouse
o Develop and maintain Business Intelligence and reporting technologies and processes
o Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications
o Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications
o Develop feasible technical specifications and process flows for data provision activities in support of the development of business
intelligence solutions
o Ensure the continued maintenance and enhancement to existing business intelligence solutions
o Within user specifications extract, transform and load (ELT) data using the relevant tools
o Verify and quality assure of data provided
o Provide support to business intelligence users on data-related issues

Future development and planning
o Conduct research and undergo training where appropriate, in order to remain abreast of data enablement trends and understand their
application in the short-term insurance industry
o Assist management and colleagues to make the right decisions in terms of planning future data enablement infrastructure, architecture
and applications in the short-term insurance business, in alignment with company standards and the South African financial services
regulatory framework.

Qualifications Required:
• Relevant IT and data analytics qualifications, e.g. B.Tech or B.Sc. (Informatics)
• Dimensional modelling and/or relevant Microsoft certification

Experienced Required
• Candidate must have 4 or more years’ experience in:
o Data modelling
o Data Transportation
o Software development