Data Warehouse Manager
2 weeks ago
**Introduction**Role Purpose**
- Data Warehouse Manager manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. Oversees data design and the creation of database architecture and data repositories. The Data Warehouse Manager must also establish and lead a world class data analytics/warehouse capability for Momentum Insure to enable future needs for advanced analytics and AI.Maintain and support:
- Existing MIS databases
- Existing reports and dashboards
- Existing data warehouses
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.
**Requirements**:
**Experience and Qualifications**
- Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - Essential
- Dimensional modelling and/or relevant Microsoft certification - Advantageous
- 3 - 5 years of management experience taking care of teams between 5 - 8 people - Essential
**On
- the-job training/qualifications**:
- Microsoft Sql Server
- Oracle
- Power BI
- Advanced MS Excel
- Starquest
Some experience in predictive analytic platforms will be advantageous.
These include:
- Python
- Scala
- Spark
- AWS Sagemaker
Some experience in Azure / AWS platform services will be advantageous. These include:
- Azure SQL elastic instance
- Data factory
- PowerBI
- AWS RDS
**Minimum Experience**
Methodologies
Principles
- Knowledge of Domain driven design would be an advantage
Modelling
- Knowledge of Immon data warehouse modelling techniques would add an advantage
Data Transportation
Development Software
- Dynamic T-SQL
- Multi-threading
- Performance optimisation and tuning
- Knowledge of Database Administration would add an advantage
- Expert knowledge in configuration of database hardware resources
Repository type
- Knowledge of Data Lake would be an advantage
- Knowledge of Oracle would be an advantage
- Knowledge of Hadoop is not essential but will also be an advantage
**Duties & Responsibilities**
**Outputs**
**Internal Process**
- 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.
- 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 Outputs**
- Develop, implement and document Business Intelligence Solutions (Internal Process):
- Contribute to the overall data warehouse architecture and data base designs
- Maintain and oversee the administration and maintenance of the data warehouse
- Develop and maintain Business Intelligence and reporting technologies and processes- Design and develop reports and dashboards based on Business Requirements Document (BRD) and customer specifications
- Develop feasible technical specifications and process flows for data provision activities in support of the development of business intelligence solutions
- Ensure the continued maintenance and enhancement to existing business intelligence solutions
- Within user specifications extract, transform and load (ELT) data using the relevant tools
- Verify and quality assure of data provided
- Provide support to business intelligence users on data-related issues
- Future development and planning-
**Self-management and Teamwork**
- Provide authoritative expertise and advice to colleagues
- Develop and maintain productive and collaborative working relationships with peers and team members.
- Deliver on Service Level Agreements made with colleagues
- Participate and contribute to a culture of work-centric thinking, productivity, service delivery and quality management.
- Contribute to continuous innovation through the development, sharing and implementation of new ideas and involve
-
Data Warehouse Manager
4 weeks ago
Centurion, South Africa Emporium Human Capital Full timeData Warehouse Manager POSV2Based: CenturionSalary: R900K to R1.2 milExperience and QualificationsRelevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) ( Essential)Microsoft; SQL Server; Oracle; Power BI; Advanced MS Excel; Starquest (Essential)3 5 years of management experience (Essential)Dimensional modelling and/or relevant...
-
Data Warehouse Manager
3 weeks ago
Centurion, South Africa Emporium Human Capital Full timeData Warehouse Manager POSV2 Based: Centurion Salary: R900K to R1.2 mil Experience and Qualifications Relevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) ( Essential) Microsoft; SQL Server; Oracle; Power BI; Advanced MS Excel; Starquest (Essential) 3 5 years of management experience (Essential) Dimensional modelling and/or...
-
Data Warehouse Manager
4 weeks ago
Centurion, South Africa Rise Recruiting Agency Full timeOur client in the Finance space is looking for a Data Warehouse Manager to join them in Centurion, Gauteng. **Purpose of the job** Data Warehouse Manager manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. Oversees data design and the creation of database...
-
Data Warehouse Manager
21 hours ago
Centurion, South Africa BAEC Specialists Full time**Location**: Centurion | **Work Model**: Hybrid | **Contract**:Full-time Permanent **Role Purpose** Data Warehouse Manager manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. Oversees data design and the creation of database architecture and data repositories....
-
Data Warehouse Manager
3 hours ago
Centurion, South Africa BAEC Specialists Full timeLocation: Centurion | Work Model: Hybrid | Contract: Full-time Permanent Role Purpose Data Warehouse Manager manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and projects. Oversees data design and the creation of database architecture and data repositories. The Data...
-
Data Warehouse Specialist
3 weeks ago
Centurion, South Africa Keo-Kutlwi Group (Pty)Ltd Full timePurpose 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...
-
Data Warehouse Manager
3 weeks ago
Centurion, South Africa Adzuna ZA B C2 Full timeExperience and QualificationsRelevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - EssentialDimensional modelling and/or relevant Microsoft certification Advantageous3 5 years of management experience taking care of teams between 5 8 people - Essential On- the-job training/qualifications:Microsoft Sql ServerOraclePower BIAdvanced...
-
Data Warehouse Manager
4 weeks ago
Centurion, South Africa Samaha Consulting Full timeExperience and QualificationsRelevant IT and data analytics qualifications e.g. B.Tech or B.Sc. (Informatics) - EssentialDimensional modelling and/or relevant Microsoft certification Advantageous3 5 years of management experience taking care of teams between 5 8 people - Essential On- the-job training/qualifications:Microsoft Sql ServerOraclePower...
-
Warehouse Supervisor
4 weeks ago
Centurion, South Africa Swift Human Resources Full time**Job Title**: Warehouse Supervisor (1 to 2 month contract) **Area**: Centurion (must have own transport due to shift work) **Job Purpose**: Assist the Warehouse Departmental Manager in maintaining the smooth operations of a fast-moving environment. Responsible for the day-to-day management of people within the warehouse function, to ensure that the...
-
Dispensary Warehouse Manager
4 weeks ago
Centurion, South Africa Amka Products Full time**Key Deliverables**: - Implementing and ensuring the continuous success of the new Chemical Batch scanning system on SAP for better management and traceability purposes - Managing the functions of receiving, put-away, picking, and supplying to the factories & Compounding - Managing inventory, accuracy, and batch control as well as condition of the stock. -...
-
Oil Storage Warehouse Supervisor
4 weeks ago
Centurion, South Africa Swift Human Resources Full time**Job Purpose**: Leading a team primarily responsible for the handling and storage of Oil products. Responsible for the day-to-day management of staff within the Oil Warehouse function, to ensure that the company’s targets and objectives are met and to meet the customer requirements. Ensure that the staff comply with health, safety, and standard operating...
-
Warehouse Supervisor
4 weeks ago
Centurion, South Africa Curiska (Pty) Ltd Full time**Warehouse Supervisor** This person is responsible for overseeing the general operations of the warehouse and its staff. We are looking for an experienced Warehouse Supervisor to oversee and coordinate the daily warehousing activities. You will implement production, productivity, quality, and customer service standards and achieve the appropriate level of...
-
DATA WAREHOUSE MANAGER
4 weeks ago
Centurion, South Africa Acuity Consultants Full timeJob Description Exciting opportunity for Data Warehouse Manager to join SA’s leading FSP and lead a team who design, implement, maintain and support DWH systems. Based in CENTURION (Hybrid) region, this DWM position offers R1.2m – R1.4m. THE COMPANY: A JSE listed FSP and a leading provider of flexible insurance solutions that are customized to...
-
Warehouse Manager, E-commerce Fulfillment
4 weeks ago
Centurion, South Africa Nile Fresh (Pty) Ltd Full timeAt Nile, we see roles as an opportunity for personal development. As our business grows, so will the scope of your role. Today, our team requires a Warehouse Manager with experience in managing people and processes within a highly operational environment. The successful applicant will take ownership of the following functions: - Schedule inbound receiving...
-
Regional Warehouse Coordinator
4 weeks ago
Centurion, South Africa Helderberg Personnel Full timeA well-established client based in Gauteng - Centurion is seeking to employ a Regional Warehouse Coordinator who will be responsible and accountable for the efficient and effective coordination of Warehouse and Logistics Function within the company. Encompassing the control of Finished Goods Warehouses and Dispatch of goods/products to customers. dispatch...
-
Data Warehousing Specialist | Centurion
4 weeks ago
Centurion, South Africa The Recruitment Council Full timeJoin a leading Financial Services firm in their quest for excellence! Are you a skilled Data Warehousing Specialist seeking an exciting opportunity to make a significant impact? Our client, a prominent player in the financial industry, is actively seeking a talented professional like yourself to join their dynamic team. You will need to establish and lead a...
-
Warehouse Pharmacist
4 weeks ago
Centurion, South Africa People Dimension Full timeDuties & ResponsibilitiesEssential Duties and Responsibilities: Ensure quality, efficiency and safety of medicines are maintained through the distribution chain.Ensure good warehouse practice (GWP) compliance.Receiving of MedicationStoragePackagingTemperature MaintenancePicking and PackingSupervise warehouse staffReturn and DestructionCycle CountsStock...
-
Centurion, South Africa Danaher Full timeDescription : As a Logistics and Distribution Warehouse Administrator at Beckman Coulter Diagnostics South Africa, you will play a pivotal role in managing the efficient and effective operation of our warehouse facility. Reporting to the Logistics and Distribution Manager, you will be responsible for overseeing various aspects of logistics, inventory...
-
Centurion, South Africa Danaher Full timeBeckman Coulter Diagnostics, a renowned leader in the field of medical diagnostics, is seeking a dynamic and detail-oriented individual to join our team as a Logistics and Distribution Warehouse Administrator. This position offers an exciting opportunity to contribute to our mission of advancing healthcare through innovative solutions. If you are passionate...
-
Centurion, Gauteng, South Africa Danaher Full timeBeckman Coulter Diagnostics, a renowned leader in the field of medical diagnostics, is seeking a dynamic and detail-oriented individual to join our team as a Logistics and Distribution Warehouse Administrator. This position offers an exciting opportunity to contribute to our mission of advancing healthcare through innovative solutions. If you are passionate...