Job Title: Data Warehouse ManagerLocation: CenturionIndustry: InsurancePosition Type: Full-TimeAbout the Role:The Data Warehouse Manager manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. This role involves overseeing data design and the creation of database architecture and data repositories. The Data Warehouse Manager must establish and lead a world-class data analytics/warehouse capability for the company to enable future needs for advanced analytics and AI.Key Responsibilities:Maintain and Support:Existing MIS databasesExisting reports and dashboardsExisting data warehousesDevelop, Test, Deploy, Maintain, and Support:New databasesReporting, data warehouse, and business intelligence applications from high-level business requirements and designs through the Software Development Life CycleInternal Process:Collaborate 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 prioritize 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 reusable.Conduct unit testing of own code and resolve all issues/queries promptly.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 solutions ensuring that business needs are met.Maintain existing databases and applications according to change requests approved by the business as and when needed.Diagnose root causes of issues through problem-solving and recommend potential solutions.Monitor the 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 Outputs:Develop, implement, and document Business Intelligence Solutions:Contribute to the overall data warehouse architecture and database 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 of existing business intelligence solutionsWithin user specifications, extract, transform, and load (ELT) data using the relevant toolsVerify and quality assure data providedProvide support to business intelligence users on data-related issuesFuture Development and Planning:Conduct research and undergo training where appropriate to remain abreast of data enablement trends and understand their application in the short-term insurance industryAssist management and colleagues in making the right decisions in terms of planning future data enablement infrastructure, architecture, and applications in the companys short-term insurance business, in alignment with company group standards and the South African financial services regulatory framework.Self-management and Teamwork:Provide authoritative expertise and advice to colleaguesDevelop and maintain productive and collaborative working relationships with peers and team membersDeliver on Service Level Agreements made with colleaguesContinuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specializationParticipate and contribute to a culture of work-centric thinking, productivity, service delivery, and quality managementContribute to continuous innovation through the development, sharing, and implementation of new ideas and involvement of peersTake ownership of driving career developmentFinance:Manage financial and other company resources under your control with due respect.Competencies Required:Business AcumenClient / Stakeholder CommitmentDrive for ResultsLeads Change and InnovationMotivating and Inspiring TeamCollaborationImpact and InfluenceSelf-Awareness and InsightDiversity and InclusivenessGrowing TalentSkills:Communication articulating information and challenging ideasAnalyzing and interpreting dataProblem-solvingPlanning and organizing time and task managementExperience and Qualifications:Relevant IT and data analytics qualifications, e.g., B.Tech or B.Sc. (Informatics) - EssentialDimensional modeling and/or relevant Microsoft certification Advantageous3 5 years of management experience taking care of teams between 5 8 people - EssentialOn-the-job Training/Qualifications:Microsoft SQL ServerOraclePower BIAdvanced MS ExcelStarquestExperience in Predictive Analytic Platforms:PythonScalaSparkAWS SagemakerExperience in Azure / AWS Platform Services:Azure SQL elastic instanceData factoryPowerBIAWS RDSMethodologies:Ability to elicit data requirements from stakeholdersClear documentation skillsPrinciples:Familiarity with design patterns in the data development industrySolid understanding of metadata constructsA clear understanding of EDWKnowledge of Domain-driven design AdvantageousFamiliarity with the concept of Data MartsFamiliarity with abstraction techniquesModelling:Proven data modeling techniques (3 years)Knowledge and experience in Ralph Kimball data warehouse modelling (3 years)Knowledge of Immon data warehouse modelling techniques AdvantageousData normalization skills, especially the 2nd Normal formData Transportation:Solid experience with ETL systemsSolid experience in sourcing, staging, and loadingFamiliarity with parallel loading principlesFamiliarity with source-to-target mappingDevelopment Software:Advanced knowledge of T-SQL (4 years) including:Dynamic T-SQLMulti-threadingPerformance optimization and tuningPractical experience with SQL Server Database Engine (4 years)Practical experience with MS SSIS ETL software (4 years)Practical experience with MS SSAS OLAP software (4 years)Practical experience with MS Visual Studio Data Tools (4 years)Knowledge of Database Administration AdvantageousExpert knowledge in the configuration of database hardware resourcesRepository Type:Ability to source data from different repositoriesFull acquaintance with Microsoft SQL Server repositoryKnowledge of Data Lake AdvantageousKnowledge of Oracle AdvantageousKnowledge of Hadoop AdvantageousHow to Apply:Please send your resume outlining why you would be suitable for the role.
