Data Warehouse Manager

1 week ago

Randburg, South Africa Energy at Work Projects Full time
Data Warehouse Manager
Centurion
Permanent
Centurion

Job Title: Data Warehouse Manager
Location: Centurion
Industry: Insurance
Position Type: Full-Time

About 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 databases
    • Existing reports and dashboards
    • Existing data warehouses
  • Develop, Test, Deploy, Maintain, and Support:
    • New databases
    • Reporting, data warehouse, and business intelligence applications from high-level business requirements and designs through the Software Development Life Cycle
  • Internal 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 designs
      • Maintain and oversee the administration and maintenance of the data warehouse
      • Develop and maintain Business Intelligence and reporting technologies and processes
      • Translate stakeholder requirements into technical specifications for Business Intelligence (BI) reports and applications
      • 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 of existing business intelligence solutions
      • Within user specifications, extract, transform, and load (ELT) data using the relevant tools
      • Verify and quality assure data provided
      • Provide support to business intelligence users on data-related issues
  • Future 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 industry
    • Assist management and colleagues in making the right decisions in terms of planning future data enablement infrastructure, architecture, and applications in the company’s 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 colleagues
    • Develop and maintain productive and collaborative working relationships with peers and team members
    • Deliver on Service Level Agreements made with colleagues
    • Continuously develop own expertise in terms of industry and subject matter development and application thereof in an area of specialization
    • 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 involvement of peers
    • Take ownership of driving career development
  • Finance:
    • Manage financial and other company resources under your control with due respect.
Competencies Required:
  • Business Acumen
  • Client / Stakeholder Commitment
  • Drive for Results
  • Leads Change and Innovation
  • Motivating and Inspiring Team
  • Collaboration
  • Impact and Influence
  • Self-Awareness and Insight
  • Diversity and Inclusiveness
  • Growing Talent
Skills:
  • Communication – articulating information and challenging ideas
  • Analyzing and interpreting data
  • Problem-solving
  • Planning and organizing – time and task management
Experience and Qualifications:
  • Relevant IT and data analytics qualifications, e.g., B.Tech or B.Sc. (Informatics) - Essential
  • Dimensional modeling 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
Experience in Predictive Analytic Platforms:
  • Python
  • Scala
  • Spark
  • AWS Sagemaker
Experience in Azure / AWS Platform Services:
  • Azure SQL elastic instance
  • Data factory
  • PowerBI
  • AWS RDS
Methodologies:
  • Ability to elicit data requirements from stakeholders
  • Clear documentation skills
Principles:
  • Familiarity with design patterns in the data development industry
  • Solid understanding of metadata constructs
  • A clear understanding of EDW
  • Knowledge of Domain-driven design – Advantageous
  • Familiarity with the concept of Data Marts
  • Familiarity with abstraction techniques
Modelling:
  • Proven data modeling techniques (3 years)
  • Knowledge and experience in Ralph Kimball data warehouse modelling (3 years)
  • Knowledge of Immon data warehouse modelling techniques – Advantageous
  • Data normalization skills, especially the 2nd Normal form
Data Transportation:
  • Solid experience with ETL systems
  • Solid experience in sourcing, staging, and loading
  • Familiarity with parallel loading principles
  • Familiarity with source-to-target mapping
Development Software:
  • Advanced knowledge of T-SQL (4 years) including:
    • Dynamic T-SQL
    • Multi-threading
    • Performance optimization and tuning
  • Practical 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 – Advantageous
  • Expert knowledge in the configuration of database hardware resources
Repository Type:
  • Ability to source data from different repositories
  • Full acquaintance with Microsoft SQL Server repository
  • Knowledge of Data Lake – Advantageous
  • Knowledge of Oracle – Advantageous
  • Knowledge of Hadoop – Advantageous
How to Apply:
Please send your resume outlining why you would be suitable for the role.

  • Warehouse Manager

    7 days ago

    Randburg, South Africa Xperien (Pty) Ltd Full time

    Xperien is the leader in sustainable computing in Southern Africa. We are a passionate team of professionals who care about our planet, its people and its resources. ❤️ We have a vacancy for an energetic individual with strong warehouse and people management skills. The Warehouse Manager should have a positive and confident attitude to deal with a...

  • Warehouse Manager

    2 weeks ago

    Randburg, Gauteng, South Africa Xperien (Pty) Ltd Full time

    Xperien is the leader in sustainable computing in Southern Africa. We are a passionate team of professionals who care about our planet, its people and its resources. We have a vacancy for an energetic individual with strong warehouse and people management skills. The Warehouse Manager should have a positive and confident attitude to deal with a diverse team....

  • Warehouse Manager

    4 weeks ago

    Randburg, South Africa Xperien (Pty) Ltd Full time

    Xperien is the leader in sustainable computing in Southern Africa. We are a passionate team of professionals who care about our planet, its people and its resources. ❤️ We have a vacancy for an energetic individual with strong warehouse and people management skills. The Warehouse Manager should have a positive and confident attitude to deal with a...

  • Warehouse Manager

    2 weeks ago

    Randburg, Gauteng, South Africa Xperien (Pty) Ltd Full time

    Xperien is the leader in sustainable computing in Southern Africa. We are a passionate team of professionals who care about our planet, its people and its resources. We have a vacancy for an energetic individual with strong warehouse and people management skills. The Warehouse Manager should have a positive and confident attitude to deal with a diverse team....

  • Warehouse Manager

    4 weeks ago

    Randburg, South Africa Edge Personnel (Pty) Ltd Full time

    The ideal incumbent will be responsible for, but not limited to: Ensure the warehouse operates at peak efficiency, with customer satisfaction being the primary goal, by supervising, organizing, directing, and training warehouse employees and establishing, monitoring, and managing operation goals Develop warehouse operations systems by determining product...

  • Warehouse Manager

    2 weeks ago

    Randburg, Gauteng, South Africa Edge Personnel (Pty) Ltd Full time

    The ideal incumbent will be responsible for, but not limited to:Ensure the warehouse operates at peak efficiency, with customer satisfaction being the primary goal, by supervising, organizing, directing, and training warehouse employees and establishing, monitoring, and managing operation goalsDevelop warehouse operations systems by determining product...

  • Warehouse Manager

    2 weeks ago

    Randburg, Gauteng, South Africa Beautician and Physician Full time

    A dynamic, fast growing skincare distribution company in Randburg, who imports from various countries across the world and distributes across Sub Saharan Africa, is looking for an experienced and organised Warehouse Manager to join the team and manage the warehouse.We are looking for an individual with a strong personality, pro-active, excellent attention to...

  • Branch Manager

    3 days ago

    Randburg, South Africa Outdoor Warehouse Full time

    This position is for experienced Managers to take on a new challenge of running our Randburg store and take full advantage of training and development initiatives to ensure we offer our customers the full Outdoor Warehouse Experience. **Key Requirements**: - Completed Matric or equivalent qualification (N3 or NQF4) - Valid driver license (vehicle) -...

  • Warehouse Associate

    4 weeks ago

    Randburg, South Africa Miui Investments Full time

    Job Responsibilities: - Responsible for receiving, inspecting, and logging incoming shipments, ensuring that the quantity and quality meet company standards. - Select, package, and label goods for shipment according to order requirements, preparing them for dispatch. - Record inventory movements using barcode scanners and warehouse management systems to...

  • Data Scientist

    2 weeks ago

    Randburg, Gauteng, South Africa Dimension Data Full time

    FunctieomschrijvingDo you want to work with the latest technology? Do you want to be part of a team that is constantly improving their product and customer experience? Would you like to work with cutting edge algorithms, machine learning and data mining tools? Are you looking for a role where you will make an impact on our business results? We are looking...

  • Data Scientist

    4 weeks ago

    Randburg, South Africa Dimension Data Full time

    FunctieomschrijvingDo you want to work with the latest technology? Do you want to be part of a team that is constantly improving their product and customer experience? Would you like to work with cutting edge algorithms, machine learning and data mining tools? Are you looking for a role where you will make an impact on our business results? We are looking...

  • Warehouse Associate

    2 weeks ago

    Randburg, Gauteng, South Africa Miui Investments Full time

    Job Responsibilities: Responsible for receiving, inspecting, and logging incoming shipments, ensuring that the quantity and quality meet company standards. Select, package, and label goods for shipment according to order requirements, preparing them for dispatch. Record inventory movements using barcode scanners and warehouse management systems to maintain...

  • Enterprise Data Architect

    1 week ago

    Randburg, South Africa Dimension Data Full time

    **Requirements - OLAP architectures to increase data sharing and provide end users with relevant information - Creates, enhances, or modifies OLAP and ETL (Extract-Transform-Load) designs to meet business needs - Determines which data extracts can be integrated into BI tools - Develops and implements real-time BI tools - Owner, custodian and champion of the...

  • Warehouse Manager

    3 weeks ago

    Randburg, South Africa Independent CL Full time

    Receiving and dispatching of stock. Balancing of stock. Management of warehouse staff. Weekend work required. 5 yrs stock management experience. **Job Type**: Permanent Pay: R10 000,00 - R10 001,00 per month **Experience**: - Sales: 5 years (preferred) Application Deadline: 2024/05/01 Expected Start Date: 2024/05/02

  • Enterprise Data Architect

    2 weeks ago

    Randburg, Gauteng, South Africa Dimension Data Full time

    **Requirements OLAP architectures to increase data sharing and provide end users with relevant information Creates, enhances, or modifies OLAP and ETL (Extract-TransformLoad) designs to meet business needs Determines which data extracts can be integrated into BI tools Develops and implements realtime BI tools Owner, custodian and champion of the enterprise...

  • Enterprise Data Architect

    2 weeks ago

    Randburg, South Africa Dimension Data Full time

    As an Enterprise Data Architect, you'll be responsible for designing and developing the company's data infrastructure. You'll work with IT to ensure that all of our data sources are secured and compliant. You will also support business by integrating information from different systems into one central location so that we can analyse it in order to make...

  • Azure Data Engineer

    2 weeks ago

    Randburg, Gauteng, South Africa Dimension Data Full time

    FunctieomschrijvingAre you tired of micro-managing your Azure servers? Do you want to work with one of the best teams in the region? Apply for this Azure Data Engineer roleOur client requires an Azure Data Engineer to develop, deploy and monitor data pipelines across the Data Lake and into Synapse. Develop PowerBI data sets and data flows and develop curated...

  • Azure Data Engineer

    4 weeks ago

    Randburg, South Africa Dimension Data Full time

    FunctieomschrijvingAre you tired of micro-managing your Azure servers? Do you want to work with one of the best teams in the region? Apply for this Azure Data Engineer role!Our client requires an Azure Data Engineer to develop, deploy and monitor data pipelines across the Data Lake and into Synapse. Develop PowerBI data sets and data flows and develop...

  • Enterprise Data Architect

    2 weeks ago

    Randburg, Gauteng, South Africa Dimension Data Full time

    As an Enterprise Data Architect, you'll be responsible for designing and developing the company's data infrastructure. You'll work with IT to ensure that all of our data sources are secured and compliant. You will also support business by integrating information from different systems into one central location so that we can analyse it in order to make...

  • Kza warehouse

    2 weeks ago

    Randburg, Gauteng, South Africa Krones Southern Africa (Pty) Ltd Full time

    Division Logistics / Intra Logistics / Materials Management Company Krones Southern Africa (Pty) Ltd Location Randburg, South Afrika Join as Professionals Worktime FulltimeKrones Southern Africa is located in Lanseria, Johannesburg, and is a subsidiary of Krones AG in Neutraubling Germany, a major company internationally recognized as the world leader in the...