DATA WAREHOUSING SPECIALIST

CenturionRole Purpose:Existing MIS databasesExisting reports and dashboardsExisting data warehousesDevelop, 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.Remain informed about developments and trends in the data enablement field to assist the business to keep its data analytics and management capability up-to-date, and able to meet the future needs of the business in a constantly maturing and increasingly complex short-term insurance industry. Responsibilities:Internal ProcessCollaborate with Project Managers and Business Leaders to deliver quality, effective management information, data warehouse and business intelligence applications, in line with the agreed development process and business needs.Collaborate with stakeholders to gather requirements, conduct analysis and prioritise requests.Conduct research and evaluate potential technical solutions to identified business problems.Translate business requirements into workable solutions and document solutions into technical specifications, partnering with Business and/or System Analysts when required.Design and code new database and analytics functionality using code that is readable, maintainable and re-usable.Conduct Unit Testing of own code and resolve all issues/queries timeously.Contribute to user acceptance testing (UAT) to ensure that functionality is working correctly.Deliver solutions into the applicable production environment once testing has been completed.Provide stakeholders with regular feedback on the technical design and timelines for solution ensuring that business needs are met.Maintain existing databases and applications according to change requests approved by business as and when needed.Diagnose root causes of issues through problem-solving and recommend potential solutions.Monitor performance of solutions and make recommendations to improve the performance and functionality of the solutions, where appropriate.Log issues found in existing systems as internal change controls and ensure successful resolution of issues. Role-Specific Responsibilities And OutputsDevelop, implement and document Business Intelligence Solutions (Internal Process):Contribute to the overall data warehouse architecture and data base designsMaintain and oversee the administration and maintenance of the data warehouseDevelop and maintain Business Intelligence and reporting technologies and processesTranslate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applicationsDesign and develop reports and dashboards based on Business Requirements Document (BRD) and customer specificationsDevelop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutionsEnsure the continued maintenance and enhancement to existing